CREATE TRIGGER INSERT_salesorderdetail
before insert on salesorderdetail
for each row
UPDATE customer
set number_of_items=IFNULL(number_of_items,0)+1
where new.customerid=customer.customerid;
我有2个表salesorderdetail和customer,我希望每次我在salesorderdetail中插入一个新项目来更新我的客户columne中的number_of_items列时,由于某种原因,我会在更新中遇到语法错误。
这可能对您有帮助:
CREATE OR REPLACE FUNCTION update_customer()
RETURNS trigger AS
$BODY$
-- update ur table here
RETURN NULL;
END;
$BODY$
LANGUAGE plpgsql VOLATILE
COST 100;
ALTER FUNCTION update_customer()
OWNER TO db_name;
现在将触发器创建为:
CREATE TRIGGER INSERT_salesorderdetail
before insert on salesorderdetail
for each row execute procedure update_customer();
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句