sams teach yourself Sql in 24hours的范例数据库表格Mysql版本。

想找个范例的数据库原来真不是简单。呵呵
原书本上的数据库只是个标准，不是实现的版本。
在网上艰辛地找到了这个表格之后与发现自已用的Mysql字段的类型不符。
于是做了改动。下面的Sql文件可以直接导入Mysql了。
有了这个东东。可以节省很多输入的时间。学习更方便了。
--study.sql文件如下：

create datebase study;
use study
--表employee_tbl结构

create table employee_tbl
(emp_id varchar(9) not null,

last_name varchar(15) not null,

first_name varchar(15) not null,

middle_name varchar(15),

address varchar(30) not null,

city varchar(15) not null,

state char(2) not null,

zip numeric(5) not null,

phone char(10),

pager char(10),

constraint emp_pk primary key(emp_id) );

 

 

--表employee_pay_tbl结构
create table employee_pay_tbl
(emp_id varchar(9) not null,

position varchar(15) not null,

date_hire date,

pay_rate numeric(4,2),

date_last_raise date,

salary numeric(8,2),

bonus numeric(6,2),

constraint emp_fk foreign key(emp_id) references employee_tbl(emp_id) );

 

 

--表customer_tbl结构
create table customer_tbl
(cust_id varchar(10) not null primary key,

cust_name varchar(30) not null,

cust_address varchar(20) not null,

cust_city varchar(15) not null,

cust_state char(2) not null,

cust_zip numeric(5) not null,

cust_phone numeric(10),

cust_fax numeric(10) );

 

 

 

--表orders_tbl结构
create table orders_tbl
(ord_num varchar(10) not null primary key,

cust_id varchar(10) not null,

prod_id varchar(10) not null,

qty numeric(6) not null,

ord_date date );

 

 

 

--表products_tbl结构
create table products_tbl
(prod_id varchar(10) not null primary key,

prod_desc varchar(40) not null,

cost numeric(6,2) not null );

 

 

以下是各表的插入记录。

insert into employee_tbl values

