I am able to manually import my .csv files using HeidiSQL. I need to automate this task, and googled and found a page that states "My favourite for the job is Windows based HeidiSQL. It gives you a graphical interface to build the LOAD DATA command; you can re-use it programmatically later."
Exactly where does HEIDISql store this LOAD DATA command and how can I program this to kick off automatically? Is that possible?
Heidi Creates the LOAD script that can be re-used?
HeidiSQL fires this LOAD DATA command when you import a text file via Tools > CSV file - at least on MySQL, when you select "Method: Server parses file contents"
You cannot, however, schedule HeidiSQL to fire that query. For scheduling query execution, I recommend using mysql.exe as a command line.
You cannot, however, schedule HeidiSQL to fire that query. For scheduling query execution, I recommend using mysql.exe as a command line.
Please login to leave a reply, or register at first.