Question

mysql建表是报错1005 具体错误原因如下

150313 16:04:06 Error in foreign key constraint of table mysql/userbase:
foreign key(UserCode)references UserSalary(UserCode)):
Cannot find an index in the referenced table where the
referenced columns appear as the first columns, or column types
in the table and the referenced table do not match for constraint.
Note that the internal storage type of ENUM and SET changed in
tables created with >= InnoDB-4.1.12, and such columns in old tables
cannot be referenced by such columns in new tables.
See http://dev.mysql.com/doc/refman/5.5/en/innodb-foreign-key-constraints.html
for correct foreign key definition.

建表语句如下：
第一个表：

create table UserSalary(
UserId int not null primary key auto_increment,
UserCode Varchar(6) not null,
NumSalary Double(9,2) not null,
Mon int not null);

第二个表：

create table userbase(
UserCode Varchar(6) not null,
UserName Varchar(20) not null,
UserSex Varchar(3),
UserBirday Date,
primary key(UserCode),
foreign key(UserCode)references UserSalary(UserCode));
建第二个表是因为有了主外键关系 ，提示1005错误

Answer 1

我记得，好像是，如果在另外一个表中建立外键，userSalary中的UserCode必须是主键

Answer 2

去掉reference试试