mysql作业书籍库

''''''

# create table book(
#     book_id int primary key auto_increment,
#     book_name char(12) not null unique,
#     book_price tinyint unsigned,
#     book_press_id int not null,
#     book_author_id char(12) not null,
#     foreign key(book_press_id) references press(press_id)
#     on delete cascade
#     on update cascade
# );
# insert into book(book_name,book_price,book_press_id)
# # create table book_info(
# #     book_id int,
# #     author_id int,
# #     press_id int
# # )
#
# create table press(
#     press_id int primary key auto_increment,
#     name char(18) not null unique,
#     address char(100),
#     tel tinyint unsigned
# )
#
# create table athor(
#     author_id int primary key auto_increment,
#     name char(12) not null,
#     tel  tinyint unsigned,
#     address char(100)
# )

# create table book1(
#     book_id int primary key auto_increment,
#     name varchar(20) not null,
#     price double,
#     address varchar(200),
#     tel int(11)
# )
#
# create table author1(
#     id int primary key auto_increment,
#     name char(10) not null,
#     adress varchar(100),
#     tel int(11)
# )
# create table book_info(
#  id int not null unique auto_increment,
#  author_id int,
#  book_id int,
#  foreign key(author_id) references author1(id) on update cascade,
#  foreign key(book_id) references book1(book_id) on update cascade,
#  primary key(author_id,book_id)
# )

# create table cient(
#     id int primary key auto_increment,
#     name char(10) not null unique,
#     tel int(11) not null,
#     adress varchar(100)
# )
#
# create table student(
#     id int primary key auto_increment,
#     class_name char(10) not null,
#     custom_id int unique,
#     foreign key(custom_id) references cient(id)
#     on delete cascade
#     on update cascade
# )

# create table class(
#     cid int primary key auto_increment,
#     caption varchar(20) not null unique
# )
# create table teacher(
#     tid int primary key auto_increment,
#     tname char(10) not null
# )
# create table student(
#     sid int primary key auto_increment,
#     sname char(10) not null,
#     gender enum('女','男') default '女',
#     class_id int,
#     foreign key(class_id) references class(cid)
#     on update cascade
#     on delete cascade
# )
# create table course(
#     cid int primary key auto_increment,
#     cname char(10) not null unique,
#     tearch_id int,
#     foreign key(tearch_id) references teacher(tid)
#     on update cascade
#     on delete cascade
# )
# create table score(
#     sid int not null unique auto_increment,
#     number int not null,
#     student_id int not null,
#     corse_id int not null,
#     foreign key(student_id) references student(sid)
#     on update cascade on delete cascade,
#     foreign key(corse_id) references course(cid)
#     on update cascade on delete cascade,
#     primary key(student_id,corse_id)
# )