Shulou(Shulou.com)05/31 Report--

This article shows you how to import csv files into mysql in navicat. The content is concise and easy to understand, which will definitely brighten your eyes. I hope you can get something through the detailed introduction of this article.

1. Open navicat, connect to the database, and find the table you want to import data into. The database table is under the table under the specified database.

two。 Right-click the data table. Click import wizard.

3. Select the file type to import data. In this paper, take the csv file as an example, select the csv file.

4. Next, select the location of the file. You can click the ellipsis after the first empty input box to locate your own file by browsing the file system. The following encoding chooses the same encoding as your file.

5. The first option is record splitting, which can be used by default, the second option is the field delimiter, and the csv file is split by default.

6.field name row indicates the location of the field name, which is usually the first line. First data row indicates the location of the first piece of data. If there is no field name, the row is 1, and if there is a field name, the row is 2. Last data row represents the location of the last piece of data. If only the first number of pieces of data can fill in the location of the last piece of data here, if this is empty, all data will be imported by default. The following is the formatting, date order represents the location of the date showing the middle-aged month and day, Y represents the year, M represents the month, and D represents the day, the selection here is based on your own file as a reference, date delimiter represents the delimiter in the date, and time delimiter represents the separator in the time display. The following can use the default. For example, if my file is 2010-10-11 12:12:12, then date order is YMD,date delimiter-and time delimiter is:.

7.source table represents the location of the data store, and target table represents the table in which the data is imported.

8. Indicates the data flow direction, and the data of the user_id in the source table will be imported into the user_id of the target table.

9. There are two ways to import data, one is append, which means to add data after an existing record. The other is copy, which means to delete existing data and then add data.

10. Click start to begin execution.

The above is how to import csv files into mysql in navicat. Have you learned any knowledge or skills? If you want to learn more skills or enrich your knowledge reserve, you are 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.