> -Original Message-
> From: Albert E. Whale [mailto:[EMAIL PROTECTED]
> Sent: Friday, May 02, 2008 4:06 PM
> To: mysql@lists.mysql.com
> 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 pv
You are better off with an UPDATE JOIN
UPDATE pdata A,pdata B
SET A.pvalue = B.pvalue
WHERE A.pentrytime = 117540
AND B.pentrytime = 1207022400;
Give it a try !!!
-Original Message-
From: Albert E. Whale [mailto:[EMAIL PROTECTED]
Sent: Friday, May 02, 2008 4:06 PM
To: mysql@lists.m
