MySQL执行线上操作

CREATE TABLE douyin_kol_account_20220315 LIKE douyin_kol_account;
alter table douyin_kol_account_20220315 modify `avatar`  text COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '达人头像';

START TRANSACTION;
INSERT INTO douyin_kol_account_20220315 SELECT * FROM douyin_kol_account;
RENAME TABLE douyin_kol_account to douyin_kol_account_20220315_old;
RENAME TABLE douyin_kol_account_20220315 to douyin_kol_account;
commit;