在搭建完数据导入项目数据时出现报错，
这是源码[SQL] Query his1234 start
[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 ‘’[{“sex”: “无”, “code”: “无”, “item”: “裸眼视力(左)”, "name’ at line 2
[ERR] /*
Navicat Premium Data Transfer

Source Server : MySQL
Source Server Type : MySQL
Source Server Version : 80017 (8.0.17)
Target Server Type : MySQL
Target Server Version : 50503 (5.5.3)
File Encoding : 65001

Date: 06/06/2023 12:30:33
*/

– 创建数据库（MySQL 5.5 不支持 utf8mb4，改用 utf8）
CREATE DATABASE IF NOT EXISTS his DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
USE his;

SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;

– Table structure for tb_action

DROP TABLE IF EXISTS tb_action;
CREATE TABLE tb_action (
id int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT ‘主键’,
action_code varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘行为编号’,
action_name varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘行为名称’,
PRIMARY KEY (id) USING BTREE,
UNIQUE INDEX unq_action_name(action_name ASC) USING BTREE,
UNIQUE INDEX unq_action_code(action_code ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 9 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = ‘行为表’ ROW_FORMAT = DYNAMIC;

– Records of tb_action

INSERT INTO tb_action VALUES (1, ‘INSERT’, ‘添加’);
INSERT INTO tb_action VALUES (2, ‘DELETE’, ‘删除’);
INSERT INTO tb_action VALUES (3, ‘UPDATE’, ‘修改’);
INSERT INTO tb_action VALUES (4, ‘SELECT’, ‘查询’);
INSERT INTO tb_action VALUES (5, ‘APPROVAL’, ‘审批’);
INSERT INTO tb_action VALUES (6, ‘EXPORT’, ‘导出’);
INSERT INTO tb_action VALUES (7, ‘BACKUP’, ‘备份’);
INSERT INTO tb_action VALUES (8, ‘ARCHIVE’, ‘归档’);

– Table structure for tb_appointment

DROP TABLE IF EXISTS tb_appointment;
CREATE TABLE tb_appointment (
id int(11) NOT NULL AUTO_INCREMENT COMMENT ‘主键’,
uuid char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘UUID’,
order_id int(11) NOT NULL COMMENT ‘订单编号’,
date date NOT NULL COMMENT ‘预约日期’,
name varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘姓名’,
sex char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘性别’,
pid char(18) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘身份证号’,
birthday date NOT NULL COMMENT ‘出生日期’,
tel char(11) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘电话号码’,
mailing_address varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘体检报告邮寄地址’,
company varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ‘企业名称’,
status tinyint(4) NOT NULL COMMENT ‘状态。1未签到，2已签到，3已结束，4已关闭’,
checkin_time timestamp NULL DEFAULT NULL COMMENT ‘签到时间（MySQL 5.5 不支持 DATETIME 默认值）’,
create_time timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT ‘创建时间’,
update_time timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT ‘更新时间’,
PRIMARY KEY (id) USING BTREE,
UNIQUE INDEX unq_uuid(uuid ASC) USING BTREE,
UNIQUE INDEX unq_order_id(order_id ASC) USING BTREE,
INDEX idx_date(date ASC) USING BTREE,
INDEX idx_pid(pid ASC) USING BTREE,
INDEX idx_tel(tel ASC) USING BTREE,
INDEX idx_status(status ASC) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = ‘体检预约表’ ROW_FORMAT = DYNAMIC;

– Records of tb_appointment

– Table structure for tb_appointment_restriction

DROP TABLE IF EXISTS tb_appointment_restriction;
CREATE TABLE tb_appointment_restriction (
id int(11) NOT NULL AUTO_INCREMENT COMMENT ‘主键’,
date date NOT NULL COMMENT ‘日期’,
num_1 int(11) NOT NULL COMMENT ‘实际限定体检人数’,
num_2 int(11) NOT NULL COMMENT ‘每天体检人数上限’,
num_3 int(11) NOT NULL DEFAULT 0 COMMENT ‘实际体检人数（默认0）’,
remark varchar(200) CHARACTER SET utf8 C
[SQL] Finished with error