mysql 大字段 脚本_mysql字段修改脚本

-- help_text:帮助说明

-- help_content

-- raw

USE pro_seal_chip_sell_portal_v1;

-- 表修改

ALTER TABLE `help_text` CHARACTER SET = utf8mb4, COLLATE = utf8mb4_general_ci;

-- 字段修改

-- ALTER TABLE `user` MODIFY COLUMN `username` VARCHAR(105) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT "默认" COMMENT ‘默认‘;

-- ALTER TABLE `user` MODIFY COLUMN `dtime` DATETIME DEFAULT CURRENT_TIMESTAMP COMMENT ‘默认时间‘;

-- ALTER TABLE `user` ADD INDEX index_u_name (`username`) COMMENT ‘创建index_u_name索引‘;

ALTER TABLE `help_text` MODIFY COLUMN `help_content` LONGTEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;

ALTER TABLE `help_text` MODIFY COLUMN `raw` LONGTEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;

原文：https://www.cnblogs.com/sung1024/p/11700287.html