MYSQL数据库字段字符集查看修改

查看表字符集

SHOW TABLE STATUS FROM kakasure WHERE COLLATION = 'utf8_general_ci'

SHOW TABLE STATUS FROM kakasure WHERE NAME = 'kks_order_vendor';

SHOW TABLE STATUS FROM kakasure WHERE NAME = 'sso_user';

查看执行计划

EXPLAIN SELECT * FROM kks_store_code a , sso_user b WHERE b.id = a.user_Id;

查看表字段字符集

SHOW FULL COLUMNS FROM sso_user;

修改表字段字符集

ALTER TABLE sso_user MODIFY COLUMN id VARCHAR(32) CHARACTER SET utf8mb4 NOT NULL;