1、申 请 I D：chokfan
2、个人邮箱：370679091@qq.com
3、原创技术文章： 本人是大一新生正在学习数据库的知识，本人想在站里更好的为别人服务，跟高手交流，还望收留，下面是鄙人的作品
销售数据库的主要数据表的数据插入
/* 1、部门表Department */
USE Sales
INSERT INTO department (department_id,department_name, manager,depart_description) VALUES ('D001','总经理','钱达理','经理办公室')
INSERT INTO department (department_id,department_name, manager,depart_description) VALUES ('D002','市场部','郭文斌','市场办公室')
INSERT INTO department (department_id,department_name, manager,depart_description) VALUES ('D003','销售部','肖海燕','销售办公室')
INSERT INTO department (department_id,department_name, manager,depart_description) VALUES ('D004','仓储部','张明华','仓储办公室')
/* 2、员工表employee */
USE Sales
INSERT INTO employee (employee_id,employee_name,sex,birth_date,hire_date,address,telephone,wages,department_id,resume)
VALUES ('E001','钱达理','男','1970-03-06','1995-02-07','东风路','84110001',8000,'D001','华工')
INSERT INTO employee (employee_id,employee_name,sex,birth_date,hire_date,address,telephone,wages,department_id,resume)
VALUES ('E002','东方牧','男','1973-04-08','1996-05-22','五一路','84110002',6000,'D001','华工')
INSERT INTO employee (employee_id,employee_name,sex,birth_date,hire_date,address,telephone,wages,department_id,resume)
VALUES ('E003','郭文斌','男','1974-05-06','1997-03-22','公司宿舍','84110003',7200,'D002','广工')
INSERT INTO employee (employee_id,employee_name,sex,birth_date,hire_date,address,telephone,wages,department_id,resume)
VALUES ('E004','肖海燕','女','1976-08-09','2000-03-21','公司宿舍','84110004',7200,'D003','广工')
INSERT INTO employee (employee_id,employee_name,sex,birth_date,hire_date,address,telephone,wages,department_id,resume)
VALUES ('E005','张明华','男','1977-10-23','2001-04-11','潮州路','84110005',4000,'D004','华师')
/* 3、商品规格表goods_classification */
USE Sales
INSERT INTO goods_classification (classification_id,classification_name,classification_description,classification_picture)
VALUES ('A001','苹果电脑','笔记本','pic01')
INSERT INTO goods_classification (classification_id,classification_name,classification_description,classification_picture)
VALUES ('A002','戴尔电脑','台式','pic02')
INSERT INTO goods_classification (classification_id,classification_name,classification_description,classification_picture)
VALUES ('A003','联想电脑','台式','pic03')
INSERT INTO goods_classification (classification_id,classification_name,classification_description,classification_picture)
VALUES ('A004','佳能打印机','彩色','pic04')
INSERT INTO goods_classification (classification_id,classification_name,classification_description,classification_picture)
VALUES ('A005','三星打印机','黑白','pic05')
/* 4、商品表goods */
USE Sales
INSERT INTO goods (goods_id,goods_name,classification_id,unit_price,stock_quantity,order_quantity)
VALUES ('G001','计算机','A001',12000,15,4)
INSERT INTO goods (goods_id,goods_name,classification_id,unit_price,stock_quantity,order_quantity)
VALUES ('G002','打印机','A004',800,6,2)
INSERT INTO goods (goods_id,goods_name,classification_id,unit_price,stock_quantity,order_quantity)
VALUES ('G003','打印机','A005',500,8,1)
INSERT INTO goods (goods_id,goods_name,classification_id,unit_price,stock_quantity,order_quantity)
VALUES ('G004','计算机','A003',4500,5,0)
/* 5、客户表customer */
USE Sales
INSERT INTO customer (customer_id,customer_name,linkman_name,address,telephone)
VALUES ('C001','张三','张三','北京','10110001')
INSERT INTO customer (customer_id,customer_name,linkman_name,address,telephone)
VALUES ('C002','李四','李四','上海','20120005')
INSERT INTO customer (customer_id,customer_name,linkman_name,address,telephone)
VALUES ('C003','陈五','陈五',NULL,'84030001')
/* 6、销售订单表sell_order */
USE Sales
INSERT INTO sell_order (order_id1,goods_id,employee_id,customer_id,transporter_id,order_num,discount,order_date,send_date,arrival_date,cost)
VALUES ('S001','G001','E003','C001','T001',3,0.0,'2016-02-05','2016-02-07','2016-03-20',36000)
INSERT INTO sell_order (order_id1,goods_id,employee_id,customer_id,transporter_id,order_num,discount,order_date,send_date,arrival_date,cost)
VALUES ('S002','G002','E003','C002','T001',2,0.0,'2016-02-05','2016-02-10','2016-03-30',1600)
INSERT INTO sell_order (order_id1,goods_id,employee_id,customer_id,transporter_id,order_num,discount,order_date,send_date,arrival_date,cost)
VALUES ('S003','G003','E004','C003','T001',1,0.0,'2016-04-13','2016-04-20','2016-05-01',500)
INSERT INTO sell_order (order_id1,goods_id,employee_id,customer_id,transporter_id,order_num,discount,order_date,send_date,arrival_date,cost)
VALUES ('S004','G001','E004','C003','T001',1,0.2,'2016-04-13','2016-04-20','2016-05-01',9600)
INSERT INTO sell_order (order_id1,goods_id,employee_id,customer_id,transporter_id,order_num,discount,order_date,send_date,arrival_date,cost)
VALUES ('S005','G004','E003','C001','T001',5,0.0,'2016-04-15','2016-04-20','2016-05-01',22500)
INSERT INTO sell_order (order_id1,goods_id,employee_id,customer_id,transporter_id,order_num,discount,order_date,send_date,arrival_date,cost)
VALUES ('S006','G003','E004','C002','T001',2,0.0,'2016-04-15','2016-04-23','2016-05-02',1000)
|
吾爱游客
发表于 2016-9-10 00:51
