
复制CREATE TABLE person ( id SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT,键用
name CHAR(60) NOT NULL, PRIMARY KEY (id) )type=innoDB; CREATE TABLE shirt ( id SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT, style ENUM(t-shirt, polo, dress) NOT NULL, color ENUM(red, blue, orange, white, black) NOT NULL, owner SMALLINT UNSIGNED NOT NULL, FOREIGN KEY (owner) REFERENCES PERSON(id) ON DELETE CASCADE ON UPDATE CASCADE, PRIMARY KEY (id) )type=innoDB; 1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.