30.create-db.sql 写入数据报错

初始化脚本中写入如下语句,创建数据库时报错,未识别的符号
最新版CubaStudio 平台7.1.1 同一脚本在 Navicate中执行可通过

INSERT INTO SYS_SCHEDULED_TASK(ID, CREATE_TS, CREATED_BY, UPDATE_TS, UPDATED_BY, DELETE_TS, DELETED_BY, DEFINED_BY, CLASS_NAME, SCRIPT_NAME, BEAN_NAME, METHOD_NAME, METHOD_PARAMS, USER_NAME, IS_SINGLETON, IS_ACTIVE, PERIOD_, TIMEOUT, START_DATE, TIME_FRAME, START_DELAY, PERMITTED_SERVERS, LOG_START, LOG_FINISH, LAST_START_TIME, LAST_START_SERVER, DESCRIPTION, CRON, SCHEDULING_TYPE) VALUES (‘f72d6aaedb61155e8b89db8caf56e7a4’, ‘2020-04-16 09:29:59.101’, ‘admin’, ‘2020-04-16 09:53:11.553’, ‘admin’, NULL, NULL, ‘B’, NULL, NULL, ‘test_CommonService’, ‘checkSendEmail’, ‘<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n\n\n’, NULL, 1, 0, 60, NULL, NULL, NULL, NULL, NULL, 1, 1, ‘2020-04-16 09:52:58.787’, ‘localhost:8080/app-core’, NULL, NULL, ‘P’)^

你好,请问是哪种数据库?

MySql

你好,能发一下详细的错误提示吗?

找到原因了,注释携程–Text了 没加空格

1 个赞