/en/UNION.html
http://www.mysql.com/doc/en/JOIN.html
Mike Hillyer
www.vbmysql.com
-Original Message-
From: Terry Spencer [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 28, 2003 9:44 AM
To: Mike Hillyer; MySQL (E-mail)
Subject: RE: Update in select
Thanks for the help, that close to
ught, suggestion, points are greatly appreciated.
Im using 4.1.
Thanks
Terry
-Original Message-
From: Mike Hillyer [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 28, 2003 2:53 PM
To: Terry Spencer; [EMAIL PROTECTED]
Subject: RE: Update in select
Subqueries are only available in MySQL
PROTECTED]
Sent: Wednesday, May 28, 2003 7:26 AM
To: [EMAIL PROTECTED]
Subject: Update in select
Im attempting to update a table. We perform a select on the table to
determine what row to update.
update test a
set
visit_date = now()
where
a.id in (select b.id from test b where code ='Z&
Im attempting to update a table. We perform a select on the table to
determine what row to update.
update test a
set
visit_date = now()
where
a.id in (select b.id from test b where code ='Z')
Running this generates an error.
"You cant specify target table 'test' for update in FROM clause."
I