USE vain;
ALTER TABLE stuinfo MODIFY COLUMN stuname VARCHAR(20)NOT NULL;
DESC stuinfo;
ALTER TABLE stuinfo MODIFY COLUMN age INT DEFAULT 18;
ALTER TABLE stuinfo ADD PRIMARY KEY(id);
ALTER TABLE stuinfo ADD UNIQUE(seat);
ALTER TABLE stuinfo ADD FOREIGN KEY(majorid)REFERENCES major(id);
ALTER TABLE stuinfo MODIFY COLUMN stuname VARCHAR(20) NULL;
ALTER TABLE stuinfo MODIFY COLUMN age INT;
ALTER TABLE stuinfo DROP PRIMARY KEY;
ALTER TABLE stuinfo ADD PRIMARY KEY(id);
ALTER TABLE stuinfo DROP INDEX seat;
SHOW INDEX FROM stuinfo;
CREATE TABLE tab_identity
(
id INT PRIMARY KEY AUTO_INCREMENT,
NAME VARCHAR (20));
INSERT INTO `tab_identity`(NAME) VALUES('join');
SELECT * FROM `tab_identity`;
SHOW VARIABLES LIKE '%auto_increment%';
SET auto_increment_increment=1;
INSERT INTO `tab_identity`(NAME) VALUES('join');
ALTER TABLE `tab_identity` MODIFY COLUMN id INT;
DESC `tab_identity`;
ALTER TABLE `tab_identity` MODIFY COLUMN id INT AUTO_INCREMENT;