Jump to content


Photo

Foreign Key for MySQL Table

key foreign key mysql sql server

  • Please log in to reply
2 replies to this topic

#1 lensoft

lensoft

    Rank I Member

  • Members
  • Pip
  • 18 posts

Posted 22 January 2019 - 05:18 PM

Hi!

I just wanted to make a simple relationship between two basic tabes, that I've created. To make this action, I use "dbForge Studio for MySQL" but when I tried to create the connection, the software said the following:

kPUngmd.png

 

So, what to do? Your servers/setup do not provide to make foreign keys?

 

Thanks for all!



#2 wolstech

wolstech

    Rank X Member

  • Root Admin
  • 10,416 posts
  • Gender:Male
  • Location:Pennsylvania

Posted 22 January 2019 - 09:49 PM

You probably need to change engines to InnoDB.

We default to Myisam because it tolerates load and crashes very well. InnoDB basically goes corrupt if you so much as look at it wrong.

Please do not PM me for support. Posting on our forums lets all of us learn.
Do you play Minecraft? | Server Monitors | And the Dumbass of the Decade award goes to...


#3 lensoft

lensoft

    Rank I Member

  • Members
  • Pip
  • 18 posts

Posted 23 January 2019 - 04:41 PM

You probably need to change engines to InnoDB.

We default to Myisam because it tolerates load and crashes very well. InnoDB basically goes corrupt if you so much as look at it wrong.

Thank you! It helped me. :)







Also tagged with one or more of these keywords: key, foreign key, mysql, sql, server

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users