MySQL #1093 - You can't specify target table 'giveaways' for update in FROM clause

mysql sql select subquery mysql-error-1093
Eray picture Eray · Nov 30, 2011 · Viewed 49.7k times · Source

I tried:

UPDATE giveaways SET winner = '1' WHERE ID = (SELECT MAX(ID) FROM giveaways)

But it gives:

#1093 - You can't specify target table 'giveaways' for update in FROM clause

This article seems relevant but I can't adapt it to my query. How can I get it to work?

Answer

ipr101 picture ipr101 · Nov 30, 2011

Based on the information in the article you linked to this should work: 

update giveaways set winner='1'
where Id = (select Id from (select max(Id) as id from giveaways) as t)

Related questions

How to delete from select in MySQL?

This code doesn't work for MySQL 5.0, how to re-write it to make it work DELETE FROM posts where id=(SELECT id FROM posts GROUP BY id HAVING ( COUNT(id) > 1 )) I want to delete columns that dont have unique id. …

Read More
How do I get a count of associated rows in a left join in MySQL?

I have two tables, a vehicle table with columns: id stock year make model and an images table with columns: id vehicle_id name caption default tinyint(1) I am trying to list the vehicle's information, its default image, and a …

Read More
SQL query return data from multiple tables

I would like to know the following: how to get data from multiple tables in my database? what types of methods are there to do this? what are joins and unions and how are they different from one another? When …

Read More