0 like 0 dislike
98 views
in Education & Reference by (850 points)
Import CSV File Into MySQL Table without break any row and column

1 Answer

0 like 0 dislike
by

LOAD DATA LOCAL INFILE 'D:\aaabbb.txt' INTO TABLE table_name FIELDS
TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n';

by
0 0
Sometimes this works with \r

LOAD DATA LOCAL INFILE 'D:\TEST.csv' INTO TABLE TABLENAME FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\r\n';

Related questions

0 like 0 dislike
1 answer 1.4k views
0 like 0 dislike
1 answer 80 views
0 like 0 dislike
1 answer 169 views
0 like 0 dislike
1 answer 219 views
0 like 0 dislike
2 answers 767 views
0 like 0 dislike
1 answer 286 views
0 like 0 dislike
1 answer 74 views
0 like 0 dislike
1 answer 1k views
1 like 0 dislike
1 answer 3 views
...