How to fix import csv just had header lost data?

创建于 2021年06月21日 14:00

I had a problem about import CSV into my DataBase,I searched this question on Google and didn't find the answer, I can only ask you guys.

I used import data from file,and set everything,it looked perfect in preview.But after the importing progress,the new table just had the header of table with no data.

I don't know which option was set wrong.

Picture1 is the preview,picture2 is the table now.

The CSV file is in the attachment,with the error report.

6 条评论

Yuriy Vinogradov

创建于 2021年06月23日 09:30

please upload CSV and error report to https://uploads.jetbrains.com/ and provide upload ID.

ZhuRui

创建于 2021年06月23日 10:33

OK,I had uploaded the file.

Upload id: 2021_06_23_UAMNbRTsfa9DLG3T (file: ddm_cpc.csv)

Yuriy Vinogradov

创建于 2021年06月23日 11:21

i have imported it without any issues with default settings and 'first row is header'

please try import again and if you receive error report - share it.

also what is your MySQL server version?

ZhuRui

创建于 2021年07月06日 04:19

OK,I try this again,same problem,this is the error report.

Upload id: 2021_07_06_9TMJEiKL7h1YCBpo (file: ddm_cpc_1_2021_07_06_12_08_27.txt)

And MySQL information is "Ver 14.14 Distrib 5.7.27,for Win64"

Yuriy Vinogradov

创建于 2021年07月08日 23:32

we can't reproduce the issue, please try to import values this way:

create table import_test( col text);
insert into import_test (col) values ('美团'), ('蛙小辣火锅杯（合生汇店）');

run this query in console.

Also please read this thread, there are some useful hints.

Maxim Sobolevskiy

创建于 2021年08月02日 09:06

Can we close this?

请先登录再写评论。