DELIMITER // CREATE TRIGGER `after_update_debt_defaulters` AFTER INSERT ON `defaulters` FOR EACH ROW BEGIN IF ( EXISTS ( SELECT DISTINCT `KRAPIN` FROM defaulters WHERE `Debt_Amount` = '0' ) ) THEN UPDATE users SET users.debtor = '0' WHERE KRAPIN = NEW.KRAPIN; END IF; END
Undefined variable: transaction_id (0)
// $transaction_id = transaction::find ($req->transaction_id);
syntax error, unexpected 'if' (T_IF), expecting ']'
One or more errors have occurred while processing your request: The following query has failed: "CREATE DEFINER=`root`@`localhost` TRIGGER `product_code` AFTER INSERT ON `inventory_table` FOR EACH ROW CREATE TRIGGER product_code AFTER INSERT ON test FOR EACH ROW BEGIN UPDATE test set textid = concat('PC', LPAD(NEW.id, 5, '0'), '/POS') WHERE id=NEW.id; END" MySQL said: #1303 - Can't create a TRIGGER from within another stored routine