CREATE TABLE STUINFO(
stuID INT AUTO_INCREMENT PRIMARY KEY,
/* AUTO_INCREMENT:设置自增 */
stuName nvarchar ( 20 ) NOT NULL,
stuSex nvarchar ( 10 ) NOT NULL,
stuAddress nvarchar ( 50 ),
stuClass nvarchar ( 30 )
);
/* 设置自增基数 */
ALTER TABLE stus AUTO_INCREMENT = 10001;
/* 设置自增量 */
ALTER TABLE stus AUTO_INCREMENT_INCREMENT = 1;