http://www.mysql.com/doc/en/ALTER_TABLE.html
----- Original Message ----- From: "Prabu Subroto" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, February 19, 2003 11:58 AM Subject: MySQL > > --- [EMAIL PROTECTED] wrote: > > Your message cannot be posted because it appears to > > be either spam or > > simply off topic to our filter. To bypass the filter > > you must include > > one of the following words in your message: > > > > sql,query,queries,smallint > > > > If you just reply to this message, and include the > > entire text of it in the > > reply, your reply will go through. However, you > > should > > first review the text of the message to make sure it > > has something to do > > with MySQL. Just typing the word MySQL once will be > > sufficient, for example. > > > > You have written the following: > > > > Dear my Pals.... > > I did something very stupid in my development. I > > created a database with a couple of tables...but I > > forgot to defining the foreign key and the primary > > key > > So if my user updated a record of one table than the > > corresponding row on related table will not be > > updated > > too. That's why I had to write additional function > > to > > update the others related tables which are necessary > > to be updated too. > > > > Is it possible to define Foreign Key and Primary Key > > of my database after the tables have been created ? > > If yes, how? > > > > Thank you very much in advance. > > > > __________________________________________________ > > Do you Yahoo!? > > Yahoo! Shopping - Send Flowers for Valentine's Day > > http://shopping.yahoo.com > > > > __________________________________________________ > Do you Yahoo!? > Yahoo! Shopping - Send Flowers for Valentine's Day > http://shopping.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 > --------------------------------------------------------------------- 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