test6.sql

create table bookInfo(
code int,
title varchar(100),
writer varchar(50),
price int,
maker varchar(50)
);

insert into bookInfo(code,title,writer,price,maker) values('1','java1교재','홍길동','35000','영진');
insert into bookInfo(code,title,writer,price,maker) values('2','java2교재','홍길동','38000','');
insert into bookInfo(code,title,writer) values('3','mysql교재','이순신');

insert into bookInfo values('4','linux 첫걸음','리눅이','50000','한빛');
insert into bookInfo values('5','html 첫걸음','손코딩');
insert into bookInfo(code,title,writer,price,maker) values('6','java1교재','','0','영진');
insert into bookInfo(code,title,writer,price,maker) values(7,oracle,홍길동,35000,영진);

select count(*) from bookInfo;
select * from bookInfo;