Import csv file into mysql using navicat

This article shares the specific code for importing csv files into mysql using navicat for your reference. The specific content is as follows

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

2. Right-click the data table. Click import wizard.

3. Select the file type to import data. This article takes csv file as an example and selects 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. Select the same encoding as your file.

5. The first option is record segmentation, you can use the default, the second option is field separator, csv file default ， segmentation.

6.field name row indicates the location of the field name, usually the first row. First data row indicates the position of the first data. If there is no field name, the value is 1. If there is a field name, the value is 2. The last data last data row . If only the first few data are needed, the position of the last data can be filled in here. If this is empty, all data will be imported by default. Below is the format setting. date order indicates the position of year, month and day in the date display. Y represents year, M represents month and D represents day. The selection here is based on your own file. date delimiter represents the separator in the date and time delimiter represents the separator in the time display. The following can be used by default. For example, if the date in my file is 2010-10-11 12：12：12 , date order is YMD , date delimiter is - , and time delimiter is ： .

7.The source table indicates the location where the data is stored, and the target table indicates the table into which the data is imported.

8. Indicates the data flow direction. The user_id data 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 adding data after existing records. The other is copy , which means deleting the existing data and then adding data.

10. Click start to begin execution.

The above is the full content of this article. I hope it will be helpful for everyone’s study. I also hope that everyone will support 123WORDPRESS.COM.