1
I built the entire database and now I’m trying to do the relations, when I click on the primary key (referential) and click on the foreign key, the following error appears: "Error: Relational characteristics are disabled!"
How do I solve the problem?
4
Myisam tables do not support FOREIGN KEY.
So you have to change the database type to Innodb?
This you can select at the time of creating the database, and before creating the tables.
1
In Phpmyadmin, just enter each table, click on the tab Operations and then change the "Storage Engine" to Innodb, then execute.
After that, try creating relationships again.
Browser other questions tagged mysql sql database wamp wampserver
You are not signed in. Login or sign up in order to post.
What type of foundation have you created? Myism or Innodb?
– Marcondes
I can’t answer you, I just opened wamp and created the database
– Jefferson Souza
There in the database properties you have to analyze it. See where the tables are displayed too, will display its properties.
– Marcondes
I posted the image of the bank screen, I think it’s Myisam
– Jefferson Souza