mysql - 我正在尝试创建一个表，其中有复合键，但出现错误以检查在'CASCADE 附近使用的正确语法。MySQL (版本-8.0.5)

Question

CREATE TABLE works_with(
  emp_id INT,
  client_id INT,
  total_sales INT,
  PRIMARY KEY (emp_id, client_id),
  FOREIGN KEY (emp_id) REFERENCES employee(emp_id) ON DELETE SET CASCADE,  #error syntax to use near #'CASCADE, FOREIGN KEY (client_id) REFERENCES client(client_id) ON DELETE SET ' at line 6

  FOREIGN KEY (client_id) REFERENCES client(client_id) ON DELETE SET CASCADE
);

标签： mysqlsyntaxforeign-keyscascadecomposite-key

Answer 1

GarethD 的评论解决了这个问题。更改ON DELETE SET CASCADE为ON DELETE CASCADE。