求一MYSQL样本数据库,谢谢！！

[michaelpeng7799]

安完MYSQL后就一个MYSQL库和TEST库。没有样子数据练习。
谁有写好的CREATE TABLE...
INSERT INTO ....

或网上哪有样本数据库脚本。

多谢！！

[michaelpeng7799]

up

[wchwwhw]

有语法格式呀~~~~~~~~~参看<<mysql中文参考手册>>

你也可以看<<mysql技术精粹>>(可能书名不全对),是机械工业出版社的~~~~~

[michaelpeng7799]

不是语法问题，说白了我不想花时间自已录一个数据表，谁有现成的？？可导入MYSQL数据库
的数据。

[kaphoon]

我也有这个想法
但是不是楼主的目的
因为手头的一些数据库都太小了

[oyzjin]

-- MySQL dump 9.09
--
-- Host: localhost Database: jbdb
-- ------------------------------------------------------
-- Server version 4.0.16-nt

--
-- Table structure for table `customer`
--

DROP TABLE IF EXISTS customer;
CREATE TABLE customer (
id varchar(5) NOT NULL default '',
update_date date NOT NULL default '0000-00-00',
name varchar(50) NOT NULL default '',
area varchar(8) NOT NULL default '',
city varchar(16) NOT NULL default '',
company_ad varchar(100) NOT NULL default '',
storage_ad varchar(100) default NULL,
credit_d varchar(6) default NULL,
credit_m varchar(6) default NULL,
postcode varchar(6) default NULL,
tel bigint(13) default NULL,
fax bigint(13) default NULL,
connect_person varchar(8) default NULL,
lower_person varchar(8) default NULL,
area_manager varchar(8) default NULL,
remark varchar(100) default NULL,
PRIMARY KEY (id)
) TYPE=MyISAM;

--
-- Dumping data for table `customer`
--


/*!40000 ALTER TABLE customer DISABLE KEYS */;
LOCK TABLES customer WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE customer ENABLE KEYS */;

--
-- Table structure for table `employee`
--

DROP TABLE IF EXISTS employee;
CREATE TABLE employee (
id varchar(4) NOT NULL default '',
update_date date NOT NULL default '0000-00-00',
name varchar(8) NOT NULL default '',
area varchar(8) NOT NULL default '',
office varchar(10) default NULL,
city varchar(16) NOT NULL default '',
workgroup varchar(16) NOT NULL default '',
trust varchar(10) NOT NULL default '',
tel bigint(12) NOT NULL default '0',
mobile bigint(12) default NULL,
home_add varchar(50) default NULL,
work_add varchar(50) default NULL,
remart varchar(50) default NULL,
PRIMARY KEY (id)
) TYPE=MyISAM;

--
-- Dumping data for table `employee`
--


/*!40000 ALTER TABLE employee DISABLE KEYS */;
LOCK TABLES employee WRITE;
INSERT INTO employee VALUES ('A001','2004-03-24','as','asdf','dsds','sdfs','sdfs','sdf',25252,3223,NULL,NULL,NULL),('B001','2124-03-24','21','211','21','21','21','12',121,21,'12','12',NULL),('C001','2004-03-24','12','21','21','21','21','21',2121,21,'21','21','21'),('D200','2004-03-31','coco','gz','gz','gz','dkfkd','3',3,3333333,'dfd','23154','544');
UNLOCK TABLES;
/*!40000 ALTER TABLE employee ENABLE KEYS */;

--
-- Table structure for table `order_list`
--

DROP TABLE IF EXISTS order_list;
CREATE TABLE order_list (
id bigint(18) NOT NULL auto_increment,
order_id varchar(8) NOT NULL default '',
product_id varchar(4) NOT NULL default '',
kind varchar(16) NOT NULL default '',
name varchar(16) default NULL,
pack varchar(16) NOT NULL default '',
price decimal(4,3) NOT NULL default '0.000',
quantity int(5) NOT NULL default '0',
sum_m decimal(6,3) default NULL,
remark varchar(255) default NULL,
PRIMARY KEY (id)
) TYPE=MyISAM;

--
-- Dumping data for table `order_list`
--


/*!40000 ALTER TABLE order_list DISABLE KEYS */;
LOCK TABLES order_list WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE order_list ENABLE KEYS */;

--
-- Table structure for table `order_m`
--

DROP TABLE IF EXISTS order_m;
CREATE TABLE order_m (
id varchar(8) NOT NULL default '',
area varchar(8) NOT NULL default '',
city varchar(16) NOT NULL default '',
employee varchar(8) NOT NULL default '',
customer varchar(50) default NULL,
connect_person varchar(8) default NULL,
tel bigint(13) default NULL,
order_product_d date default NULL,
arrive_product_d date default NULL,
to_ad varchar(100) default NULL,
drop_id tinyint(1) default NULL,
sure tinyint(1) default NULL,
sum decimal(9,3) default NULL,
remark varchar(50) default NULL,
PRIMARY KEY (id)
) TYPE=MyISAM;

