报错信息:
Migration V1__init.sql failed
SQL State : 42000
Error Code : 1064
Message : 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 '' at line 6
Location : db/migration/V1__init.sql (D:\...\target\classes\db\migration\V1__init.sql)
Line : 1942
脚本sql语句:
create procedure insertmgrrole()
begin
declare i int;
set i=(select count(*) from t_mgr_role);
if i=0 then
INSERT INTO `t_mgr_role` VALUES ('1', '超级管理员', 'guid...', '超级管理员', 'date', 'date', '0');
end if;
end;
call insertmgrrole();
DROP PROCEDURE insertmgrrole;
直接放到sql查询里是可以执行的,
用的flyway版本是5.2.4