Categories
mysql

mysql trigger

Example:

CREATE TRIGGER `tgr_name` AFTER UPDATE ON `addresses` FOR EACH ROW begin
update products set countryName new.countryName where products.shippingAddressId old.id;
end;

Leave a Reply

Your email address will not be published. Required fields are marked *