表结构修改
1.表结构修改
修改表名:ALTER TABLE tb_name RENAME TO new_name;
修改字段名:ALTER TABLE tb_name CHANGE COLUMN old_name new_name data_type;
修改字段类型:ALTER TABLE tb_name MODIFY COLUMN field_name data_type
添加字段:ALTER TABLE tb_name ADD COLUMN field_name data_type;
删除字段:ALTER TABLE tb_name DROP COLUMN field_name;