mysqlÖÐÕâÖÖÓï¾äÔõôд?

update ITEMS_ALARM_LIST set AlarmEndtime = now() where AlarmID = (select max(alarmid) from ITEMS_ALARM_LIST where EquipmentID = 1 and Alarm_Property = 1)

´íÎóÌáʾ£ºYou can't specify target table 'ITEMS_ALARM_LIST' for update in from clause

---

SQL code:

UPDATE ITEMS_ALARM_LIST t1,ITEMS_ALARM_LIST t2
SET t1.AlarmEndtime=now()
WHERE t1.AlarmID=MAX(t2.AlarmID) AND t2.EquipmentID=1 AND t2.Alarm_Property=1;

---

MYSQL²»Ö§³ÖÕâÖÖд·¨
update ITEMS_ALARM_LIST a,
(select max(alarmid) as ma from ITEMS_ALARM_LIST where EquipmentID = 1 and Alarm_Property = 1) b
set a.AlarmEndtime = now() where a.AlarmID = b.ma

---

SQL code:
update ITEMS_ALARM_LIST a,
(select max(alarmid) as max_id from ITEMS_ALARM_LIST where EquipmentID = 1 and Alarm_Property = 1) b
set a.AlarmEndtime = now() where a.AlarmID = b.max_id

---

mysql µÄÓï¾äÖÐÓÐһЩÏÞÖÆ¡£

SQL code:
update ITEMS_ALARM_LIST a,(select max(alarmid) as max_alarmid from ITEMS_ALARM_LIST where EquipmentID = 1 and Alarm_Property = 1) b
set a.AlarmEndtime = now()
where a.AlarmID=b.max_alarmid

---

лл£¬ÒѾ­½â¾