用PHPMyAdmin的MYSQL中遇到的问题(我是新手)
从选项中找不到设置外键,写SQL又总报错。谁能给我一个2个表用外键的简单例子(可以用SQL来写)在PHPMyAdmin能行的通的,清楚明了的有赏,谢谢!
------解决方案--------------------参考: 
 CREATE TABLE parent (id INT NOT NULL, 
                      PRIMARY KEY (id) 
 ) ENGINE=INNODB; 
 CREATE TABLE child (id INT, parent_id INT, 
                     INDEX par_ind (parent_id), 
                     FOREIGN KEY (parent_id) REFERENCES parent(id) 
                       ON DELETE CASCADE 
 ) ENGINE=INNODB;