HeidiSQL 7.0.0.4389
mysql table:
create table tab (f varchar(60) not null default '');
import a csv file, contains:
"abcdefg"
"12345"
"001"
"110119"
"test foo"
"bar"
"egg"
"python"
"script"
"go aheard"
Logs in HeidiSQL out put window:
INSERT LOW_PRIORITY IGNORE INTO `digg`.`tab` (`f`) VALUES ('12345"'), ('001"'), ('110119"'), ('test foo"'), ('bar"'), ('egg"'), ('python"'), ('script"'), ('go aheard"');
bug: Import one-field csv file, right Quotation marks will insert into field.
Please login to leave a reply, or register at first.