I'm enjoying using SQLyog but I have one major niggle.
When I come to populate a load of tables with CSV data – using Ctrl-Shift-M – I have to change the CSV import parameters every single time.
I'm in Windows XP exporting from FoxPro thus I need to set parameters to
FIELDS ESCAPED BY (NA)
LINES TERMINATED BY rn
FIELDS TERMINATED BY ,
FIELDS ENCLOSED BY “
It remembers my setting (under Other Options) of IGNORE 1 lines, why can't it remember the other parameters?
Alternatively, could this be part of Tools/Preferences?