API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jun 22nd, 2015
297
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 6.97 KB | None | 0 0
raw download clone embed print report
  1. INSERT INSERT into Customers VALUES
  2. ('1','1234 north street, town state 12345', '55', 'JohnSmith@yahoo.com', 'John', 'Smith', '555-123-5567');
  3. INSERT INSERT into Customers VALUES
  4. ('2','1234 north street, town state 12345', '56', 'JimmyFallon@yahoo.com', 'Jimmy', 'Fallon', '555-123-4532');
  5. INSERT INSERT into Customers VALUES
  6. ('3','1234 north street, town state 12345', '57', 'SusanBrown@yahoo.com', 'Susan', 'Brown', '555-123-7656');
  7. INSERT INSERT into Customers VALUES
  8. ('4','64536 west street, lazytown ia 54322', '58', 'JoeBlack@yahoo.com', 'Joe', 'Black', '555-345-6454');
  9. INSERT INSERT into Customers VALUES
  10. ('5','2345 east street, happytown mn 45684', '59', 'JackJohnson@yahoo.com', 'Jack', 'Johnson', '555-564-2345');
  11. INSERT INSERT into Customers VALUES
  12. ('6','7654 fun street, boringtown mn 78655', '60', 'AnnDee@yahoo.com', 'Ann', 'Dee', '555-785-6547');
  13. INSERT INSERT into Customers VALUES
  14. ('7','3456 east street, studytown mn 56324', '61', 'BobRyan@yahoo.com', 'Bob', 'Ryan', '555-654-1234');
  15. INSERT INSERT into Customers VALUES
  16. ('8','45216 east street, lametown mn 45584', '62', 'AlecBaldwin@yahoo.com', 'alec', 'Baldwin', '555-564-2345');
  17. INSERT INSERT into Customers VALUES
  18. ('9','75643 side street, partytown mn 75534', '63', 'MickeyMouse@yahoo.com', 'Mickey', 'Mouse', '555-789-4566');
  19. INSERT INSERT into Customers VALUES
  20. ('10','6543 front street, snoretown mn 32164', '64', 'DonJuan@yahoo.com', 'Don', 'Juan', '555-634-7645');
  21.  
  22.  
  23. INSERT INTO Customer_Billing
  24. VALUES ('1', '55', '123', '12/12/2012', '5345.00');
  25. INSERT INTO Customer_Billing
  26. VALUES ('2', '56', '124', '12/12/2012', '7654.00');
  27. INSERT INTO Customer_Billing
  28. VALUES ('3', '57', '125', '12/12/2012', '8765.00');
  29. INSERT INTO Customer_Billing
  30. VALUES ('4', '58', '126', '12/12/2012', '1987.00');
  31. INSERT INTO Customer_Billing
  32. VALUES ('5', '59', '127', '12/12/2012', '345.00');
  33. INSERT INTO Customer_Billing
  34. VALUES ('6', '60', '128', '12/12/2012', '8765.00');
  35. INSERT INTO Customer_Billing
  36. VALUES ('7', '61', '129', '12/12/2012', '963.00');
  37. INSERT INTO Customer_Billing
  38. VALUES ('8', '62', '130', '12/12/2012', '135.00');
  39. INSERT INTO Customer_Billing
  40. VALUES ('9', '63', '131', '12/12/2012', '864.00');
  41. INSERT INTO Customer_Billing
  42. VALUES ('10', '64', '132', '12/12/2012', '23456.00');
  43.  
  44. INSERT INTO Bids
  45. VALUES ('55', '1', '123', 'order for John Smith', 'yes', '5', '12/12/2012','12/12/2012','2345.00','12/12/2012');
  46. INSERT INTO Bids
  47. VALUES ('56', '2', '124', 'order for Jimmy Fallon', 'yes', '9', '12/12/2012','12/12/2012','23.00','12/12/2012');
  48. INSERT INTO Bids
  49. VALUES ('57', '3', '125', 'order for Susan Brown', 'yes', '6', '12/12/2012','12/12/2012','876.00','12/12/2012');
  50. INSERT INTO Bids
  51. VALUES ('58', '4', '126', 'order for Joe Black', 'yes', '5', '12/12/2012','12/12/2012','3456.00','12/12/2012');
  52. INSERT INTO Bids
  53. VALUES ('59', '5', '127', 'order for Jack Johnson', 'yes', '9', '12/12/2012','12/12/2012','345.00','12/12/2012');
  54. INSERT INTO Bids
  55. VALUES ('60', '6', '128', 'order for Ann Dee', 'yes', '6', '12/12/2012','12/12/2012','65.00','12/12/2012');
  56. INSERT INTO Bids
  57. VALUES ('61', '7', '129', 'order for Bob Ryan', 'yes', '5', '12/12/2012','12/12/2012','4356.00','12/12/2012');
  58. INSERT INTO Bids
  59. VALUES ('62', '8', '130', 'order for Alec Baldwin', 'yes', '9', '12/12/2012','12/12/2012','234.00','12/12/2012');
  60. INSERT INTO Bids
  61. VALUES ('63', '9', '131', 'order for Mickey Mouse', 'yes', '6', '12/12/2012','12/12/2012','6543.00','12/12/2012');
  62. INSERT INTO Bids
  63. VALUES ('64', '10', '132', 'order for Don Juan', 'yes', '6', '12/12/2012','12/12/2012','5432.00','12/12/2012');
  64.  
  65. INSERT INTO Orders
  66. VALUES ('12/12/2012', '11', '12/12/2012', '55', '4567.00', '6', '1');
  67. INSERT INTO Orders
  68. VALUES ('12/12/2012', '22', '12/12/2012', '56', '7645.00', '2', '2');
  69. INSERT INTO Orders
  70. VALUES ('12/12/2012', '33', '12/12/2012', '57', '3754.00', '9', '3');
  71. INSERT INTO Orders
  72. VALUES ('12/12/2012', '44', '12/12/2012', '58', '2354.00', '6', '4');
  73. INSERT INTO Orders
  74. VALUES ('12/12/2012', '55', '12/12/2012', '59', '645.00', '2', '5');
  75. INSERT INTO Orders
  76. VALUES ('12/12/2012', '66', '12/12/2012', '60', '2345.00', '9', '6');
  77. INSERT INTO Orders
  78. VALUES ('12/12/2012', '77', '12/12/2012', '61', '7654.00', '6', '7');
  79. INSERT INTO Orders
  80. VALUES ('12/12/2012', '88', '12/12/2012', '62', '8765.00', '2', '8');
  81. INSERT INTO Orders
  82. VALUES ('12/12/2012', '99', '12/12/2012', '63', '754.00', '9', '9');
  83. INSERT INTO Orders
  84. VALUES ('12/12/2012', '10', '12/12/2012', '64', '654.00', '9', '10');
  85.  
  86. INSERT INTO Supplier_Billing
  87. VALUES ('77', '1', '55', '1');
  88. INSERT INTO Supplier_Billing
  89. VALUES ('78', '2', '56', '2');
  90. INSERT INTO Supplier_Billing
  91. VALUES ('79', '3', '57', '3');
  92. INSERT INTO Supplier_Billing
  93. VALUES ('80', '4', '58', '4');
  94. INSERT INTO Supplier_Billing
  95. VALUES ('81', '5', '59', '5');
  96. INSERT INTO Supplier_Billing
  97. VALUES ('82', '6', '60', '6');
  98. INSERT INTO Supplier_Billing
  99. VALUES ('83', '7', '61', '7');
  100. INSERT INTO Supplier_Billing
  101. VALUES ('84', '8', '62', '8');
  102. INSERT INTO Supplier_Billing
  103. VALUES ('85', '9', '63', '9');
  104. INSERT INTO Supplier_Billing
  105. VALUES ('86', '10', '64', '10');
  106.  
  107.  
  108. INSERT INTO Suppliers
  109. VALUES ('1', '77', 'John Doe Lumber', '1122 Wood Avenue south town state 12345', '6513456543', '55', '11', '1234214.00');
  110. INSERT INTO Suppliers
  111. VALUES ('2', '78', 'jane Doe Lumber', '1123 Wood Avenue south town state 12345', '6513486543', '56', '22', '75647.00');
  112. INSERT INTO Suppliers
  113. VALUES ('3', '79', 'not john Doe Lumber', '1124 Wood Avenue south town state 12345', '6513556543', '57', '33', '4567.00');
  114. INSERT INTO Suppliers
  115. VALUES ('4', '80', 'bob Doe Lumber', '1235 Wood Avenue south town state 12345', '6514356798', '58', '44', '5.00');
  116. INSERT INTO Suppliers
  117. VALUES ('5', '81', 'nick Doe Lumber', '1236 Wood Avenue south town state 12345', '5554653728', '59', '55', '6543.00');
  118. INSERT INTO Suppliers
  119. VALUES ('6', '82', 'billy Doe Lumber', '1237 Wood Avenue south town state 12345', '5555555555', '60', '66', '65432.00');
  120. INSERT INTO Suppliers
  121. VALUES ('7', '83', 'jake Doe Lumber', '1238 Wood Avenue south town state 12345', '8520144565', '61', '77', '65432.00');
  122. INSERT INTO Suppliers
  123. VALUES ('8', '84', 'phil Doe Lumber', '1294 Wood Avenue south town state 12345', '1236789141', '62', '88', '24667.00');
  124. INSERT INTO Suppliers
  125. VALUES ('9', '85', 'jason Doe Lumber', '876 Wood Avenue south town state 12345', '6514569874', '63', '99', '3456.00');
  126. INSERT INTO Suppliers
  127. VALUES ('10', '86', 'ann Doe Lumber', '3456 Wood Avenue south town state 12345', '1230123444', '64', '10', '345643.00');
  128.  
  129.  
  130. INSERT INTO Item
  131. VALUES ('55', '11', '54.00', '9');
  132. INSERT INTO Item
  133. VALUES ('56', '22', '45.00', '6');
  134. INSERT INTO Item
  135. VALUES ('57', '33', '56.00', '8');
  136. INSERT INTO Item
  137. VALUES ('58', '44', '54.00', '4');
  138. INSERT INTO Item
  139. VALUES ('59', '55', '67.00', '6');
  140. INSERT INTO Item
  141. VALUES ('60', '66', '67.00', '3');
  142. INSERT INTO Item
  143. VALUES ('61', '77', '89.00', '8');
  144. INSERT INTO Item
  145. VALUES ('62', '88', '67.00', '6');
  146. INSERT INTO Item
  147. VALUES ('63', '99', '45.00', '8');
  148. INSERT INTO Item
  149. VALUES ('64', '10', '34.00', '1');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!