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_prefix,
areacode,
areaname,
operators
)
SQLyog导入csv文件sql
最新推荐文章于 2023-08-14 18:28:16 发布