List:General Discussion« Previous MessageNext Message »
From:Albert E. Whale Date:May 2 2008 8:05pm
Subject:Update with select
View as plain text  
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?
|
-- 
Albert E. Whale, CHS CISA CISSP
Sr. Security, Network, Risk Assessment and Systems Consultant
------------------------------------------------------------------------
ABS Computer Technology, Inc. <http://www.ABS-CompTech.com> - Email, 
Internet and Security Consultants
SPAMZapper <http://www.Spam-Zapper.com> - No-JunkMail.com 
<http://www.No-JunkMail.com> - *True Spam Elimination*.
Thread
Update with selectAlbert E. Whale2 May
  • RE: Update with selectRolando Edwards2 May
    • Re: Update with selectRob Wultsch2 May