MySQL #1093 – You can’t specify target table ‘giveaways’ for update in FROM clause

by

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)

More Related Contents:

  1. What is better subquery vs literal on IN clause in mysql
  2. Recreating a query using INNER JOIN? [duplicate]
  3. Getting the SUM() of claps and at the same time counting bookmarks in one query
  4. MySQL Error 1093 – Can’t specify target table for update in FROM clause
  5. SQL query return data from multiple tables
  6. quick selection of a random row from a large table in mysql
  7. MySQL SELECT only not null values
  8. Ordering by specific field value first
  9. MySQL DELETE FROM with subquery as condition
  10. SELECT / GROUP BY – segments of time (10 seconds, 30 seconds, etc)
  11. Subqueries with EXISTS vs IN – MySQL
  12. How to delete from select in MySQL?
  13. Checking multiple columns for one value
  14. SQL DELETE with JOIN another table for WHERE condition
  15. MySQL How do you INSERT INTO a table with a SELECT subquery returning multiple rows?
  16. MySQL INSERT INTO … VALUES and SELECT
  17. MySQL error 1241: Operand should contain 1 column(s)
  18. How to select one row randomly taking into account a weight?
  19. quick selection of a random row from a large table in mysql
  20. Compare only day and month with date field in mysql
  21. Syntax error when using except in a query
  22. SELECT query return 1 row from each group
  23. MySQL INNER JOIN select only one row from second table
  24. MySQL Select Query – Get only first 10 characters of a value
  25. SQL query to check if a name begins and ends with a vowel
  26. How to SELECT by MAX(date)?
  27. SQL UPDATE with sub-query that references the same table in MySQL
  28. Select from same table as an Insert or Update
  29. Deleting a row based on the max value
  30. Insert and set value with max()+1 problems

Leave a Comment