错误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 ''
【代码生成器】
1.工具类：jeecg-p3-web/src/main/java/util/P3CodeGenerateUtil.java 2.配置文件：jeecg-p3-web/src/main/resources/p3-cg-config.properties
技术交流
论  坛：www.jeecg.org
源码下载：http://git.oschina.net/jeecg/jeecg-p3
QQ交流群: 106838471

','02','张代浩','8a8ab0b246dc81120146dc81819d0053'), ('4028ef81540325190154032622320002','管理员','admin','2016-04-11 10:28:31','121212',null,'
此版本是一个扁平化UI风格版，提供4套风格供客户选择，让我们共同期待后续版本的到来

主要是因为SQL语句中包含了HTML标签和其他非SQL文本。这些非SQL元素会导致语法错误，MySQL服务器无法解析它们。 

清理数据：确保字段的数据是正确的，不应该包含HTML标签或非文本字符。 搜索<  删除全部相关语句