mysql建表时报1604_mysql建表出错，求助高手 。在线急等

/*!角色表*/CREATETABLE`t_role`(`ID`bigint(20)NOTNULLauto_increment,`TYPE`varchar(100)defaultNULL,PRIMARYKEY(`ID`))ENGINE=MyISAMDEFAULTCHARSET=utf8;CREATETABLE`t_teacher`(...

/*!角色表*/

CREATE TABLE `t_role` (

`ID` bigint(20) NOT NULL auto_increment,

`TYPE` varchar(100) default NULL,

PRIMARY KEY(`ID`)

)ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE `t_teacher` (

`ID` bigint(20) NOT NULL auto_increment,

`TRUE_NAME` varchar(100) NOT NULL,

`USERNAME` varchar(100) NOT NULL UNIQUE,

`PASSWORD` varchar(100) NOT NULL,

`LOGINTIME` DATETIME,

`DEPT_ID` bigint(20) NOT NULL,

PRIMARY KEY (`ID`)

CONSTRAINT `fk_dept` FOREIGN KEY (`DEPT_ID`) REFERENCES `t_dept` (`ID`) ON DELETE CASCADE

)ENGINE=MyISAM DEFAULT CHARSET=utf8;

错误提示:sql执行错误#1604 从数据库的响应：

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 'CONSTRAINT' 'fk_dept' FOREIGN KEY('DEPT_ID') REFERENCES 't_dept' ('ID') ON DELET' at line 9

展开