load data infile ‘C:/test1.csv’
into table table_name
fields terminated by ‘,’
optionally enclosed by ‘"’
escaped by ‘,’
lines terminated by ‘\r\n’
ignore 1 lines;
第八周xls文件转成csv文件,将其导入数据库
最新推荐文章于 2021-12-26 13:16:33 发布
load data infile ‘C:/test1.csv’
into table table_name
fields terminated by ‘,’
optionally enclosed by ‘"’
escaped by ‘,’
lines terminated by ‘\r\n’
ignore 1 lines;