mysql引入外键报错
CREATE TABLE SUBJECT
(
sid INT PRIMARY KEY,
title VARCHAR(20) NOT NULL,
TYPE VARCHAR(20) NOT NULL
);
CREATE TABLE OPTION
(
id INT PRIMARY KEY,
subjectid VARCHAR REFERENCES SUBJECT(sid),
NAME VARCHAR(20) NOT NULL,
ORDER VARCHAR(20) NOT NULL
);
报这种错
1 queries executed, 0 success, 1 errors, 0 warnings
查询:CREATE TABLE OPTION ( id INT PRIMARY KEY, subjectid VARCHAR REFERENCES SUBJECT(sid), NAME VARCHAR(20) NOT NULL, ORDER VARCHAR(20...
错误代码: 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 'OPTION
(
id INT PRIMARY KEY,
subjectid VARCHAR REFERENCES SUBJECT(sid),
NAME VAR' at line 1
执行耗时 : 0 sec
传送时间 : 0 sec
总耗时 : 0.001 sec
哪里错了啊。。。。。。。。。。。