MySQL: load data

load data infile 'data.csv'
into table project.tbl_data character set utf8mb4
fields terminated by ',' optionally enclosed '"' escaped by '"'
lines terminated by '\r\n';

 

posted @ 2022-02-16 11:43  ascertain  阅读(65)  评论(0编辑  收藏  举报