Shulou(Shulou.com)06/01 Report--

This article mainly introduces how phpmyadmin imports excel data into mysql in batches. It is very detailed and has certain reference value. Friends who are interested must finish reading it.

First of all, we get an excel table with a lot of data to import.

Delete the first line "id"XXX". To keep only the part of the data we need

Click File-Save as, select CSV (comma separated) (* .csv) as the type, and save the excel table as an csv document. (select "OK" for all subsequent prompts.)

Ee.csv saved as can be opened with a text editor such as notepad or notepadd++. Let's open it and have a look. You can see that the csv document is actually txt (that is, you can use your own txt and change the suffix), but separate the fields with ",".

Go to phpMyAdmin to create a table and create a new field with the field name associated with the excel field you want to import in the same order.

Open the table you just created in phpMyAdmin and click Import at the top.

Import File format Select the second CSV uses LOAD DATA.

File to Import Select the csv file you just saved as.

The "field delimiter" is changed to ",", which is the "(comma delimited)" saved by excel as the default choice, and you are free to choose the delimiter, usually if there is a "," in your excel table data.

"Field name" is an advanced application, where the field name is the field name in your data table, which indicates the field you want to populate, separated by ",". If it is empty here, it means that it is all filled, and it is filled in order. Do not use the excess data.

Then click "execute".

After that, it is prompted that "if the import is successful, you can open the table to view the data import has been successful."

The above is all the contents of the article "how phpmyadmin imports excel data into mysql in bulk". Thank you for reading! Hope to share the content to help you, more related knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.