How to fix import csv just had header lost data?

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
Avatar
Yuriy Vinogradov
Comment actions Permalink

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

0
Comment actions Permalink

OK,I had uploaded the file.

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

0
Avatar
Yuriy Vinogradov
Comment actions Permalink

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?

0
Comment actions Permalink

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"

 

0
Avatar
Yuriy Vinogradov
Comment actions Permalink

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.

0
Comment actions Permalink

Can we close this?

0

Please sign in to leave a comment.