mysql 外键约束

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
  
  • 检查索引是否生效