Import text file dialog with new features
Another new useful thing is the option "Input file contains local formatted numbers", which basically converts the local decimal and thousand separators to those chars MySQL expects. This allows fixing wrong numbers being inserted into your database, e.g. in cases of german numbers of let's say 12.345,6789 which is parsed by the server as 12.345 . The new checkbox option solves this problem for the client parser as well as for the LOAD DATA method. Thanks to bas_vu for the hints!
Only I don't see some use case for that option, do you?
I use to import into MySQL a lot of tab delimiter txt files,
and some of them have lines starting by '\t'
I can import those files using "load data local infile .." in scripts.
In my optinion the option "Lines starting by" option was the only one missing from the "Import text file" dialog.
Anyway, thank you for HeidiSQL!
I'm using it daily for the last 6 months, and I consider it much better and more user friendly than the other MySQL front-ends I used till now.
Please login to leave a reply, or register at first.