mysql创建图书表 创建图书表的sql语句

图书编号，图书名字，图书作者，图书分类。请创建一个图书表，并进行增删改查。

1.创建图书表

– craete table
–创建图书表

create table bookes
 (
 no varchar2(64),
 name varchar2(20),
 author varchar2(10)
 );

–创建分类表

create table booknoes
 (
 no varchar2(64),
 categroy varchar2(10)
 )

2.插入数据
–插入数据
–insert into 表名(各个列明)
–values(各列对应的值)

insert into bookes(no,name,author)
values(‘11’,‘茶花女’,‘斯当达’);
insert into bookes(no,name,author)
values(‘12’,‘红与黑’,‘亚历山大’);
insert into bookes(no,name,author)
values(‘13’,‘童年’,‘高尔基’);
insert into bookes(no,name,author)
values(‘14’,‘百年孤独’,‘马尔克斯’);

insert into bookes(no,name,author)
values(‘21’,‘圣母院’,‘雨果’);
insert into bookes(no,name,author)
values(‘22’,‘明朝那些事’,‘当年明月’);

insert into bookes(no,name,author)
values(‘31’,‘铁血兵戈’,‘风中的失落’);
insert into bookes(no,name,author)
values(‘32’,‘路过’,‘张嘉佳’);

insert into booknoes(no,categroy)
values(‘1’,‘文学名著’);
insert into booknoes(no,categroy)
values (‘2’,‘武侠’);
insert into booknoes(no,categroy)
values (‘3’,‘网络小说’);

3.查看表
select * from bookes
select * from booknoes

4.查找数据

–select 列名 from 表名 [where 筛选条件]

select no,name from bookes where name=‘圣母院’;

select no,categroy from booknoes where categroy=‘武侠’;

5.修改数据

–update student set 列名=值 [where 筛选条件]

–更新数据

update bookes set name=‘巴黎圣母院’ where name=‘圣母院’;

update booknoes set categroy=‘历史军事’ where categroy=‘武侠’;

6.删除数据

–delete from 表名 [where 筛选条件]

delete from bookes where name=‘红与黑’;