According to the online tutorials, excel is saved as a TXT, first change the encoding to utf-8, then constructs the import table,
Import statements: the load data local infile 'E:/data2. TXT' into table birthday fields terminated by '\ t';
TXT screenshots:
Table screenshots:
The problem:
The imported data:

The first data into error, need to consult how to change, thanks, Mysql version: 5.7.19

CodePudding user response:

Check export UTF8 TXT file? Archived for ANSI,

CodePudding user response:

reference 1st floor ACMAIN_CHM response:

check export UTF8 TXT file? Archived for ANSI,

Has been confirmed, is utf-8,

CodePudding user response:

Archived for ANSI