Re: MySQL Query .......

[Paul DuBois]

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, paul@stripped