MySQL 区分大小写查询

Question

MySQL 区分大小写查询

SELECT *
FROM t_aw_info
WHERE alias COLLATE UTF8_BIN LIKE '%aw_test%'

MySQL 不区分大小写查询

SELECT *
FROM t_aw_info
WHERE alias COLLATE UTF8_GENERAL_CI LIKE '%aw_test%'

按中文排序

SELECT * FROM testbot_aw_test.t_aw_info  order by convert(alias using gbk) asc;

MySQL 备份还原

mysqldump -h *.*.*.* -u root --password=root testbot_aw_pro > testbot_aw_pro.20180921.sql
zip testbot_aw_pro.20180921.zip testbot_aw_pro.20180921.sql

还原

CREATE DATABASE `testbot_aw_pro` DEFAULT CHARACTER SET utf8  DEFAULT COLLATE utf8_general_ci;
source testbot_aw_pro.20180608.sql