Question

mysql 添加外键失败 #1072 - Key column 'agentnumber' doesn't exist in table

create TABLE `agent`.`userlist` (
`username` VARCHAR( 20 ) NOT NULL ,
`password` VARCHAR( 20 ) NOT NULL ,
`guiding question` VARCHAR(100 ) NULL ,
`guiding answer` VARCHAR( 50 ) NULL ,
`location` int NOT NULL ,
foreign key( `agentnumber` ) references `agentlist`( `agentnumber` ) on update cascade,
PRIMARY KEY ( `username` )
) ENGINE = MYISAM

请问问题在哪里？如何解决？谢谢

Answer 1

哥们，你的userlist表都没有agentnumber这个字段；