bookstore.sql

来自「孙鑫的Java Web开发详解一书的源代码」· SQL 代码 · 共 13 行

use bookstore;

create table bookinfo(id INT not null primary key,title VARCHAR(50) not null,author VARCHAR(50) not null,bookconcern VARCHAR(100) not null,publish_date DATE not null,price FLOAT(4,2) not null,amount SMALLINT,remark VARCHAR(200));

insert into bookinfo values(1,'Java从入门到精通','张三','张三出版社','2004-6-1',34.00,35,null);
insert into bookinfo values(2,'JSP深入编程','李四','李四出版社','2004-10-1',56.00,20,null);
insert into bookinfo values(3,'J2EE高级编程','王五','王五出版社','2005-3-1',78.00,10,null);

create table account(userid VARCHAR(10) not null primary key,balance FLOAT(6,2));
insert account values("甲",500.00);
insert account values("乙",200.00);