My database not creating relationship

daytips.xyz

i created a database named epiz_27978100_clicks with tables but on phpmyadmin on the design option i can select the primary key column and foreign key to create relstion the two column i want to share data with but unfortunately its not drawing connection lines or showing any connection like in xampp.

(please help to create relational tables)

Hey there, You have to select your database engine as InnoDB.

You can do that by heading to your desired table and selecting the Operations tab. In there, you’ll see a few tables; you need to find the table called Table Options. In there, click on the storage type and switch it to InnoDB. That’s all you should be able to create relationships with now.

2 Likes

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.