添加表字段
alter table table1 add transactor varchar(10) not Null;alter table table1 add id int unsigned not Null auto_increment primary key修改主键
ALTER TABLE `test2` DROP PRIMARY KEY ,ADD PRIMARY KEY ( `id` )增加索引
ALTER TABLE `test2` ADD INDEX ( `id` )ALTER TABLE `category ` MODIFY COLUMN `id` int(11) NOT NULL AUTO_INCREMENT FIRST ,ADD PRIMARY KEY (`id`);| 留言与评论（共有 0 条评论） “” |
