mysql - MySQL SQL语法错误

Question

我尝试在 ubuntu 上的 mysql 命令行中创建表。这是《Oracle Database 12c》一书中的代码:

CREATE TABLE customers (
    customer_id INTEGER CONSTRAINT customers_pk PRIMARY KEY,
    first_name VARCHAR2(10) NOT NULL,
    last_name VARCHAR2(10) NOT NULL,
    dob DATE,
    phone VARCHAR2(12)
);

我收到一个错误:

ERROR 1064 (42000): 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 'CONSTRAINT customers_pk PRIMARY KEY,
    first_name VARCHAR2(10) NOT NULL,
    last_na' at line 2

Answer 1

我相信您可以在下面找到您想要完成的任务。您应该使用 MySQL 支持的数据类型。了解更多 here .

CREATE TABLE customers
( 
  customer_id INTEGER NOT NULL,
  first_name VARCHAR(10) NOT NULL,
  last_name VARCHAR(10),
  dob DATE,
  phone VARCHAR(12),
  zip_code VARCHAR(10),
  CONSTRAINT customers_pk PRIMARY KEY (customer_id)
);