> -----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 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 [EMAIL PROTECTED] wultsch (aim) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]