phpMyAdmin to import data from Excel into Mysql graphics and text method _mysql

The initial import failed.

The generated SQL statement is incorrect.

SQL Query:

INSERT into ' cc_present '. ' C_city ' (' A ', ' B ', ' C ') VALUES (NULL, 1, ' Municipal District ') ...

Like this the column name becomes A,b,c.

The problem is in two places.

1. Need to add column name to Excel file

Also note that the sheet name for Excel should be the name of the table, as shown below.

2. Ignore the first line option to check

Of course, the table name and field name should be consistent with the MySQL definition, and the data must be of the same type and length to be successfully imported.