MySQL and DB2 ORDERS TABLE INSERT STATEMENTS

INSERT INTO Orders (CustomerID, PlanID, OrderDate, CancelationDate)
Values (1, 'D1002', '1999/11/11', NULL);

INSERT INTO Orders (CustomerID, PlanID, OrderDate, CancelationDate)
Values (10, 'D1002', '1998/03/15', '2001/03/30');

INSERT INTO Orders (CustomerID, PlanID, OrderDate, CancelationDate)
Values (10, 'D1003', '1998/03/15', NULL);

INSERT INTO Orders (CustomerID, PlanID, OrderDate, CancelationDate)
Values (10, 'D2202', '2001/01/01', NULL);

INSERT INTO Orders (CustomerID, PlanID, OrderDate, CancelationDate)
Values (2, 'W1001', '2001/03/15', NULL);

INSERT INTO Orders (CustomerID, PlanID, OrderDate, CancelationDate)
Values (2, 'L2003', '2001/03/15', NULL);

INSERT INTO Orders (CustomerID, PlanID, OrderDate, CancelationDate)
Values (2, 'I1001', '2001/03/20', NULL);

INSERT INTO Orders (CustomerID, PlanID, OrderDate, CancelationDate)
Values (3, 'L2002', '2000/07/10', NULL);

INSERT INTO Orders (CustomerID, PlanID, OrderDate, CancelationDate)
Values (3, 'L2001', '2000/07/10', NULL);

INSERT INTO Orders (CustomerID, PlanID, OrderDate, CancelationDate)
Values (4, 'L2004', '2001/02/15', NULL);

INSERT INTO Orders (CustomerID, PlanID, OrderDate, CancelationDate)
Values (7, 'L2004', '2001/05/14', NULL);

INSERT INTO Orders (CustomerID, PlanID, OrderDate, CancelationDate)
Values (6, 'D1002', '2000/11/04', NULL);

INSERT INTO Orders (CustomerID, PlanID, OrderDate, CancelationDate)
Values (6, 'D1101', '2000/11/04', NULL);

INSERT INTO Orders (CustomerID, PlanID, OrderDate, CancelationDate)
Values (5, 'I1001', '1999/06/06', NULL);

INSERT INTO Orders (CustomerID, PlanID, OrderDate, CancelationDate)
Values (8, 'I1001', '1999/03/14', NULL);

INSERT INTO Orders (CustomerID, PlanID, OrderDate, CancelationDate)
Values (6, 'I1001', '2000/11/04', NULL);

INSERT INTO Orders (CustomerID, PlanID, OrderDate, CancelationDate)
Values (7, 'L2001', '2001/05/13', NULL);

INSERT INTO Orders (CustomerID, PlanID, OrderDate, CancelationDate)
Values (4, 'L2001', '2001/02/15', NULL);

INSERT INTO Orders (CustomerID, PlanID, OrderDate, CancelationDate)
Values (8, 'L2001', '1999/03/17', NULL);

INSERT INTO Orders (CustomerID, PlanID, OrderDate, CancelationDate)
Values (8, 'L2002', '1999/03/17', NULL);

INSERT INTO Orders (CustomerID, PlanID, OrderDate, CancelationDate)
Values (9, 'L2003', '2000/06/11', NULL);

back