books.sql

来自「这是为练习eclise又重新做的一个JSP的网上书店。比上次的功能强大了许多。我」· SQL 代码 · 共 29 行

CREATE TABLE books
(id VARCHAR(8) 
 PRIMARY KEY,
name VARCHAR(24),
title VARCHAR(96),
price FLOAT,
yr INT,
description VARCHAR(30),
saleAmount INT) default charset=gbk;

INSERT INTO books VALUES('201', 'wangfa', 
 'Java',
 33.75, 1999, 'Java program', 1000);

INSERT INTO books VALUES('202', 'zhangbing', 
 'Weblogic referance', 45.99,
 2002, 'very good', 2000);

INSERT INTO books VALUES('203', 'sunyan', 
 'Oracle database',
 40, 2003, 'the best book for oracle', 2000);

INSERT INTO books VALUES('204', 'dawei', 
 'from oak to Java',
 20.75, 1998, 'worth to look', 2000);

INSERT INTO books VALUES('205', 'aming', 
 'Apache',
 50.75, 2002, 'the material for Apache', 2000);