SQL query:
CREATE TRIGGER customer_Trigger AFTER DELETE ON customer FOR EACH ROW BEGIN INSERT INTO customer_log
VALUES (
old.cusid, old.cusoffname, old.custel, old.CusStatus, old.CusName, old.CusType, SYSDATE( )
)
END
MySQL said:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'END' at line 6
drop trigger if exists customer_Trigger;
CREATE TRIGGER customer_Trigger
after delete ON customer
FOR EACH ROW
BEGIN
insert into customer_log values(old.cusid,old.cusoffname,old.custel,old.CusStatus,old.CusName,old.CusType,sysdate());
END;
Load balance : Server 00
