1 增删字段
ALTER TABLE <表名> DROP <字段名>; // 删除字段
ALTER TABLE table_name ADD COLUMN column_name VARCHAR(100) DEFAULT NULL COMMENT '新加字段' // 新建字段
2 查表字段结构
select * from information_schema.columns where table_schema='%s' and table_name='%s' order by ORDINAL_POSITION
3 自增序列相关
// 查询当前自增序列值
select AUTO_INCREMENT from information_schema.tables where table_schema='%s' and table_name='%s'
// 更新自增序列值
UPDATE __all_sequence SET current_value = %s WHERE sequence_name = (select sequence_name from (select strsplit(sequence_name, '_', 3) as table_id, sequence_name from __all_sequence where sequence_name like '%%auto_increment%%' and current_value != 0) t1 inner join (select table_id from __first_tablet_entry WHERE db_name = '%s' AND table_name = '%s') t2 on t1.table_id = t2.table_id)"
4 查看数据库当前数据容量
select concat(round(sum(data_length/1024/1024/1024),2),‘GB’) as data from information_schema.tables where table_schema=‘test’ and table_name=‘test’;
5 查询数据库中分区表状态
SELECT TABLE_NAME, PARTITION_NAME, PARTITION_METHOD, PARTITION_EXPRESSION, PARTITION_DESCRIPTION, TABLE_ROWS FROM information_schema.PARTITIONS WHERE TABLE_SCHEMA='%s';
持续更新。。。