Skip to content
Advertisement

Foreign Key constraints missing after phpmyadmin export

I create a table in mysql using the following script:

When I export the created table from phpMyAdmin, I obtain the following script

So the question are: where is my foreign key constraints? does KEY refer to FK? Seems that the two tables utente and attivita are no longer referenced in the new generated script. where am I doing wrong?

EDIT

In phpMyAdmin, configuring the export of the table I found the option “Display Foreign Key Relationship” If I flag this option I otain also this code in the script

This means that if I add the option “Display Foreign Key Relationship” I obtain also the FK constrains? in other case not?

Advertisement

Answer

So the question are: where is my foreign key constraints?

They are defined in the database. The output from SHOW CREATE TABLE users_x_activities will include the foreign key constraint definitions.

The definitions of the foreign key constraints likely appear in separate ALTER TABLE statements at the end of the generated script.

does KEY refer to FK?

No. KEY id_user (id_user) here refers to an index.

Seems that the two tables utente and attivita are no longer referenced in the new generated script.

Yes, you are correct. The foreign key constraints are not included in the CREATE TABLE statement.

where am I doing wrong?

A MySQL SHOW CREATE TABLE users_x_activities will include the foreign key constraints.

The foreign key constraints are likely included in the script generated by phpMyAdmin, but at the end of the script, in separate ALTER TABLE statements.

User contributions licensed under: CC BY-SA
2 People found this is helpful
Advertisement