下面这条语句:
create trigger TRG_update
on deposit
for update
as
if update(account_number)
rollback tran 在hsql中测试时报错:
Unexpected token FOR,requires ON in statement ...
在phpMyadmin中测试也报错:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'on deposit
for update
as
if update(account_number)
rollback tran' at line 2
不知道是为什么?
trigger的语法不是
create trigger 触发器名 on 表名 for 操作 as ...么?第一次发帖,不好意思没有可用分啊
create trigger TRG_update
on deposit
for update
as
if update(account_number)
rollback tran 在hsql中测试时报错:
Unexpected token FOR,requires ON in statement ...
在phpMyadmin中测试也报错:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'on deposit
for update
as
if update(account_number)
rollback tran' at line 2
不知道是为什么?
trigger的语法不是
create trigger 触发器名 on 表名 for 操作 as ...么?第一次发帖,不好意思没有可用分啊
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货