mysql 建GBK 区分大小写的数据库库
create database database_name DEFAULT CHARACTER SET gbk COLLATE gbk_bin;
建用户
CREATE USER 'thesis'@'127.0.0.1' IDENTIFIED BY 'thesis-123';
授权
GRANT ALL ON *.* TO 'thesis'@'127.0.0.1';
刷新
flush privileges;
csv导出select查询内容
select paper_id,title from t_paper where bank_id=2 into outfile '/tmp/paper_bank_2233.csv' fields terminated by ','optionally enclosed by ''lines terminated by '\n';