Thank you my friend.. --- Jerry <[EMAIL PROTECTED]> wrote: > 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 >
__________________________________________________ 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