Jump to content


Photo

Foreign Keys


  • Please log in to reply
2 replies to this topic

#1 Blu_Smurf

Blu_Smurf
  • Members
  • PipPipPip
  • Advanced Member
  • 32 posts
  • LocationTexas

Posted 17 September 2003 - 09:43 PM

Any one know if there is a way to setup foreign keys and cascading foreign keys? would free up a lot of coding on my msg board :P

so far i cant find any features for this on mysql, any one else know?

#2 Barand

Barand
  • Moderators
  • Sen . ( ile || sei )
  • 18,021 posts

Posted 18 September 2003 - 06:05 PM

You can use tables of type INNODB to use foreign keys to check referential integrity but cascades not supported - unless it\'s been introduced in latest versions.
If you are still using mysql_ functions, STOP! Use mysqli_ or PDO. The longer you leave it the more you will have to rewrite.

Donations gratefully received






moon.png

|baaGrid| easy data tables - and more
|baaChart| easy line, column and pie charts

#3 Blu_Smurf

Blu_Smurf
  • Members
  • PipPipPip
  • Advanced Member
  • 32 posts
  • LocationTexas

Posted 20 September 2003 - 09:21 AM

bah thats no good, thanks though.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users