How can i setup foreign keys in mysql?
example of table:
User_id Primary key order_id forgien key
what is the syntax and how can I alter tables which have already been setup..
thanks
works with tables of type innodb only
http://www.mysql.com/doc/en/ANSI_diff_Foreign_Keys.html http://www.mysql.com/doc/en/InnoDB_foreign_key_constraints.html
