MySQL外键fk是不是随便输入_mysql外键问题

CREATETABLE`noteplan_0000000002`(`NP_ID`char(10)NOTNULL,`NP_Type`char(7),`Creater_ID`char(10)NOTNULL,`NP_Item`char(40)NOTNULL,`NP_CreateDate`datetimeNOTNULL,`NP_Begin`dat...

CREATE TABLE `noteplan_0000000002` (

`NP_ID` char(10) NOT NULL,

`NP_Type` char(7),

`Creater_ID` char(10) NOT NULL,

`NP_Item` char(40) NOT NULL,

`NP_CreateDate` datetime NOT NULL,

`NP_Begin` datetime NOT NULL,

`NP_End` datetime NOT NULL,

`NP_Over` int(11) NOT NULL,

`NP_Remarks` varchar(280) DEFAULT NULL,

PRIMARY KEY (`NP_ID`),

KEY `creater_fk1_idx` (`Creater_ID`),

CONSTRAINT `creater_fk2` FOREIGN KEY (`Creater_ID`) REFERENCES `d_user` (`U_ID`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

建不了,错误为外键问题~

d_user 里面的U_ID是主键 非空 char(20)

CREATE TABLE T_Name

(

`F_ID` char(20) NOT NULL,

`U_ID` char(20) DEFAULT NULL,

`F_Name` char(20) NOT NULL,

PRIMARY KEY (`F_ID`),

KEY `U_ID` (`U_ID`),

CONSTRAINT `friend_fk` FOREIGN KEY(`U_ID`) REFERENCES `d_user` (`U_ID`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

我这个就可以创建成功

展开