1
2
3
4
5
6
7
8
9
10
11
12
13
14
| //查询表大小
SELECT table_schema,TABLE_NAME,round((DATA_LENGTH+INDEX_LENGTH)/1024/1024,2) as M,TABLE_ROWS
FROM information_schema.TABLES order by M desc;
//复制表
CREATE TABLE targetTable LIKE sourceTable;
INSERT INTO targetTable SELECT * FROM sourceTable;
//修改排序字符集
//表
ALTER TABLE `hx-farm_sit`.`t_synergy_task` COLLATE=utf8mb4_general_ci;
//字段
ALTER TABLE `hx-farm_sit`.`t_synergy_task` MODIFY COLUMN `task_code` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '任务编码，规则：C+年月日+****';
|
