1064 - You have an error in your SQL syntax； check the manual that corresponds to your MySQL server_navicat新建表报错:you have an error in your ql syntax,

问题：mysql创建表报错如下：

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 '“pomp_user_mobile” (
“id” bigint(20) NOT NULL AUTO_INCREMENT COMMENT ‘主键i’ at line 1

使用的工具版本：Navicat Premium 16

创建表的sql语句如下：

CREATE TABLE "shop" (
  "id" bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键id',
  "create_by" varchar(32) DEFAULT NULL COMMENT '创建人',
  "create_time" datetime DEFAULT NULL COMMENT '创建时间',
  "update_by" varchar(32) DEFAULT NULL COMMENT '更新人',
  "update_time" datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY ("id") USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COMMENT='shop表';
1
2
3
4
5
6
7
8

原因：用了双引号，Navicat Premium 16的列表字段和表名要用`
不能用双引号，navicat低版本可以用双引号

sql语句修改如下后就可以创表成功：

CREATE TABLE `shop` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键id',
  `create_by` varchar(32) DEFAULT NULL COMMENT '创建人',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(32) DEFAULT NULL COMMENT '更新人',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COMMENT='shop表';
1
2
3
4
5
6
7
8