DDL加字段
ALTER TABLE tbname ADD COLUMN col_name [type] [DEFAULT xxx] [COMMENT 'xxx'] [AFTER name] ;
eg:
alter table zhanguo add column result String DEFAULT '' COMMENT '成功/失败' AFTER Job ;
DDL修改字段:
ALTER TABLE tbname MODIFY COLUMN col_name [TYPE] [default expr] [COMMENT 'xxx'] [AFTER name] ;
eg: ALTER TABLE zhanguo MODIFY COLUMN result2 DEFAULT '' AFTER result;
DDL删除字段
ALTER TABLE tbname DROP COLUMN col_name ;
移动数据表:
可以同库移动(修改表名/重命名),也可以跨库移动,但必须在本实例下;
rename table db1.tb1 to db2.tb2;
eg: rename table wireless_safe.wire_safe to wang.zhanguo;
清空表数据:
truncate table table_name
删除表:
DROP TABLE table_name;