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
谢谢，已经解�
相关问答：
编译器：C-Free4
mysql 单独安装的，现在为apache+php+mysql可以使用。
最近在练习c，c++；想用c，c++连接下我的mysql，好多地方多说mysql.h找不到。而且我mysql没有所谓的include文件夹啊。
忘高手指点一� ......
大家好:
我是搞C的, 现在想用C 连接MYSQL,但是怎么也连接不了,我的代码如下:
#include <stdio.h>
#include "C:\Program Files\MySQL\MySQL Server 5.0\include\mysql.h"
......
我对SQL SERVER和ACCESS比较熟，所以数据库的通用基础东西可以说都掌握的差不多了，我现在想要的就是以上两数据库的独特之处的介绍和应用介绍。
另外书最好对应最新版本 oracle是11g吧 10的也行；mysql是5.1吧
谢 ......
建表：插记录
SQL code:
create table tablename (id int,RQ1 datetime,RQ2 datetime)
-- select * from tablename
insert into tablename
select 1,'2009-01-01 10:00:00','2009-01-02 11:00:00' union
......
SQL code:
create PROCEDURE aa(SqlCMD1 varchar(8000),SqlCMD2 varchar(8000),SqlCMD3 varchar(8000))
begin
declare exit handler for sqlexception rollback;
start TRANSACTION;
EXECUTE SqlCMD1;
EXE ......
