一、操作基本表:
1. 修改表名:
RENAME TABLE `table1` to `table2`;
2. 为表中某字段添加/删除 主键:
ALTER TABLE `tablename` ADD PRIMARY KEY(`id`);
Alter table tb drop primary key;
3. 为表中某字段设置自增/删除 自增:
Alter `tablename` CHANGE `id` `id` INT( 6 ) NOT NULL AUTO_INCREMENT COMMENT 'columnname';
Alter table `tablename` change id id int(6);