216月/130
Mysql 导入CSV数据
MYSQL LOAD DATA INFILE命令可以把csv平面文件中的数据导入到数据库中。
linux下:
- LOAD DATA INFILE '/home/test/dump/ip_location.csv'
- INTO TABLE ip_location
- CHARACTER SET utf8
- FIELDS TERMINATED BY ',' ENCLOSED BY '"';
--CHARACTER SET :mysql字符集,一定要加上,免去乱码麻烦
--INTO TABLE :导入到哪个表
--FIELDS TERMINATED BY :以什么作为分割符
-- ENCLOSED BY :被什么包围
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:这个与linux不同,以什么作为一行的结尾。
Leave a comment