create table author(
authorid int(10) primary key not null auto_increment,
authorname varchar(20)
)engine = innodb default charset = utf8;
create table book(
bookid int(10) primary key not null auto_increment,
authorid int(10),
bookname varchar(20)
)engine = innodb default charset = utf8;
评论0