SQLyog导入csv文件sql
LOAD DATA LOCAL INFILE 'E:\mobilearea.csv'
INTO TABLE crmhdcc.t_mobilearea CHARACTER SET gbk
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '"'
LINES TERMINATED BY '\r\n'(
id,
m_pref
原创
2015-09-11 11:27:36 ·
1926 阅读 ·
0 评论