修改:
alter table tablename change tableprimary tableprimary smallint auto_increment
注解:tablename 表名
tableprimary 主键 自动增加键
如上修改必须重复写两次主键名:如:
alter table users change usrid usrid smallint auto_increment;
创建:
CREATE TABLE test
(
id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
username VARCHAR(15) NOT NULL
)
AUTO_INCREMENT = 100;