It is my Computer Notes.
Using Guide : object-key or object-key-key
e.g. Step 1 Blog Search : [mysql-run] and then Step 2 ctrl+F [mysql-run]
{bookMark me : Ctrl+D}
drop trigger if exists `updateTaxDocAfterEmployeeUpdate`;
CREATE TRIGGER updateTaxDocAfterEmployeeUpdate
BEFORE INSERT ON employee
FOR EACH ROW
BEGIN
CALL generateTaxDoc('IR56E',new.RecordID,new.employeeNumber);
END;
沒有留言:
張貼留言