How to fix import csv just had header lost data? Follow

Created June 21, 2021 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 comments

Yuriy Vinogradov

Created June 23, 2021 09:30

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

ZhuRui

Created June 23, 2021 10:33

OK,I had uploaded the file.

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

Yuriy Vinogradov

Created June 23, 2021 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

Created July 06, 2021 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

Created July 08, 2021 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

Created August 02, 2021 09:06

Can we close this?

Please sign in to leave a comment.