19 / 09 / 18

MySQL 常用方法

转变表CHARACTER

ALTER TABLE tb_partner DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;

转变字段CHARACTER

ALTER TABLE tb_partner MODIFY COLUMN telephone VARCHAR(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;