
复制CREATE DATABASE test; CREATE TABLE parent ( id INT NOT NULL,例介
PRIMARY KEY (id) ) ENGINE=INNODB; CREATE TABLE child ( id INT, parent_id INT, childname VARCHAR(20) DEFAULT NULL, INDEX par_ind (parent_id), PRIMARY KEY (id), FOREIGN KEY (parent_id) REFERENCES parent(id) ON DELETE CASCADE ) ENGINE=INNODB; 1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.21.22.23.24.25.26.27.28.29.
(责任编辑:域名)