Excel import to MySQL

First, remove the column headers and save the file in CSV format, such as Data.csv.

Then, you must use Notepad to open the Data.csv and save it as one side, and note that the selection encoding is consistent with the database table

(View the database's table-building statements and the encoded SQL statements: Show CREATE TABLE table_name)

Then, open MySQL, set up the corresponding table in the database, and note that the column should correspond

Last USE statement: Load data infile ' f:/input/data.csv ' into table Hanzi fields terminated by ', ' lines terminated by ' \ r \ n ';

The import is complete.

Excel import to MySQL