Navicat Premium 15 创建表报错

Question

create table if not exists employee(

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 '' at line 1
时间: 0s
Navicat Premium 15 创建表报错

Answer 1

我在navicat12中测试了一下，没有问题。

use fortest;

create table if not exists employee(
  id int,
  name varchar(20),
  gender varchar(20),
  salary double
)

结果如图：