1.问题描述
1.sql语句
DELIMITER $$
CREATE TRIGGER organ_sync_tri_update
AFTER UPDATE
ON organ FOR EACH ROW
tri: BEGIN
INSERT INTO synctobacksertables(userid,trigger_name,trigger_event,tablename,datastr,created_at,updated_at,state) VALUES(1,'organ_sync_tri_update','update','organ','',NOW(),'1900-01-01 00:00:00',0);
END tri $$
DELIMITER ;
2.java程序报错信息
java.sql.SQLSyntaxErrorException: 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 'delimiter $$
create trigger organ_sync_tri_update
after update
on organ ' at line 1
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateExcepti