本文介绍了一种使用MySQL语句进行数据表创建、字符集转换及CSV文件数据加载的方法。具体步骤包括：通过`CREATE TABLE... LIKE...`语句复制已有表结构；使用`ALTER TABLE... CONVERT TO CHARACTER SET...`修改表字符集；最后利用`LOAD DATA INFILE...`命令将CSV文件的数据批量导入到指定的表中。
#导入数据
create table 表1 like 表2;
ALTER TABLE 16_nian CONVERT TO CHARACTER SET gbk COLLATE gbk_chinese_ci;
load data infile 'C:/ProgramData/MySQL/MySQL Server 5.7/Uploads/WORKs.csv' into table 16_nian
character set gbk
fields terminated by ','
optionally enclosed by '"'
escaped by '"'
lines terminated by '\r\n'
ignore 1 lines;
create table 表1 like 表2;
ALTER TABLE 16_nian CONVERT TO CHARACTER SET gbk COLLATE gbk_chinese_ci;
load data infile 'C:/ProgramData/MySQL/MySQL Server 5.7/Uploads/WORKs.csv' into table 16_nian
character set gbk
fields terminated by ','
optionally enclosed by '"'
escaped by '"'
lines terminated by '\r\n'
ignore 1 lines;
扫一扫
286
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
