MySQL: How to make Trigger to insert row in another table?
I want to create an after insert trigger for users to insert a row in one of the others, based in the field users.permissions. This should be a simple if else condition. The trigger verifies the ...
Mysql create trigger if not exist
CREATE TRIGGER `delete_from_code` BEFORE DELETE ON `users` FOR EACH ROW BEGIN delete from code where nom = old.nom ; END YOU CAN CREATE TRIGGERS IF NOT EXISTS LIKE THIS : – String query11 =&...
Only top scored, non community-wiki answers of a minimum length are eligible