1 修改表名称
ALTER `tablename` `name1` RENAME TO `name2`;
2 mysql给表新增字段
ALTER TABLE `tablename` ADD COLUMN `colname` VARCHAR(512) DEFAULT '';
3 在某个字段后新增字段
ALTER TABLE `tablename` ADD COLUMN `field2` INT(11) NOT NULL DEFAULT 0 AFTER `field1`;
4 更新表字段值
UPDATE `tablename` SET `field1`=new-value1, `field2`=new-value2 [WHERE Clause];
5 修改字段名称
ALTER TABLE `tablename` CHANGE `field1` `field2` VARCHAR(20) NOT NULL;
6 修改字段类型(不修改名称)
ALTER TABLE `tablename` MODIFY COLUMN `field1` VARCHAR(128) NOT NULL DEFAULT '';
7 删除字段
ALTER TABLE `tablename` DROP `field1`;
8 调整字段顺序
ALTER TABLE `tablename` CHANGE `field1` `field1` INT(11) NOT NULL AFTER `field2`;