Troubleshoot Issues in MySQL

February 10, 2023 125 words 1 min

Table of Contents

Mysql 无法更新表
Sort Chinese text fields alphabetically by first letter

Mysql 无法更新表

查询是否有锁表。
```
    SHOW OPEN TABLES WHERE In_use > 0;
```

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

    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;

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

Links to this note

Database