两张表设置外键约束提示 1215 - Cannot add foreign key constraint

CREATE TABLE t_bookType(
id int primary key auto_increment,
bookTypeName varchar(20),
bookTypeDesc varchar(200)
);

CREATE TABLE t_book(
id int primary key auto_increment,
bookName varchar(20),
anthor varchar(10),
price decimal(6,2),
bookTypeId int,
constraint fk foreign key(bookTypeId)referencest_bookType(id)
);

key(bookTypeId)references 这个references前面的空格呢???

应该是你语句空格问题引起，语句在navicat是可以运行的

[SQL]CREATE TABLE t_book (
id INT PRIMARY KEY auto_increment,
bookName VARCHAR (20),
anthor VARCHAR (10),
price DECIMAL (6, 2),
bookTypeId INT,
CONSTRAINT fk FOREIGN KEY (bookTypeId) REFERENCES t_bookType (id)
);
受影响的行: 0
时间: 0.111s