Re: Update with select

[Rob Wultsch]

>  -----Original Message-----
>  From: Albert E. Whale [mailto:aewhale@stripped]
>  Sent: Friday, May 02, 2008 4:06 PM
>  To: mysql@stripped
>  Subject: Update with select
>
>  I am trying to update a field on a record in a table.  Here is the
>  statement I created:
>
>  UPDATE pdata SET pvalue = ( SELECT pvalue
>  FROM pdata
>  WHERE pentrytime =1207022400 )
>  WHERE pentrytime =1175400000;
>
>  However, I get the following error:
>
>  |#1093 - You can't specify target table 'pdata' for update in FROM clause
>
>  What can I use to fix this?
>  |

"Currently, you cannot update a table and select from the same table
in a subquery."
http://dev.mysql.com/doc/refman/5.0/en/update.html

Subqueries in mysql in general are well supported.

The solution already posted is what I would do.

-- 
Rob Wultsch
wultsch@stripped
wultsch (aim)