Thank you very much, my friend. It is solved. Thanks...... --- Stefan Hinz <[EMAIL PROTECTED]> wrote: > Prabu, > > >> Is it possible to define Foreign Key and Primary > Key > >> of my database after the tables have been created > ? > >> If yes, how? > > Yes. Use the ALTER TABLE command for this. Here's > how it works generally: > > ALTER TABLE yourtablename > ADD [CONSTRAINT symbol] FOREIGN KEY (...) REFERENCES > anothertablename(...) > [on_delete_and_on_update_actions] > > Make sure the tables in question are all InnoDB > tables. > > And please read the appropriate manual section > first: > http://www.mysql.com/doc/en/SEC455.html > > Regards, > -- > Stefan Hinz <[EMAIL PROTECTED]> > iConnect GmbH <http://iConnect.de> > Heesestr. 6, 12169 Berlin (Germany) > Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3 > > [filter fodder: sql, mysql, query] > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list > archive) > > To request this thread, e-mail > <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: > http://lists.mysql.com/php/unsubscribe.php >
__________________________________________________ Do you Yahoo!? Yahoo! Tax Center - forms, calculators, tips, more http://taxes.yahoo.com/ --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
