How to import Excel files into MySQL database

This article shares with you how to import Excel files into MySQL database for your reference. The specific content is as follows

1. Introduction

This blog shares with you a practical little skill. When we use a database, we often need to add the required Excel data. If we follow the traditional method, it will be time-consuming and laborious, so I will share with you the skill of importing Excel data.

2. Actual operation

1) First, you need to download a database management tool called Navicat for MySQL. You can download Navicat for MySQL from the following website. After downloading and installing, you can operate it;

2) I will use a CET-6 vocabulary list as an example to explain. A partial screenshot of the vocabulary list is as follows:

It contains vocabulary, translations and their mnemonics;

3) Use Navicat to create a new table named "english", and then enter the following interface:

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

5) Click Next directly, then you need to add the path of the Excel table and select the sheet where the content to be added is located, as shown below:

6) After clicking Next, you need to select "Field Name Row" and "First Data Row". These two parts should be 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 column and the original column, as shown below:

8) After confirming that the correspondence is correct, click Next, then select Add, then click Next again and click Start. After the import is completed, the prompt is as shown below:

9) After the operation is completed, open the English table in the MySQL database again to check whether the import is successful, as shown below:

3. Summary

In the following blogs, I will share a small word query program made with 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 preliminary task now. I hope everyone can learn how to import Excel into MySQL database.