jnestore.sql

来自「《精通JSP编程 》源代码(赵强那本) 很有用的源代码」· SQL 代码 · 共 9 行

create table catalog_items (sku char(25),name char(50),description varchar(200),price float);
 insert into catalog_items values ('d01','java bible','A java book published by PS',12.1);
insert into catalog_items values ('d02','vb bible','A vb  book published by PS',20);
insert into catalog_items values ('d03','c# bible','A c# book published by PS',18.1);
 insert into catalog_items values ('d04','web service bible','A webservice book published by PS',12.1);
insert into catalog_items values ('d05','weblogic bible','A weblogic  book published by PS',20);
insert into catalog_items values ('d06','websphere bible','A websphere book published by PS',18.1);
 insert into catalog_items values ('d07','JBuilder bible','A JBuilder book published by PS',12.1);