mysql UPDATE 语句 where Pricelist.import_date = ( SELECT max(pricelist.import_date) )

Question

我试图在 mysql 中完成更新，它只选择最高的 import_date，但我似乎无法让它工作。以下声明更新了两种价格

UPDATE material, pricelist
    SET price = '23'
WHERE material.id = 1936 AND
      material.id = pricelist.material_id AND
      pricelist.import_date = (SELECT max(pricelist.import_date))

Answer 1

这符合你的要求吗？

UPDATE pricelist pl
    SET pl.price = '23'
WHERE pl.material_id = 1936
ORDER BY pl.import_date DESC
LIMIT 1;