1、重命名表名:
ALTER TABLE tasks RENAME TO work_items;
2、添加列到表中:
ALTER TABLE tasks ADD COLUMN complete DECIMAL(2,1) NULL AFTER description;
3、删除表中的列:
ALTER TABLE tasks DROP COLUMN description;
4、更改列的属性:
ALTER TABLE tasks CHANGE COLUMN task_id task_id INT(11) NOT NULL AUTO_INCREMENT;