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
解决方案 »
- MYSQL查询问题急求
- mysql union 与union all 使用
- mysql insert into select ON DUPLICATE KEY UPDATE 更新值的问题
- 数据表中有一个日期时间字段,如何查出和当前时间相比超过两个小时的记录?
- 求一句MYSQL的语句~
- mysql获取时间的问题
- SQL SERVER数据库中一表Bbs,表结构如下:
- 各位大侠,请问如何将mysql转化成oracle,有什么技术文档没有,谢谢!
- Linux 下 MySQL 对目录没有访问权限,怎么改???
- 请教一个mysql保留字的简单问题
- 急!高手请进!MySQL如何搜索varchar中带 . 或者 - 的记录?并且将他们替换掉
- 我查询出一个数字!如何取整数
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;
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
(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
set a.AlarmEndtime = now()
where a.AlarmID=b.max_alarmid