When using php language, there is a failure to import Chinese to MYSQL in the excel file, what shoul

data->setoutputencoding('cp936');

cp936 here you change to utf-8 to try to see, Chinese is generally a coding problem.

1.Use PHP

Excel Parser Pro software, but this software is a paid software;

2.You can save the excel sheet in csv format and import it via phpmyadmin or sqlyog

Save the excel sheet as CSV;

Open SQLYOG, right-click on the ** you want to import, and click "Import" - "Import to load local CSV data";

In the dialog box that pops up, click "Change." Select "Fill in excel friendly values" and click OK;

In "Import from File", select the path of the CSV file you want to import, and click "Import" to import the data to the table.

3.A stupid manual method is to use Excel to generate SQL statements, and then run them in MySQL, which is suitable for Excel** to import to various SQL databases:

Suppose you have three columns of data, A, B, and C, and you want to import the tablename into your database, and the corresponding fields are col1, col2, and col3 respectively

Add a column to your ** and use Excel formulas to automatically generate SQL statements, the specific method is as follows:

1) Add a column (let's say column D).

2) In column d in the first row, i.e. d1, enter the formula:

concatenate("insert into tablename (col1,col2,col3) values (",a1,",",b1,",",c1,");")

3) At this point, D1 has generated the following SQL statement:

insert into table (col1,col2,col3) values ('a','11','33');

4) Copy the formula of d1 to column d in all rows (just click and hold the lower right corner of cell d1 with the mouse and drag it all the way).

5) At this point, column D has generated all the SQL statements.

6) Copy column d into a plain text file, assuming that:

Just put it in the database and run it, you can either import it from the command line or run it with phpadmin.