mysql 遇到的坑

mysql 不区分大小写

命令行启动mysql

mysql -u root -p

修该表,数据库编码

ALTER TABLE tableName CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER DATABASE databaseName CHARACTER SET utf8 COLLATE utf8_general_ci;

查看database

show create database databaseName;

导入mysql

source /pathOfMysql/2016-04-20.sql