users 表
1、id
2、name
orders 表
1、id
2、usersid
3、orname
问题是 我要在users表中建个触发器 在根据id删除users记录时删除orders表的相关记录
没学过这东西 刚在网上查了一下 试着写了一个 可是出错了
create Trigger stuUsers
on Users
for Delete
as
delete Orders
from orders ord,delete dl
where ord.userid=dl.id
说是 倒数第二行的delete附近有错误我也不知道这个触发器管不管用...
1、id
2、name
orders 表
1、id
2、usersid
3、orname
问题是 我要在users表中建个触发器 在根据id删除users记录时删除orders表的相关记录
没学过这东西 刚在网上查了一下 试着写了一个 可是出错了
create Trigger stuUsers
on Users
for Delete
as
delete Orders
from orders ord,delete dl
where ord.userid=dl.id
说是 倒数第二行的delete附近有错误我也不知道这个触发器管不管用...
on Users
for Delete
as
delete Orders
from orders ord,deleted dl
where ord.userid=dl.id
on Users
for Delete
as
delete Orders
from orders ord,deleted dl
where ord.userid=dl.id
--deleted 是这个名字
delete Orders
from orders ord,deleted dl
where ord.usersid=dl.id