单选题

假如有两张表， user表(userid,username,departi...

Question

假如有两张表， user表(userid,username,departid)，department表(departid,name,membercount) ，membercount是部门人数，如果要通过触发器实现在插入一个User的时候相应部门的membercount需要加1，则下列创建触发器语句正确的是（      ）

A.

create trigger ins_user on user after  insert begin update department set membercount= membercount+1

B. create trigger ins_user  after insert  on user begin update department set membercount= membercount+1 from department join new on department. Departed=new. Departed

C.

create trigger ins_user  on user after insert for each row begin update department set membercount= membercount+1 from department join new on department. Departed=new. Departed

D.

create trigger ins_user  after insert  on user for each row begin update department set membercount= membercount+1 from department join new on department. Departed=new. Departed