Mysql import csv file _ MySQL

Mysql imports the csv file bitsCN.com

Mysql imports csv files

The mysql load data infile command can import DATA from the csv flat file to the database.

In linux:

Load data infile '/home/test/dump/ip_location.csv 'into TABLE ip_location character set utf8 fields terminated by', 'enabledby' "'; -- character set: mysql character set, be sure to add it to avoid the trouble of garbled characters -- into table: the TABLE to which the data is imported -- fields terminated by: what is used as the delimiter -- enclosed by: What is surrounded

Windows:

Load data infile "d:/insert_data.csv" replace into table demo character set gb2312 fields terminated by "," enclosed by "" lines terminated by "/r/n "; -- lines terminated by: this is different from linux. what is used as the end of a line.

BitsCN.com