--
-- Dumping data for table `order_m`
--


/*!40000 ALTER TABLE order_m DISABLE KEYS */;
LOCK TABLES order_m WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE order_m ENABLE KEYS */;

--
-- Table structure for table `pbcatcol`
--

[oyzjin]

DROP TABLE IF EXISTS pbcatcol;
CREATE TABLE pbcatcol (
pbc_tnam varchar(65) NOT NULL default '',
pbc_tid int(11) default NULL,
pbc_ownr varchar(65) NOT NULL default '',
pbc_cnam varchar(65) NOT NULL default '',
pbc_cid smallint(6) default NULL,
pbc_labl varchar(254) default NULL,
pbc_lpos smallint(6) default NULL,
pbc_hdr varchar(254) default NULL,
pbc_hpos smallint(6) default NULL,
pbc_jtfy smallint(6) default NULL,
pbc_mask varchar(31) default NULL,
pbc_case smallint(6) default NULL,
pbc_hght smallint(6) default NULL,
pbc_wdth smallint(6) default NULL,
pbc_ptrn varchar(31) default NULL,
pbc_bmap char(1) default NULL,
pbc_init varchar(254) default NULL,
pbc_cmnt varchar(254) default NULL,
pbc_edit varchar(31) default NULL,
pbc_tag varchar(254) default NULL,
UNIQUE KEY pbcatc_x (pbc_tnam,pbc_ownr,pbc_cnam)
) TYPE=MyISAM;

--
-- Dumping data for table `pbcatcol`
--


/*!40000 ALTER TABLE pbcatcol DISABLE KEYS */;
LOCK TABLES pbcatcol WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE pbcatcol ENABLE KEYS */;

--
-- Table structure for table `pbcatedt`
--

DROP TABLE IF EXISTS pbcatedt;
CREATE TABLE pbcatedt (
pbe_name varchar(30) NOT NULL default '',
pbe_edit varchar(254) default NULL,
pbe_type smallint(6) default NULL,
pbe_cntr int(11) default NULL,
pbe_seqn smallint(6) NOT NULL default '0',
pbe_flag int(11) default NULL,
pbe_work varchar(32) default NULL,
UNIQUE KEY pbcate_x (pbe_name,pbe_seqn)
) TYPE=MyISAM;

--
-- Dumping data for table `pbcatedt`
--


/*!40000 ALTER TABLE pbcatedt DISABLE KEYS */;
LOCK TABLES pbcatedt WRITE;
INSERT INTO pbcatedt VALUES ('###,###.00','###,###.00',90,1,1,32,'10'),('#####','#####',90,1,1,32,'10'),('###-##-####','###-##-####',90,1,1,32,'00'),('MM/DD/YY','MM/DD/YY',90,1,1,32,'20'),('DD/MM/YY','DD/MM/YY',90,1,1,32,'20'),('MM/DD/YYYY','MM/DD/YYYY',90,1,1,32,'20'),('DD/MM/YYYY','DD/MM/YYYY',90,1,1,32,'20'),('DD/MMM/YY','DD/MMM/YY',90,1,1,32,'20'),('JJJ/YY','JJJ/YY',90,1,1,32,'20'),('JJJ/YYYY','JJJ/YYYY',90,1,1,32,'20'),('HH:MM:SS','HH:MM:SS',90,1,1,32,'30'),('HH:MM:SS:FFF','HH:MM:SS:FFF',90,1,1,32,'30'),('HH:MM:SS:FFFFFF','HH:MM:SS:FFFFFF',90,1,1,32,'30'),('MM/DD/YY HH:MM:SS','MM/DD/YY HH:MM:SS',90,1,1,32,'40'),('DD/MM/YY HH:MM:SS','DD/MM/YY HH:MM:SS',90,1,1,32,'40'),('MM/DD/YYYY HH:MM:SS','MM/DD/YYYY HH:MM:SS',90,1,1,32,'40'),('DD/MM/YYYY HH:MM:SS','DD/MM/YYYY HH:MM:SS',90,1,1,32,'40'),('DD/MMM/YY HH:MM:SS','DD/MMM/YY HH:MM:SS',90,1,1,32,'40'),('JJJ/YY HH:MM:SS','JJJ/YY HH:MM:SS',90,1,1,32,'40'),('JJJ/YYYY HH:MM:SS','JJJ/YYYY HH:MM:SS',90,1,1,32,'40'),('DD/MM/YY HH:MM:SS:FFFFFF','DD/MM/YY HH:MM:SS:FFFFFF',90,1,1,32,'40');
UNLOCK TABLES;
/*!40000 ALTER TABLE pbcatedt ENABLE KEYS */;

--
-- Table structure for table `pbcatfmt`
--

DROP TABLE IF EXISTS pbcatfmt;
CREATE TABLE pbcatfmt (
pbf_name varchar(30) NOT NULL default '',
pbf_frmt varchar(254) default NULL,
pbf_type smallint(6) default NULL,
pbf_cntr int(11) default NULL,
UNIQUE KEY pbcatf_x (pbf_name)
) TYPE=MyISAM;

