List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:July 17 2001 4:26am
Subject:Re: MySQL Query .......
View as plain text  
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
Thread
word countTommy Beavitt9 Jul
  • Re: word countj.urban9 Jul
  • MySQL Query .......Deependra B. Tandukar17 Jul
    • Re: MySQL Query .......Paul DuBois17 Jul
  • Table query....Deependra B. Tandukar18 Jul
    • Re: Table query....Paul DuBois18 Jul
  • RedHat DB?!Deependra B. Tandukar18 Dec
    • Re: RedHat DB?!Steve Edberg18 Dec
    • Re: RedHat DB?!(Trond Eivind Glomsrød)18 Dec
      • Re: RedHat DB?!Christopher R. Jones19 Dec
        • Re: RedHat DB?!Ken Kinder19 Dec
  • Search EngineDeependra B. Tandukar18 Jun
    • Re: Search EngineZak Greant18 Jun
  • CDSISISDeependra b. Tandukar14 Aug
  • Can't open...Deependra b. Tandukar11 Sep
    • Re: Can't open...Victoria Reznichenko11 Sep
    • Re: Can't open...Joseph Bueno11 Sep
Re: CDSISISUsama Salama15 Aug
  • Re: CDSISISEmiliano Marmonti15 Aug
AW: Can't open...Fa. PostDirekt MA Franz11 Sep