Forum Moderators: coopster

Message Too Old, No Replies

Referential Integrity using phpMyAdmin

establishing foreign keys

         

dainstructor

3:36 pm on Jan 26, 2007 (gmt 0)

10+ Year Member



I'm looking for a way set foreign keys in a database that I've already built. Does anyone know of a good way for me to do so?

Thanks in advance,

jatar_k

1:21 am on Jan 27, 2007 (gmt 0)

WebmasterWorld Administrator 10+ Year Member



what version of mysql do you have? I think foreign keys are only available in later verions

[dev.mysql.com...]
[dev.mysql.com...]
[dev.mysql.com...]

you will also need to use innodb from what I can tell

isn't adding anything to a constructed table coinsidered an ALTER TABLE, can't you click and alter any table, edit table button or something (not sure I don't use phpmyadmin)