摘要:
将文本内容导入mysql数据库中导入语句加入字符集,否则乱码character set gbk;因为name列加了唯一索列,加这个是为避免重复数据插入报错ignore into table把相同的先删除掉replace into table[linux]这里关键load data infile '/tmp/t0.txt' ignore into table t0 character set gbk fields terminated by ',' enclosed by '"' lines terminated by '\n 阅读全文