SQL更新表，其中date = MIN(date) [英] SQL Update Table Where date = MIN(date)

问题描述

我得到了以下代码:

Update `Table` set amount='1003' WHERE date = (SELECT MIN(date)) AND `id` = 736

我的第一个Where规则date = (SELECT MIN(date))出了点问题，但是我不知道是什么.

Something is wrong with my first Where rule date = (SELECT MIN(date)) but i dont know what.

推荐答案

您可以从联接中对其进行更新:

You can update it from a join:

Update `Table` a
INNER JOIN (
    SELECT `id`, min(exp_date) AS exp_date from `Table` WHERE `id`= 736
) AS b ON (a.id=b.id AND a.exp_date=b.exp_date)
set amount='1003'
WHERE a.id = 736 AND a.exp_date=b.exp_date;

这篇关于SQL更新表，其中date = MIN(date)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！