Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

howto create foreign key in mySQL ?

 
Alvin chew
Ranch Hand
Posts: 834
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hi, i'm not sure how to i create foreign key in mySQL, can anyone guide me on this ? is mySQL support foreign key ? it like a bit difficult to get the mySQL foreign key info from website ..thank you guidance
 
Paul Sturrock
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
MySQL didn't used to support FKs constraints. There something about this in the docs, but I think only the InnoDB engine does. The default engine people use tends to be the MyISAM one, which doesn't support FK constraints. So first you have to convert or create your model with InnoDB tables then read the documentation aboout creating FK constraints.
 
Alvin chew
Ranch Hand
Posts: 834
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
just wondering , as default engine doesn't support foreign key , how to solve foreign key problem ? is it the only way which means to convert DB type ? thank you !
 
Stefan Wagner
Ranch Hand
Posts: 1923
Linux Postgres Database Scala
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
which foreign key problem?

I lived 10 years very well without foreign key information from metadata, because I needed the information about the relationships before programming my applications - and I got it from documentations.
 
Don't get me started about those stupid light bulbs.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic