Heidi Creates the LOAD script that can be re-used?

[expired user #9339]'s profile image [expired user #9339] posted 8 years ago in Import/Export Permalink
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?
ansgar's profile image ansgar posted 8 years ago Permalink
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.

Please login to leave a reply, or register at first.