distal-attribute
distal-attribute
distal-attribute
distal-attribute

bug: Import one-field csv file, right Quotation marks will insert into field.

User, date Message
Written by fengyqf
1 year ago
Category: Import/Export
7 posts since Wed, 10 Apr 13
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"');

Written by kalvaro
1 year ago
591 posts since Thu, 29 Nov 07
So you got extra trailing quotes?

I've not been able to reproduce it :-?
Written by ansgar
1 year ago
4961 posts since Fri, 07 Apr 06
The relevant question is: what did you enter in the four control characters boxes of the import dialog?
Written by fengyqf
1 year ago
7 posts since Wed, 10 Apr 13
I have known, the Control characters boxes.
The one-field csv file is terminated by \r\n ,but I inputed \n for "Lines terminated by", so ,the right quotation marks was filed into the field.

Many Many Thanks!
 

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