我正在尝试创建包含复合键的表，但收到错误以检查正确的语法以在"级联"附近使用。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
);

Answer 1

GarethD的注释解决了这个问题。将ON DELETE SET CASCADE更改为ON DELETE CASCADE。