当我添加
spring.datasource.separator=^;进来
application.properties并且每一行都结束时,过程/触发器应通过
^;
Example 终止,我的问题得到了解决,如下所示:
DROP TRIGGER IF EXISTS Persons_log_update ^;CREATE TRIGGER Persons_log_update BEFORE UPDATE ON Persons FOR EACH ROW BEGIN INSERT INTO Personshistory(PersonID,LastName,FirstName,Address,City) values(OLD.PersonID,OLD.LastName,OLD.FirstName,OLD.Address,OLD.City);END ^;



