Page is a not externally linkable
shmamy - 3:36 am on Dec 15, 2012 (gmt 0)
[size=2][/size]I just changed the second section to:
CREATE TRIGGER INSERT_BOOK_INFO
AFTER
INSERT ON BOOK_INFO FOR EACH ROW
BEGIN
INSERT INTO CHANGES
(USER, CHA_TIME, CHA_ISBN, CHA_TYPE, CHA_ISBN_NEW)
VALUES(USER, CURDATE(), NEW.ISBN, 'I', NULL)
END
Now my error is:
Error Code: 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 8