Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

Foreign Key's in MySQL

zapperonzapperon Member Posts: 88
I just made a table with a foreign key but it does not show up anywhere. Now I read somewhere thet MyISAM tables do not support Foreign Keys. What must I do as I need the checking and cascade delting of a foreign keys. Is there a work around ? Is my information incorrect , can I just change the table typ ?
Zapperon
ewu@webmail.co.za

Comments

  • JonathanJonathan Member Posts: 2,914
    : I just made a table with a foreign key but it does not show up
    : anywhere. Now I read somewhere thet MyISAM tables do not support
    : Foreign Keys. What must I do as I need the checking and cascade
    : delting of a foreign keys. Is there a work around ? Is my
    : information incorrect , can I just change the table typ ?
    I may be worng, but I belive to do what you're wanting you need to use the InnoDB table type.

    Good luck,

    Jonathan


    ###
    for(74,117,115,116){$::a.=chr};(($_.='qwertyui')&&
    (tr/yuiqwert/her anot/))for($::b);for($::c){$_.=$^X;
    /(p.{2}l)/;$_=$1}$::b=~/(..)$/;print("$::a$::b $::c hack$1.");

Sign In or Register to comment.