Troubleshoot Issues in MySQL

Mysql 无法更新表

1. 查询是否有锁表。

       SHOW OPEN TABLES WHERE In_use > 0;
   

2. 查询是否有正在执行的事务

       SELECT * FROM INFORMATION_SCHEMA.INNODB_TRX;
   

Sort Chinese text fields alphabetically by first letter

UTF8 default Proofing set is Utf8_general_ci, it is not in Chinese. You need to force MySQL to sort by Chinese.

select * FROM MyTable ORDER by CONVERT (Chinesecolumnname USING GBK) COLLATE gbk_chinese_ci;

为了达到更快更效率的查询，需要另外再建立一个索引列，并在索引列中插入标签字第一个字母或者是拼音。