Page is a not externally linkable
- Code, Content, and Presentation
-- Databases
---- SQL Syntax Error


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


Thread source:: http://www.webmasterworld.com/databases_sql_mysql/4528307.htm
Brought to you by WebmasterWorld: http://www.webmasterworld.com