(@#311549902@#,@#STEPHENS@#,@#TINA@#,@#DAWN@#,@#RR 3 BOX 17A@#,@#GREEN WOOD@#,

@#IN@#,@#47890@#,@#3178784465@#,NULL) ;

insert into employee_tbl values

(@#442346889@#,@#PLEW@#,@#LINDA@#,@#CAROL@#,@#3301 REACON@#,@#INDIANAPO LIS@#,

@#IN@#,@#46224@#,@#3172978990@#,NULL) ;

insert into employee_tbl values

(@#213764555@#,@#GLASS@#,@#BRANDON@#,@#SCOTT@#,@#1710 MAIN ST@#,@#WHITELAND@#,

@#IN@#,@#47885@#,@#3178984321@#,@#3175709980@#) ;

insert into employee_tbl values

(@#313782439@#,@#GLASS@#,@#JACOB@#,NULL,@#3789 WHITE RIVER BLVD@#,

@#INDIANAPOLIS@#,@#IN@#,@#45734@#,@#3175457676@#,@#8887345678@#) ;
insert into employee_tbl values

(@#220984332@#,@#WALLACE@#,@#MARIAH@#,NULL,@#7889 KEYSTONE AVE@#,

@#INDIANAPOLIS@#,@#IN@#,@#48741@#,@#3173325986@#,NULL) ;
insert into employee_tbl values

(@#443679012@#,@#SPURGEON@#,@#TIFFANY@#,NULL,@#5 GEORGE COURT@#,

@#INDIANAPOLIS@#,@#IN@#,@#46234@#,@#317569007@#,NULL) ;

 

insert into employee_pay_tbl values

(@#311549902@#,@#MARKETING@#,@#1989-05-23@#,NULL,@#1997-05-01@#,@#40000@#,NULL) ;


insert into employee_pay_tbl values

(@#442346889@#,@#TEAM LEADER@#,@#1990-06-17@#,@#14.75@#,@#1997-06-01@#,NULL,NULL) ;

insert into employee_pay_tbl values

(@#213764555@#,@#SALES MANAGER@#,@#1994-08-14@#,NULL,@#1997-08-01@#,@#30000@#,@#2000@#) ;
insert into employee_pay_tbl values

(@#313782439@#,@#SALESMAN@#,@#1997-06-28@#,NULL,NULL,@#20000@#,@#1000@#);

insert into employee_pay_tbl values

(@#220984332@#,@#SHIPPER@#,@#1996-07-22@#,@#11.00@#,@#1997-07-01@#,NULL,NULL) ;

insert into employee_pay_tbl values

(@#443679012@#,@#SHIPPER@#,@#1991-01-14@#,@#15.00@#,@#1997-01-01@#,NULL,NULL) ;

insert into customer_tbl values

(@#232@#,@#LESLTE GLEASON@#,@#798 HARDAWAY DR@#,@#INDIANAPOLIS@#,

@#IN@#,@#47856@#,@#3175457690@#,NULL) ;

insert into customer_tbl values

(@#109@#,@#NANCY BUNKER@#,@#APT A 4556 WATERWAY@#,@#BROAD RIPPLE@#,

@#IN@#,@#47950@#,@#3174262323@#,NULL) ;

insert into customer_tbl values

(@#345@#,@#ANGELA DOBKO@#,@#RR3 BOX 76@#,@#LEBANON@#,@#IN@#,@#49967@#,

@#7858970090@#,NULL) ;


insert into customer_tbl values

(@#090@#,@#WENDY WOLF@#,@#3345 GATEWAY DR@#,@#INDIANAPOLIS@#,@#IN@#,

@#46224@#,@#3172913421@#,NULL) ;

insert into customer_tbl values

(@#12@#,@#MARYS GIFT SHOP@#,@#435 MAIN ST@#,@#DANVILLE@#,@#IL@#,@#47978@#,

@#3178567221@#,@#3178523434@#) ;

insert into customer_tbl values

(@#432@#,@#SCOTT MARKET@#,@#RR2 BDX 173@#,@#BROWNSBURG@#,@#IN@#,

@#45687@#,@#3178529835@#,@#3178529836@#) ;

insert into customer_tbl values

(@#333@#,@#JASDNS AND DALLAS GOODIES@#,@#LAFAYETTE SQ MALL@#,

@#INDIANAPOLIS@#,@#IN@#,@#46222@#,@#3172978886@#,@#3172978887@#) ;
insert into customer_tbl values

(@#21@#,@#MORGANS CANDIES AND TREATS@#,@#5657 W TENTH ST@#,

@#INDIANAPOLIS@#,@#IN@#,@#46234@#,@#3172714398@#,NULL) ;

insert into customer_tbl values

(@#43@#,@#SCHYLERS NOVELTIES@#,@#17 MAPLE ST@#,@#LEBANON@#,@#IN@#,

@#48990@#,@#3174346758@#,NULL) ;

insert into customer_tbl values

(@#288@#,@#HOLLYS GAMEARAMA@#,@#567 US 31 SOUTH@#,@#WHITELAND@#,

@#IN@#,@#49980@#,@#3178879023@#,NULL) ;
insert into customer_tbl values

(@#287@#,@#GAVINS PLACE@#,@#9880ROCKVILLE RD@#,@#INDIANAPOLIS@#,

@#IN@#,@#46244@#,@#3172719991@#,@#3172719992@#) ;
insert into customer_tbl values

(@#590@#,@#HEATHERS FEATHERS AND THINGS@#,@#4090 N SHADELAND AVE@#,

@#INDIANAPOLIS@#,@#IN@#,@#43278@#,@#3175456768@#,NULL) ;

insert into customer_tbl values

(@#610@#,@#RAGANS HOBBIES INC@#,@#451 GREEN ST@#,@#PLAINFIELD@#,@#IN@#,

@#46818@#,@#3178393441@#,@#3178399090@#) ;

insert into customer_tbl values

(@#560@#,@#ANDYS CANDIES@#,@#RR 1 BOX 34@#,@#NASHVILLE@#,@#IN@#,

@#48756@#,@#8123239871@#,NULL) ;

insert into customer_tbl values

(@#221@#,@#RYANS STUFF@#,@#2337 S SHELBY ST@#,@#INDIANAPOLIS@#,@#IN@#,

@#47834@#,@#3175634402@#,NULL) ;


insert into orders_tbl values

(@#56A901@#,@#232@#,@#11235@#,@#1@#,@#1997-10-22@#) ;


insert into orders_tbl values

(@#56A917@#,@#12@#,@#907@#,@#100@#,@#1997-09-30@#) ;


insert into orders_tbl values

(@#32A132@#,@#43@#,@#222@#,@#25@#,@#1997-10-10@#) ;


insert into orders_tbl values

(@#16C17@#,@#090@#,@#222@#,@#2@#,@#1997-10-17@#) ;

insert into orders_tbl values

(@#18D778@#,@#287@#,@#90@#,@#10@#,@#1997-10-17@#) ;

insert into orders_tbl values

(@#23E934@#,@#432@#,@#13@#,@#20@#,@#1997-10-15@#) ;


insert into products_tbl values

(@#11235@#,@#WITCHES COSTUME@#,@#29.99@#) ;

insert into products_tbl values

(@#222@#,@#PLASTIC PUMPKIN 18 INCH@#,@#7.75@#) ;

insert into products_tbl values

(@#13@#,@#FALSE PARAFFIN TEETH@#,@#1.10@#) ;


insert into products_tbl values

(@#90@#,@#LIGHTED LANTERNS@#,@#14.50@#) ;

insert into products_tbl values

(@#15@#,@#ASSORTED COSTUMES@#,@#10.00@#) ;

insert into products_tbl values

(@#9@#,@#CANDY CORN@#,@#1.35@#) ;


insert into products_tbl values

(@#6@#,@#PUMPKIN CANDY@#,@#1.45@#) ;

insert into products_tbl values

(@#87@#,@#PLASTIC SPIDERS@#,@#1.05@#) ;

insert into products_tbl values

(@#119@#,@#ASSORTED MASKS@#,@#4.95@#) ;


 

原文转自：http://www.ltesting.net