mysql引入外键报错

[lidou5872]

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

哪里错了啊。。。。。。。。。。。

[二月十六]

CREATE TABLE `OPTION`
(
id INT PRIMARY KEY,
subjectid VARCHAR(20) REFERENCES SUBJECT(sid),
NAME VARCHAR(20) NOT NULL,
`ORDER` VARCHAR(20) NOT NULL
);

[lidou5872]

请问下我哪里错了哈

[lidou5872]

原来是mysql关键字啊谢谢版主