mysql触发器中使用new报语法错误_在MySQL中创建触发器，提示错误，错误在哪？...

createtriggertri_crkoncrkbforinsertAsDeclare@crchar(2),@wlnumchar(7),@cknumchar(7),@slintSelect@cr=crfrominsertedSelect@wlnum=wlmunfrominsertedSelect@cknum=cknumfrominser...

create trigger tri_crk on crkb for insert

As

Declare @cr char(2),@wlnum char(7),@cknum char(7),@sl int

Select @cr=cr from inserted

Select @wlnum=wlmun from inserted

Select @cknum=cknum from inserted

Select @sl=sl from inserted

If @cr=’入’

Begin

If @wlnum not int(select wlnum from ckb)

Inserted ckb(cknum,wlnum) values(@cknum,@wlnum)

Update ckb set wlsl=wlsl+@sl where cknum=@cknum and wlnum=@wlnum

End

Else

Begin

If(select sl from ckb where wlnum=@wlnum and cknum=@cknum)

Print’物料不足’

Rollback

End

Update ckb set wlsl=wlsl-@sl where cknum=@cknum and wlnum=@wlnum

Go

错误代码 1064，SQL 状态 42000：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 crkb for insert

As

Declare @cr char(2),@wlnum char(7),@cknum char(7),@sl int

' at line 2

展开