--- In [email protected], "itsabhiyaar" <[EMAIL PROTECTED]> wrote: > > Hello there, > i was designing a database where in i want to set a candidate_id > in CADIDATE table as a foreign for EMPLOYER table. > however, i didnt find anything in phpMyAdim where i can do it. > > Please tell me how to set foreign key using phpMyAdmin >
As far as I know mysql does not support this. However, phpMyAdmin allows you to "link" tables to each other, but all phpMyAdmin does is when viewing data, it makes it linkable to the linked table. Unfortunately it is not the same as sql's foreign key. Click here for more information: http://dev.mysql.com/doc/refman/5.0/en/ansi-diff-foreign-keys.html ------------------------ Yahoo! Groups Sponsor --------------------~--> Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life. http://us.click.yahoo.com/KIlPFB/vlQLAA/TtwFAA/CefplB/TM --------------------------------------------------------------------~-> The php_mysql group is dedicated to learn more about the PHP/MySQL web database possibilities through group learning. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/php_mysql/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
