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
)
);