CREATE TABLE users(
id INT UNSIGNED PRIMARY KEY AUTO_INCREMENT,
username VARCHAR(10) NOT NULL,
pid SMALLINT UNSIGNED,
FOREIGN KEY(pid) REFERENCES provinces(id)
);
CREATE TABLE provinces(
id SMALLINT UNSIGNED PRIMARY KEY AUTO_INCREMENT,
pname VARCHAR(20) NOT NULL
);
ALTER TABLE users ADD age TINYINT UNSIGNED NOT NULL DEFAULT 10;
ALTER TABLE users ADD age1 TINYINT UNSIGNED NOT NULL DEFAULT 10 AFTER username;
- SHOW INDEXES FROM provinces
- 检查索引是否生效