mysql 1824_mysql问题，哪里出错？

CREATETABLE`tb_user`(`uId`int(11)NOTNULLAUTO_INCREMENT,`uName`varchar(40)CHARACTERSETutf8COLLATEutf8_general_ciNOTNULL,`uTel`int(30)NOTNULL,`uSex`varchar(10)CHARACTERSETu...

CREATE TABLE `tb_user` (

`uId` int(11) NOT NULL AUTO_INCREMENT,

`uName` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,

`uTel` int(30) NOT NULL,

`uSex` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,

`uAge` int(12) NOT NULL,

`uNote` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,

`tId` int(12) NOT NULL,

PRIMARY KEY (`uId`) USING BTREE,

INDEX `tId`(`tId`) USING BTREE,

CONSTRAINT `tb_user_ibfk_1` FOREIGN KEY (`tId`) REFERENCES `tb_usertype` (`tId`) ON DELETE RESTRICT ON UPDATE RESTRICT

) ENGINE = InnoDB AUTO_INCREMENT = 11 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic

> 1824 - Failed to open the referenced table 'tb_usertype'

> 时间: 0.001s

展开