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:
-
>From: Sommai Fongnamthip [EMAIL PROTECTED]
>Date: Fri, 15 Feb 2002 16:37:51 +0700
>To: [EMAIL PROTECTED]
>Subject: update data from other table
>
>
>Hi,
> How to update data in table with data from other table in single SQL
>command (without using loop
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
an you use JOIN with UPDATE.
-
Original Message:
-
From: Sommai Fongnamthip [EMAIL PROTECTED]
Date: Fri, 15 Feb 2002 16:37:51 +0700
To: [EMAIL PROTECTED]
Subject: update data from other table
Hi,
How to update data in table with data from other table in sin
an you use JOIN with UPDATE.
-
Original Message:
-
From: Sommai Fongnamthip [EMAIL PROTECTED]
Date: Fri, 15 Feb 2002 16:37:51 +0700
To: [EMAIL PROTECTED]
Subject: update data from other table
Hi,
How to update data in table with data from other table in sin
Hi,
How to update data in table with data from other table in single SQL
command (without using loop)?
Sommai,
--
Please be informed that all e-mail which are addressing to
thaithanakit.co.th will need to be changed to
BTsecurities