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

This article is an example to share the method of importing Excel files into MySQL database for your reference. The details are as follows.

1. Introduction

This blog shares a practical little skill. We often need to add the Excel data we need when using the database. If we follow the traditional method, it will be time-consuming and laborious, so we share the skills of importing Excel data.

2. Practical operation

1) first, you need to download a database management tool called Navicat for MySQL. You can download Navicat for MySQL from the following URL. After the download and installation is complete, you can do so.

2) I will take a CET-6 vocabulary as an example. The screenshot of the vocabulary is as follows:

It includes vocabulary, translation and mnemonic methods.

3) create a new table named "english" using Navicat, and go to the following interface:

4) directly click "Import Wizard", and select the Excel file in .xls format, as shown below:

5) Click the next step directly, and then you need to add the path of the excel table, and select the sheet to which you want to add content, as shown below:

6) after clicking the next step, you need to select "Field name Row" and "first data Row". These two parts are operated according to the actual situation, as shown below:

7) then click next until you enter the following interface to view the correspondence between the target field and the original field, as shown below:

8) after confirming that the correspondence is correct, click next, then select add, and then click next to click start. After the import is completed, you will be prompted as shown below:

9) after the operation is completed, open the english table in the MySQL database again to see if the dumping is successful, as shown below:

3. Summary

In the later blog, I will share the word query Mini Program made by Java programming. at that time, the program will need to connect to the database and call the table. It can be said that it is just a pre-task now. I hope you can learn how to import Excel into the MySQL database.

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.