主页 / 问题 / 1098636
Accepted
David
Asked:2020-03-23 22:12:52 +0000 UTC2020-03-23 22:12:52 +0000 UTC

语法错误在哪里？[关闭]

  • 772

我正在编写一个 SQL 查询来创建一个包含所有字段（记录）的表。数据库管理系统——MySQL。

请求本身：

CREATE TABLE employee (
  employee_id INT(6) NOT NULL,
  last_name VARCHAR(45) NULL,
  first_name VARCHAR(45) NULL,
  middle_initial VARCHAR(45) NULL,
  manager_id INT(6) NULL,
  job_id INT(6) NULL,
  hire_date DATE NULL,
  salary FLOAT(7,2) NULL,
  commission FLOAT(7,2) NULL,
  department_id INT(6) NULL,
  PRIMARY KEY (employee_id),
  INDEX dep_idx (department_id ASC),
  INDEX emp_idx (manager_id ASC),
  INDEX jobi_idx job_id ASC),
  CONSTRAINT dep
    FOREIGN KEY (department_id)
    REFERENCES ikbo_11_18.department (department_id)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT emp
    FOREIGN KEY (manager_id)
    REFERENCES ikbo_11_18.employee (employee_id)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT jobi
    FOREIGN KEY (job_id)
    REFERENCES ikbo_11_18.job (job_id)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION);

错误：

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 'job_id ASC),
  CONSTRAINT dep
    FOREIGN KEY (department_id)
    REFERENCES ikb' at line 15
mysql

1 个回答

  1. Best Answer

    正是它在帖子中所说的：

    'job_id ASC 附近）

    这是整条线

    INDEX jobi_idx job_id ASC),

    谁将打开支架？

    • 1

相关问题