复制mysql> CREATE TABLE species (id TINYINT NOT NULL AUTO_INCREMENT,外完整 name VARCHAR(50) NOT NULL, PRIMARY KEY(id)) ENGINE=INNODB; Query OK, 0 rows affected (0.11 sec) mysql> INSERT INTO species VALUES (1, orangutan), (2, elephant), (3, hippopotamus), (4, yak); Query OK, 4 rows affected (0.06 sec) Records: 4 Duplicates: 0 Warnings: 0 mysql> CREATE TABLE zoo (id INT(4) NOT NULL, name VARCHAR(50) NOT NULL, FK_species TINYINT(4) NOT NULL, INDEX (FK_species), FOREIGN KEY (FK_species) REFERENCES species (id), PRIMARY KEY(id)) ENGINE=INNODB; 1.2.3.4.5.6.7.8.9. |
喜欢
讨厌