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


pavanraj - 7:10 am on Jan 4, 2013 (gmt 0)


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
/

Try this........


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