在MYSQL中将所有表和字段更改为utf-8-bin排序规则的脚本

#!/bin/bash

# 连接MySQL
mysql -u root -p

# 选择需要更改的数据库
use your_database;

# 循环更改所有表的排序规则
for table in $(mysql -N -e "show tables"); do
    for column in $(mysql -N -e "show columns from $table"); do
        mysql -e "alter table $table change $column $column varchar(255) character set utf8 collate utf8_bin";
    done
done

# 更改数据库排序规则
mysql -e "alter database your_database character set utf8 collate utf8_bin";