Error creating relationships in MySql using WampServer

Navigation
0

I've set up the whole database and now I'm trying to make the relationships, when I click on the primary key (referential) and click on the foreign key, the following error appears: "Error: Relational characteristics are disabled!"

HowdoIsolvetheproblem?

    
asked by anonymous 04.07.2017 / 15:01

1 answer

2

MyISAM tables do not support FOREIGN KEY.

So you have to change the database types for InnoDB?

This you can select at the time of creating the database, and before creating the tables.

    
04.07.2017 / 15:56
How to return the values of an arraylist in Java Access device via CMD