At 9:05 AM +0545 7/17/01, Deependra B. Tandukar wrote:
>Greetings!
>
>I have two talbes in MySQL, Table1 and Table2.
>
>Table1
>id item
>1 apple
>2 banana
>3 orange
>
>Table2
>id item
>1 shoes
>2 suit
>3 mango
>
>If I want to add a row/column from Table1 to Table2, is it possible? May be
>something like:
>insert into Table1 (item) values ((Table2.item) where Table2.id=3);
You want to use the INSERT INTO ... SELECT form of the INSERT statement.
http://www.mysql.com/doc/I/N/INSERT_SELECT.html
>
>Looking forward to hearing from you all.
>
>Warm Regards,
>DT
--
Paul DuBois, [EMAIL PROTECTED]
---------------------------------------------------------------------
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