Hi.
Try to use replace if you have unique key index and both table have the
same structure:
and query like,
replace into tableA
select * from tableB
Kittiphum Worachat,MT.
www.hatyailab.com
-
Before posting, please check:
thank you very much. I have to used loop for this solution, did I?
sommai
At 04:53 15/2/2002 -0500, [EMAIL PROTECTED] wrote:
>Sorry its not possible.
>
>Here a User Comment from the commented MySql Doc (Chapter UPDATE Systax)
>
>--
>Comments:
>Michael Holopainen: I was looking for i
I want to update existing data not insert new data.
sommai
At 16:52 15/2/2002 +0700, Kittiphum Worachat wrote:
>HI
>
>
> > Hi,
> > How to update data in table with data from other table in single SQL
> > command (without using loop)?
> >
> > Sommai,
>
>insert into table1 select * from table2
>
HI
> Hi,
> How to update data in table with data from other table in single SQL
> command (without using loop)?
>
> Sommai,
insert into table1 select * from table2
Kittiphum Worachat,MT.
www.hatyailab.com
-
Before posting
Sorry its not possible.
Here a User Comment from the commented MySql Doc (Chapter UPDATE Systax)
--
Comments:
Michael Holopainen: I was looking for info on how-to UPDATE with data retrived from
another table. aka. UPDATE with JOIN.
I noticed many other people were asking the same qu
Soory its not possible.
Here a User Comment from the Commented MySqlDoc (Chapter UPDATE Systax)
--
Comments:
Michael Holopainen: I was looking for info on how-to UPDATE with data retrived from
another table. aka. UPDATE with JOIN.
I noticed many other people were asking the same que
