How to Bulk Import Excel data into a database (MYSQL)--Tools phpMyAdmin

Before because data storage uses Excel to save all the data, after preliminary data filtering, the amount of data is nearly 4,000. A single entry into the database is obviously not feasible. Here are the steps I'm working on:

1. Keep only the data part of Excel, remove the specific description of the first line

2. Save the file as (. csv) format

3. Save the file that you just saved in CSV format with TXT open again as

Attention! The code changes to UTF-8 this step must have, otherwise the import is very likely to appear garbled.

4. In phpMyAdmin, create a table in data order, new field, field name associated with the Excel table field you want to import, and in the same order.

5. Click "Import" and "Select File" (CSV file just changed)

6. Follow the changes to "format" and "Field delimiter" (Must be Comma ",")

7. Click Execute

Data can be successfully imported spicy ~

If the data appears garbled,

Please recall

(1) Is it successful to change UTF-8?

(2) is the database character set UTF-8?

(3) Does setting the table's properties correspond to UTF-8?

(4) Sorting rules must remember to change, because the default is Latin what what?

I've met all these problems ┑ (￣д￣) ┍

(5) Help network/Great God ~

How to Bulk Import Excel data into a database (MYSQL)--Tools phpMyAdmin