--
-- Dumping data for table `pbcatfmt`
--


/*!40000 ALTER TABLE pbcatfmt DISABLE KEYS */;
LOCK TABLES pbcatfmt WRITE;
INSERT INTO pbcatfmt VALUES ('[General]','[General]',81,0),('0','0',81,0),('0.00','0.00',81,0),('#,##0','#,##0',81,0),('#,##0.00','#,##0.00',81,0),('$#,##0;($#,##0)','$#,##0;($#,##0)',81,0),('$#,##0;[RED]($#,##0)','$#,##0;[RED]($#,##0)',81,0),('$#,##0.00;($#,##0.00)','$#,##0.00;($#,##0.00)',81,0),('$#,##0.00;[RED]($#,##0.00)','$#,##0.00;[RED]($#,##0.00)',81,0),('0%','0%',81,0),('0.00%','0.00%',81,0),('0.00E+00','0.00E+00',81,0),('m/d/yy','m/d/yy',84,0),('d-mmm-yy','d-mmm-yy',84,0),('d-mmm','d-mmm',84,0),('mmm-yy','mmm-yy',84,0),('h:mm AM/PM','h:mm AM/PM',84,0),('h:mm:ss AM/PM','h:mm:ss AM/PM',84,0),('h:mm:ss','h:mm:ss',84,0),('m/d/yy h:mm','m/d/yy h:mm',84,0);
UNLOCK TABLES;
/*!40000 ALTER TABLE pbcatfmt ENABLE KEYS */;

--
-- Table structure for table `pbcattbl`
--

DROP TABLE IF EXISTS pbcattbl;
CREATE TABLE pbcattbl (
pbt_tnam varchar(65) NOT NULL default '',
pbt_tid int(11) default NULL,
pbt_ownr varchar(65) NOT NULL default '',
pbd_fhgt smallint(6) default NULL,
pbd_fwgt smallint(6) default NULL,
pbd_fitl char(1) default NULL,
pbd_funl char(1) default NULL,
pbd_fchr smallint(6) default NULL,
pbd_fptc smallint(6) default NULL,
pbd_ffce varchar(18) default NULL,
pbh_fhgt smallint(6) default NULL,
pbh_fwgt smallint(6) default NULL,
pbh_fitl char(1) default NULL,
pbh_funl char(1) default NULL,
pbh_fchr smallint(6) default NULL,
pbh_fptc smallint(6) default NULL,
pbh_ffce varchar(18) default NULL,
pbl_fhgt smallint(6) default NULL,
pbl_fwgt smallint(6) default NULL,
pbl_fitl char(1) default NULL,
pbl_funl char(1) default NULL,
pbl_fchr smallint(6) default NULL,
pbl_fptc smallint(6) default NULL,
pbl_ffce varchar(18) default NULL,
pbt_cmnt varchar(254) default NULL,
UNIQUE KEY pbcatt_x (pbt_tnam,pbt_ownr)
) TYPE=MyISAM;

--
-- Dumping data for table `pbcattbl`
--


/*!40000 ALTER TABLE pbcattbl DISABLE KEYS */;
LOCK TABLES pbcattbl WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE pbcattbl ENABLE KEYS */;

--
-- Table structure for table `pbcatvld`
--

DROP TABLE IF EXISTS pbcatvld;
CREATE TABLE pbcatvld (
pbv_name varchar(30) NOT NULL default '',
pbv_vald varchar(254) default NULL,
pbv_type smallint(6) default NULL,
pbv_cntr int(11) default NULL,
pbv_msg varchar(254) default NULL,
UNIQUE KEY pbcatv_x (pbv_name)
) TYPE=MyISAM;

--
-- Dumping data for table `pbcatvld`
--


/*!40000 ALTER TABLE pbcatvld DISABLE KEYS */;
LOCK TABLES pbcatvld WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE pbcatvld ENABLE KEYS */;

--
-- Table structure for table `product`
--

DROP TABLE IF EXISTS product;
CREATE TABLE product (
id varchar(4) NOT NULL default '',
update_date date NOT NULL default '0000-00-00',
kind varchar(16) NOT NULL default '',
name varchar(16) NOT NULL default '',
pack varchar(16) NOT NULL default '',
in_price decimal(6,3) default NULL,
box_price decimal(6,3) default NULL,
price decimal(6,3) default NULL,
wholesale decimal(6,3) default NULL,
market decimal(6,3) default NULL,
wholesale_market decimal(6,3) default NULL,
sale_price decimal(6,3) default NULL,
remark varchar(200) default NULL,
PRIMARY KEY (id)
) TYPE=MyISAM;

--
-- Dumping data for table `product`
--


/*!40000 ALTER TABLE product DISABLE KEYS */;
LOCK TABLES product WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE product ENABLE KEYS */;