load data infile ‘E:/sqlResult_1482078.csv’
into table data10
fields terminated by ‘,’ optionally enclosed by ‘”’ escaped by ‘”’
lines terminated by ‘\r\n’;
CSV文件导入数据库的sql
最新推荐文章于 2024-07-19 09:30:00 发布
load data infile ‘E:/sqlResult_1482078.csv’
into table data10
fields terminated by ‘,’ optionally enclosed by ‘”’ escaped by ‘”’
lines terminated by ‘\r\n’;