试试这个技巧
UPDATE wins
SET prevmonth_top=1
ORDER BY month_wins DESC
LIMIT 1
或类似的东西,
UPDATE IGNORE giveaways
SET winner = 1
WHERE month_wins = (select maxID from (SELECT MAX(ID) maxID FROM giveaways) as t)
更新具有一个字段的当前最高(最大值)值的行
试试这个技巧
UPDATE wins
SET prevmonth_top=1
ORDER BY month_wins DESC
LIMIT 1
或类似的东西,
UPDATE IGNORE giveaways
SET winner = 1
WHERE month_wins = (select maxID from (SELECT MAX(ID) maxID FROM giveaways) as t)