申请ID：chokfan

发表于 2016-9-10 00:51

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 INTOgoods (goods_id,goods_name,classification_id,unit_price,stock_quantity,order_quantity)
         VALUES ('G001','计算机','A001',12000,15,4)

INSERT INTOgoods (goods_id,goods_name,classification_id,unit_price,stock_quantity,order_quantity)
         VALUES ('G002','打印机','A004',800,6,2)

INSERT INTOgoods (goods_id,goods_name,classification_id,unit_price,stock_quantity,order_quantity)
         VALUES ('G003','打印机','A005',500,8,1)

INSERT INTOgoods (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 INTOsell_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 INTOsell_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 INTOsell_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 INTOsell_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 INTOsell_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 INTOsell_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)

Hmily 发表于 2016-9-12 10:51

抱歉，未能达到申请要求，申请不通过，可以关注论坛官方微信（吾爱破解论坛），等待开放注册通知。

页: [1]

吾爱破解 - 52pojie.cn's Archiver

申请ID：chokfan