How to import data from Excel to MySql in phpMyAdmin

Import failed at the beginning.

The generated SQL statement is incorrect.

SQL query:

Insert into 'CC _ present '. 'C _ City' ('A',' B ', 'C') VALUES (NULL, 1, 'city ')...

In this way, the column name is changed to A, B, and C.

There are two problems.

1. Add the column name to the Excel file

Note that the Sheet name in Excel should be the table name, as shown below.

2. Select ignore first line.

Of course, the table name and field name must be consistent with the mySQL definition, and the data type and length must be correct before the import can be successful.