开发者

MySQL DDL script with foreign key relationships

I reverse engineered a MySQL database into MySQL Workbench--the foreign key relationships are not there. I then went to phpMyAdmin and did an SQL dump. The foreign key relationships are not defined in the script. Is it possible to have the foreign key relationships included in the SQL dump?

Background Information:

When setting up the options for the DDL script, under the 'Structure' secti开发者_C百科on of the export I selected two options: - Add AUTO_INCREMENT value, and - Enclose table and field names with backquotes.

The engine is InnoDB. I'm using MAMP community edition.


It is possible that db doesn't have FK rel-s at all, can this be the case?

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