阅读量:0
错误1
[Err] 1064 - 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 'SET FOREIGN_KEY_CHECKS = 0; DROP TABLE IF EXISTS `tmp_tables`; CREATE TABLE' at line 1 [Err] SET FOREIGN_KEY_CHECKS = 0; DROP TABLE IF EXISTS `tmp_tables`; CREATE TABLE `tmp_tables` ( `id` int(100) NOT NULL AUTO_INCREMENT, `wl_table_name` varchar(100) DEFAULT NULL, `xt_table_name` varchar(100) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=90 DEFAULT CHARSET=utf8; insert into `tmp_tables`(`id`,`wl_table_name`,`xt_table_name`) values (1,'t_s_attachment','系统上传附件表'), (2,'t_s_base_user','系统用户基础表'), (3,'t_s_category','系统分类表'), (4,'t_s_data_log','业务数据日志表'), (5,'t_s_data_rule','数据权限规则表'), (6,'t_s_data_source','系统多数据源表'), (7,'t_s_depart','系统组织机构'), (8,'t_s_function','系统菜单权限'), (9,'t_s_icon','系统图标'), (10,'t_s_log','系统日志表'), (11,'t_s_muti_lang','国际化语法表'), (12,'t_s_notice','系统公告'), (13,'t_s_notice_authority_role','系统公告角色关系表'), (14,'t_s_notice_authority_user','系统公告人员关系表'), (15,'t_s_notice_read_user','系统功能已读日志表'), (16,'t_s_operation','系统操作权限'), (17,'t_s_role','系统角色表'), (18,'t_s_role_function','系统角色菜单关系表'), (19,'t_s_role_org','系统角色组织机构关系表'), (20,'t_s_role_user','系统角色用户关系表'), (21,'t_s_sms','消息中心'), (22,'t_s_sms_sql','消息中心SQL'), (23,'t_s_sms_template','消息中心模板'), (24,'t_s_sms_template_sql','消息中心模板SQL'), (25,'t_s_timetask','定时任务表'), (26,'t_s_type','字段表'), (27,'t_s_typegroup','字典类别'), (28,'t_s_user','用户表'), (29,'t_s_user_org','用户组织机构关系表'), (38,'cgform_button','Online表单自定义按钮'), (39,'cgform_button_sql','Online表单SQL增强'), (40,'cgform_enhance_java','Online表单Java增强'), (41,'cgform_enhance_js','Online表单JS增强'), (42,'cgform_field','Online表单字段'), (43,'cgform_ftl','Online表单样式'), (44,'cgform_head','Online表单主表'), (45,'cgform_index','Online表单索引'), (46,'cgform_template','Online表单模板'), (47,'cgform_uploadfiles','Online表单上传文件'), (48,'jform_cgdynamgraph_head','移动报表配置主表'), (49,'jform_cgdynamgraph_item','移动报表配置明细'), (50,'jform_cgdynamgraph_param','移动报表配置参数'), (51,'jform_cgreport_head','动态报表主表'), (52,'jform_cgreport_item','动态报表字段'), (53,'jform_cgreport_param','动态报表参数'), (54,'jform_graphreport_head','移动图表配置主表'), (55,'jform_graphreport_item','移动图表配置字段'), (56,'t_s_region','地域表'), (57,'test_person','测试用户表'), (58,'jform_contact','合同表'), (59,'jform_contact_group','通迅录分组'), (60,'jform_employee_cost_claim','员工费用报销申请信息表'), (61,'jform_employee_entry','员工入职单'), (62,'jform_employee_leave','员工请假单'), (63,'jform_employee_meals_cost','员工餐费明细表'), (64,'jform_employee_other_cost','员工其他费用明细表'), (65,'jform_employee_resignation','员工离职单'), (66,'jform_leave','请假单'), (67,'jform_order_customer','订单客户'), (68,'jform_order_main','订单主表'), (69,'jform_order_ticket','订单机票'), (70,'jform_price1','价格表'), (71,'jform_resume_degree_info','教育经历'), (72,'jform_resume_exp_info','工作信息表'), (73,'jform_resume_info','简历信息表'), (74,'jform_tree','树DEMO'), (75,'jeecg_custom_info','客户信息'), (76,'jeecg_custom_record','客户记录'), (77,'jeecg_demo','演示DEMO'), (78,'jeecg_order_custom','订单客户表'), (79,'jeecg_order_main','订单主表'), (80,'jeecg_order_product','订单产品表'), (81,'jp_demo_activity','插件活动表'), (82,'jp_demo_auth','插件树DEMO'), (83,'jp_demo_order_custom','插件订单客户表'), (84,'jp_demo_order_main','插件订单主表'), (85,'jp_demo_order_product','插件订单产品表'), (86,'jp_inner_mail','插件邮箱主表'), (87,'jp_inner_mail_attach','插件邮箱附件'), (88,'jp_inner_mail_receiver','插件邮件接收'), (89,'jp_chat_message_his','在线聊天消息记录表'); DROP TABLE IF EXISTS `test_rules`; CREATE TABLE `test_rules` ( `id` varchar(36) NOT NULL COMMENT '主键', `create_name` varchar(50) DEFAULT NULL COMMENT '创建人名称', `create_by` varchar(50) DEFAULT NULL COMMENT '创建人登录名称', `create_date` datetime DEFAULT NULL COMMENT '创建日期', `update_name` varchar(50) DEFAULT NULL COMMENT '更新人名称', `update_by` varchar(50) DEFAULT NULL COMMENT '更新人登录名称', `update_date` datetime DEFAULT NULL COMMENT '更新日期', `sys_org_code` varchar(50) DEFAULT NULL COMMENT '所属部门', `sys_company_code` varchar(50) DEFAULT NULL COMMENT '所属公司', `bpm_status` varchar(32) DEFAULT '1' COMMENT '流程状态', `name` varchar(32) DEFAULT NULL COMMENT '销售人员', `money` double(32,0) DEFAULT NULL COMMENT '订单金额', `product` varchar(200) DEFAULT NULL COMMENT '产品名字', `sale_date` datetime DEFAULT NULL COMMENT '下单时间', `eeee` varchar(32) DEFAULT NULL COMMENT 'cc', `dda` varchar(32) DEFAULT NULL COMM [Err] 1146 - Table 'hzz.t_sl_base_river_lake' doesn't exist [Err] insert into `t_sl_base_river_lake`(`id`,`code`,`name`,`create_name`,`create_by`,`create_date`,`update_name`,`update_by`,`update_date`,`PARENT_CODE`,`sys_org_code`,`sys_company_code`,`division_divisionCode`,`river_lake_type`,`riverRangeData`,`mapCenterLngLat`,`mapZoom`,`archives_doc`,`policy_doc`,`public_signs_doc`,`public_signs_lnglat`,`photo`,`waterArea`,`public_signs_lng`,`public_signs_lat`) values ('402880986947b652016947db4c420003','32333','234324','小王','demo','2019-03-04 16:39:08','小王','demo','2019-03-04 16:40:02',null,'A01A02','A01','A01','11',null,null,null,null,null,null,null,null,33.00,null,null), ('402880986947b652016947dc70dc000a','44','','小王','demo','2019-03-04 16:40:23','小王','demo','2019-03-04 16:43:51',null,'A01A02','A01','','11',null,null,null,null,null,null,null,null,44.00,null,null), ('402880986947b652016947df70ab0011','A05','','小王','demo','2019-03-04 16:43:39','小王','demo','2019-03-04 16:43:39',null,'A01A02','A01','','11',null,null,null,null,null,null,null,null,22.00,null,null), ('402880986947b652016947dfe1080018','A06','','小王','demo','2019-03-04 16:44:08','小王','demo','2019-03-04 16:44:08',null,'A01A02','A01','','11',null,null,null,null,null,null,null,null,22.00,null,null), ('402880986947b652016947e0ec8f001b','A07','23123','小王','demo','2019-03-04 16:45:16','小王','demo','2019-03-06 16:49:46','','A01A02','A01','','10',' ','','',null,null,null,null,null,22.00,null,null), ('402880986947b652016947e129d9001e','A08','21212','小王','demo','2019-03-04 16:45:32','小王','demo','2019-03-06 16:49:43','','A01A02','A01','','10',' ','','',null,null,null,null,null,22.00,null,null), ('402880986947b652016947e165ea0021','A09','','小王','demo','2019-03-04 16:45:47','小王','demo','2019-03-04 16:45:47',null,'A01A02','A01','','12',null,null,null,null,null,null,null,null,22.00,null,null), ('402880986947b652016947e259b20024','A10','','小王','demo','2019-03-04 16:46:50','小王','demo','2019-03-04 16:46:50',null,'A01A02','A01','','13',null,null,null,null,null,null,null,null,22.00,null,null), ('40288098694b4cbc01694be71a52000a','A11','取水口1','管理员','admin','2019-03-05 11:30:30','小王','demo','2019-03-12 14:01:15','','A01','A01','A01A01','20','[ {"lng":117.270308,"lat":34.215771}, {"lng":117.264415,"lat":34.211233}, {"lng":117.266859,"lat":34.196544}, {"lng":117.270164,"lat":34.191408}, {"lng":117.271314,"lat":34.187586}, {"lng":117.279076,"lat":34.187825}, {"lng":117.285543,"lat":34.205979}, {"lng":117.283388,"lat":34.212188}, {"lng":117.276201,"lat":34.216248}, {"lng":117.276201,"lat":34.216248}, {"lng":117.276201,"lat":34.216248} ] ','{"lng":117.273901,"lat":34.204904}','12',null,null,null,null,null,null,null,null), ('40288098694b4cbc01694be757c8000d','23231','水功能区3','管理员','admin','2019-03-05 11:30:46','小王','demo','2019-03-13 09:57:16','AAAA','A01','A01','A01A01','21',' 12 ','12','12',null,null,null,null,null,null,null,null), ('40288098694b4cbc01694be86d7d0010','4231','水功能区2','管理员','admin','2019-03-05 11:31:57','小王','demo','2019-03-13 09:49:10','A01A01A01','A01','A01','A01A01','21','[ {"lng":117.388453,"lat":34.33545}, {"lng":117.386441,"lat":34.334734}, {"lng":117.387375,"lat":34.332111}, {"lng":117.390106,"lat":34.332409}, {"lng":117.389459,"lat":34.334913}, {"lng":117.389459,"lat":34.334913} ] ','{"lng":117.388885,"lat":34.334198}','12',null,null,null,null,null,null,null,null), ('402880986951fe120169520a9a300011','A14','211212','管理员','admin','2019-03-06 16:07:00','小王','demo','2019-03-06 16:49:29','','A01','A01','','10',' ','','',null,null,null,null,null,22.00,null,null), ('4028809869522a29016952342750000f','A15','1221','小王','demo','2019-03-06 16:52:23','小王','demo','2019-03-06 16:52:23',null,'A01A02','A01','','10',' ','','',null,null,null,null,null,12.00,null,null), ('4028809869522a290169523468030012','A16','333','小王','demo','2019-03-06 16:52:40','管理员','admin','2019-10-09 08:52:03','1111','A01A02','A01','320305000000A01','10',' ','','',null,null,null,null,null,2323.00,null,null), ('4028809869522a2901695235a3150018','1111','22222','小王','demo','2019-03-06 16:54:00','管理员','admin','2019-10-09 08:51:12','','A01A02','A01','320303000000',' [Msg] Finished - Unsuccessfully -------------------------------------------------- 原因
有几个关键的问题导致了错误： 字节序标记（BOM）：在脚本的开始处有一个不可见的字节序标记（）， 这通常是在保存文件为UTF-8编码时，一些编辑器会自动添加的。这个标记在SQL语句中是无效的，需要被移除。 解决方案
移除BOM：使用文本编辑器打开文件，选择以无BOM的UTF-8格式保存，或手动删除BOM。 使用Visual Studio Code 打开文件。 如果你看到左下角的编码显示为UTF-8 with BOM，那么说明文件有BOM。 右键点击左下角的编码区域，选择“转换为UTF-8编码”即可移除BOM。 在Notepad++中，你可以按照以下步骤操作： 打开含有BOM的文件。 转到“视图”>“显示符号”>“显示所有字符”，这样可以看到BOM标记。 使用查找和替换功能，查找^ufeff（或直接查找，如果可见的话），然后替换为空。 或者，在“编码”菜单下选择“转至UTF-8”或“无BOM的UTF-8”。 错误2
[Err] 1064 - 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 ''<h1 style="margin-right: 0px; margin-bottom: 10px; margin-left: 0px; padding: 0' at line 14 [Err] DROP TABLE IF EXISTS `jp_chat_message_his`; CREATE TABLE `jp_chat_message_his` ( `id` varchar(50) NOT NULL, `msg_from` varchar(255) NOT NULL, `msg_to` varchar(255) DEFAULT NULL, `msg_data` varchar(5000) DEFAULT NULL, `create_date` datetime DEFAULT NULL, `type` varchar(255) DEFAULT NULL, `readed` smallint(2) DEFAULT NULL COMMENT '消息是否已读 0 未读 1 已读', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; insert into `jp_chat_message_his`(`id`,`msg_from`,`msg_to`,`msg_data`,`create_date`,`type`,`readed`) values ('05983fd035564a699dd6898783ef1627','8a8ab0b246dc81120146dc8181950052','8a8ab0b246dc81120146dc8180ba0017','{"mine":{"avatar":"content/chat/layui/images/portrait/qq.jpg","content":"3333","id":"8a8ab0b246dc81120146dc8181950052","mine":true,"username":"管理员"},"to":{"avatar":"content/chat/layui/images/portrait/group.jpg","groupname":"JEECG开源社区","id":"8a8ab0b246dc81120146dc8180ba0017","name":"JEECG开源社区","type":"group"}}','2018-12-26 15:41:40','group',0), ('083d914451b54f9392e4ea436c9c4d97','8a8ab0b246dc81120146dc8181950052','4028ef81538330cd01538333b7bc0001','{"mine":{"avatar":"/jeecg/chat/imController/showOrDownByurl.do?dbPath=upload/files\\\\20170612\\\\e1fe9925bc315c60addea1b98eb1cb1349547719.jpg","content":"7","id":"8a8ab0b246dc81120146dc8181950052","mine":true,"username":"管理员"},"to":{"avatar":"content/chat/layui/images/portrait/qq.jpg","id":"4028ef81538330cd01538333b7bc0001","name":"李四","sign":"这家伙很懒没有签名","type":"friend"}}','2018-02-22 17:57:30','friend',1), ('09eca77fc49745968fda90e549d6ec15','4028819c67e953c20167e960cd120001','8a8ab0b246dc81120146dc8181950052','{"mine":{"avatar":"content/chat/layui/images/portrait/qq.jpg","content":"33333","id":"4028819c67e953c20167e960cd120001","mine":true,"username":"liuby"},"to":{"avatar":"/jeecg/chat/imController/showOrDownByurl.do?dbPath=upload\\\\files\\\\20180715\\\\qq_1531625977907.jpg","id":"8a8ab0b246dc81120146dc8181950052","name":"管理员","sign":"这家伙很你好66","type":"friend"}}','2018-12-26 15:20:13','friend',1), ('0dcd3aeb1f034a2cbd5bd387e58c7cdd','8a8ab0b246dc81120146dc8181950052','40288196680c4c6201680c504e330014','{"mine":{"avatar":"content/chat/layui/images/portrait/qq.jpg","content":"111","id":"8a8ab0b246dc81120146dc8181950052","mine":true,"username":"管理员"},"to":{"avatar":"content/chat/layui/images/portrait/qq.jpg","id":"40288196680c4c6201680c504e330014","name":"111","sign":"这家伙很懒没有签名","type":"friend"}}','2019-01-02 17:12:42','friend',0), ('0fdab8cfffd549628b6b5b381274dc21','4028ef81538330cd01538333b7bc0001','8a8ab0b246dc81120146dc8181950052','{"mine":{"avatar":"content/chat/layui/images/portrait/qq.jpg","content":"您好啊","id":"4028ef81538330cd01538333b7bc0001","mine":true,"username":"李四"},"to":{"avatar":"/jeecg/chat/imController/showOrDownByurl.do?dbPath=upload/files\\\\20170612\\\\e1fe9925bc315c60addea1b98eb1cb1349547719.jpg","id":"8a8ab0b246dc81120146dc8181950052","name":"管理员","sign":"这家伙很你好","type":"friend"}}','2018-02-22 17:57:00','friend',1), ('162','8a8ab0b246dc81120146dc8181950052','402880e74d75c4dd014d75d44af30005','{"mine":{"avatar":"/jeecg/chat/imController/showOrDownByurl.do?dbPath=20170502\\\\d50735fae6cd7b897e6ff01d0a2442a7d9330e29.jpg","content":"1111","id":"8a8ab0b246dc81120146dc8181950052","mine":true,"username":"管理员"},"to":{"avatar":"http://tp1.sinaimg.cn/1571889140/180/40030060651/1","historyTime":"1493717561617","id":"402880e74d75c4dd014d75d44af30005","name":"demo","sign":"demo","type":"friend"}}','2017-05-02 17:37:47','friend',null), ('163','8a8ab0b246dc81120146dc8181950052','402880e74d75c4dd014d75d44af30005','{"mine":{"avatar":"/jeecg/chat/imController/showOrDownByurl.do?dbPath=20170502\\\\d50735fae6cd7b897e6ff01d0a2442a7d9330e29.jpg","content":"111","id":"8a8ab0b246dc81120146dc8181950052","mine":true,"username":"管理员"},"to":{"avatar":"http://tp1.sinaimg.cn/1571889140/180/40030060651/1","historyTime":"1493717561617","id":"402880e74d75c4dd014d75d44af30005","name":"demo","sign":"demo","type":"friend"}}','2017-05-02 17:38:14','friend',null), ('164','8a8ab0b246dc81120146dc8181950052','402880e74d75c4dd014d75d44af30005','{"mine":{"ava [Err] 1064 - 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 ' 第一步：创建Mysql数据库jeecg-p3，采用UTF-8编码，执' at line 1 [Err] 第一步：创建Mysql数据库jeecg-p3，采用UTF-8编码，执行下面数据库脚本 jeecg-p3-web/doc/sql/jeecg-p3-mysql.sql 第二步：双击运行jeecg-p3-web\\bin\\run-tomcat7.bat或bin\\run-tomcat.bat， 启动Web服务器（第一次运行，需要下载依赖jar包，请耐心等待）。 第三步：测试访问地址 1. http://localhost/jeecg-p3-web/p3/wxActInvite.do?list 2. http://localhost/jeecg-p3-web/p3/auth.do?list ☆Eclipse运行步骤： 第一步：创建Mysql数据库jeecg-p3，采用UTF-8编码，执行下面数据库脚本 jeecg-p3-web/doc/sql/jeecg-p3-mysql.sql 第二步：采用maven方式启动项目 (jeecg-p3-web) 项目右建->debug as-> [Err] 1064 - 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 'debug configurations->选中jeecg-p3-web项目->输入命令：tomcat' at line 1 [Err] debug configurations->选中jeecg-p3-web项目->输入命令：tomcat:run 注意：[1].update snapshots需要选中，官方会不断更新底层包 [2].插件项目不能单独启动，需以maven方式引入jeecg-p3-web项目中，启动web主项目 第四步：测试访问地址 1. http://localhost/jeecg-p3-web/p3/wxActInvite.do?list 2. http://localhost/jeecg-p3-web/p3/auth.do?list</pre><p style="white-space: normal; box-sizing: inherit; margin-top: 0px; margin-bottom: 15px; line-height: 25px; text-align: justify; word-break: break-word; color: rgba(0, 0, 0, 0.8); font-family: Lato, 'Helvetica Neue', 'Microsoft YaHei', Arial, Helvetica, sans-serif; font-size: 15px; background-color: rgb(255, 255, 255);">【代码生成器】</p><pre style="white-space: pre-wrap; word-wrap: break-word; box-sizing: inherit; overflow: auto; font-family: Menlo, 'Liberation Mono', Consolas, 'DejaVu Sans Mono', 'Ubuntu Mono', 'Courier New', 'andale mono', 'lucida console', monospace; margin-top: 0px; margin-bottom: 15px; border: none; font-size: 13px; line-height: 19px; padding: 6px 10px; border-radius: 3px; color: rgb(51, 51, 51); background-color: rgb(244, 244, 244);">1.工具类：jeecg-p3-web/src/main/java/util/P3CodeGenerateUtil.java 2.配置文件：jeecg-p3-web/src/main/resources/p3-cg-config.properties</pre><h1 style="margin: 20px 0px 10px; padding: 0px; color: rgb(51, 51, 51); white-space: normal; box-sizing: inherit; font-family: Lato, 'Helvetica Neue', 'Microsoft YaHei', Arial, Helvetica, sans-serif; line-height: 1.33em; min-height: 1rem; -webkit-font-smoothing: antialiased; cursor: text; position: relative; background-color: rgb(255, 255, 255);"><a style="color: rgb(51, 102, 153);" name="t1"></a><a target="_blank" class="anchor" id="技术交流" href="http://git.oschina.net/jeecg/jeecg-p3#技术交流" style="color: rgb(65, 131, 196); text-decoration: none; font-size: 28px; box-sizing: inherit; cursor: pointer; word-wrap: break-word; display: block; padding-left: 30px; margin-left: -20px; position: absolute; top: 0px; left: 0px; bottom: 0px; background-image: initial; background-attachment: initial; background-color: transparent; background-size: initial; background-origin: initial; background-clip: initial; background-position: initial; background-repeat: initial;"></a><span style="font-size: 18px;">技术交流</span></h1><ul class="task-list list-paddingleft-2" style="font-size: 14px; white-space: normal; box-sizing: inherit; line-height: 24px; padding-left: 30px; color: rgba(0, 0, 0, 0.8); font-family: Lato, 'Helvetica Neue', 'Microsoft YaHei', Arial, Helvetica, sans-serif; background-color: rgb(255, 255, 255);"><li><p>论 坛：<a target="_blank" href="http://www.jeecg.org/" style="color: rgb(65, 131, 196); text-decoration: none; box-sizing: inherit; word-wrap: break-word; margin-top: 0px; margin-bottom: 0px; cursor: pointer !important; background-image: initial; background-attachment: initial; background-size: initial; background-origin: initial; background-clip: initial; background-position: initial; background-repeat: initial;">www.jeecg.org</a></p></li><li><p>源码下载：<a target="_blank" href="http://git.oschina.net/jeecg/jeecg-p3" style="color: rgb(34, 0, 0); text-decoration: none;">http://git.oschina.net/jeecg/jeecg-p3</a></p></li><li><p>QQ交流群: 106838471</p></li></ul><p><br/></p>','02','张代浩','8a8ab0b246dc81120146dc81819d0053'), ('4028ef81540325190154032622320002','管理员','admin','2016-04-11 10:28:31','121212',null,'<p>此版本是一个扁平化UI风格版，提供4套风格供客户选择，让我们共同期待后续版本的到来</p><ol style="box-sizing: border-box; margin-bottom: 10px; color: rgb(103, 106, 108); font-family: 'open sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 13px; line-height: 18.5714px; white-space: normal; background-color: rgb(255, 255, 255);" clas [Err] 1146 - Table 'hzz.super_query_table' doesn't exist [Err] insert into `super_query_table`(`id`,`create_name`,`create_by`,`create_date`,`update_name`,`update_by`,`update_date`,`sys_org_code`,`sys_company_code`,`seq`,`table_name`,`instruction`,`is_main`,`fk_field`,`main_id`) values ('297e7ae1609ca39d01609cb495b20002','管理员','admin','2017-12-28 18:39:29','','',null,'A03','A03','1','jfrom_order','订单表','Y',null,'297e7ae1609ca39d01609cb495b10001'), ('297e7ae1609ca39d01609cb495b20003','管理员','admin','2017-12-28 18:39:29','管理员','admin','2017-12-28 19:31:54','A03','A03','2','jfrom_order_line','订单详细表','N','orderid','297e7ae1609ca39d01609cb495b10001'), ('402881e96048d988016048faf0ad0003','管理员','admin','2017-12-12 12:28:13','','',null,'A03','A03','1','jform_order_main','订单号','Y',null,'402881e96048d988016048faf0ad0002'), ('402881e96048d988016048faf0ad0004','管理员','admin','2017-12-12 12:28:13','管理员','admin','2017-12-12 12:28:28','A03','A03','2','jform_order_ticket','机票','N','fk_id','402881e96048d988016048faf0ad0002'), ('402881e96048d988016048faf0ad0005','管理员','admin','2017-12-12 12:28:13','管理员','admin','2017-12-12 12:28:28','A03','A03','3','jform_order_customer','客户','N','fck_id','402881e96048d988016048faf0ad0002'), ('402881f66265f83b016266197dcf0006','管理员','admin','2018-03-27 14:16:09','管理员','admin','2018-03-27 17:42:28','A03','A03','1','jform_order_main','合同测试表','Y',null,'402881f66265f83b016266197dcf0005'); SET FOREIGN_KEY_CHECKS = 1; [Msg] Finished - Unsuccessfully -------------------------------------------------- 原因
主要是因为SQL语句中包含了HTML标签和其他非SQL文本。这些非SQL元素会导致语法错误，MySQL服务器无法解析它们。 修复方法
清理数据：确保字段的数据是正确的，不应该包含HTML标签或非文本字符。 搜索< 删除全部相关语句 