1INSERT INTO Orders (OrderID, CustID, OpenDate, SalesPerson, Status)
2 VALUES (2002, 1001, {fn CURDATE()}, 'Garcia', 'OPEN');
3INSERT INTO Lines (OrderID, Line, PartID, Quantity)
4 VALUES (2002, 1, 1234, 10);
5INSERT INTO Lines (OrderID, Line, PartID, Quantity)
6 VALUES (2002, 2, 987, 8);
7INSERT INTO Lines (OrderID, Line, PartID, Quantity)
8 VALUES (2002, 3, 566, 17);
9INSERT INTO Lines (OrderID, Line, PartID, Quantity)
10 VALUES (2002, 4, 412, 500)
11