I tried:
UPDATE giveaways SET winner = '1' WHERE ID = (SELECT MAX(ID) FROM giveaways)
但它给出了:
#1093 - 您无法指定目标表“赠品”进行更新FROM
clause
本文 http://verysimple.com/2011/03/30/mysql-cant-specify-target-table-for-update-in-from-clause/似乎相关,但我无法使其适应我的查询。我怎样才能让它发挥作用?
根据您链接到的文章中的信息,这应该有效:
update giveaways set winner='1'
where Id = (select Id from (select max(Id) as id from giveaways) as t)
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)