API tools faq
paste
Advertisement
Replace

Orders table structure + data

Replace
Dec 29th, 2017
382
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 16.43 KB | None | 0 0
raw download clone embed print report
  1. -- --------------------------------------------------------
  2. -- Host:                         127.0.0.1
  3. -- Server version:               5.7.14-log - MySQL Community Server (GPL)
  4. -- Server OS:                    Win64
  5. -- HeidiSQL Version:             9.5.0.5196
  6. -- --------------------------------------------------------
  7.  
  8. /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  9. /*!40101 SET NAMES utf8 */;
  10. /*!50503 SET NAMES utf8mb4 */;
  11. /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
  12. /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
  13.  
  14. -- Dumping structure for table just4test.orders
  15. DROP TABLE IF EXISTS `orders`;
  16. CREATE TABLE IF NOT EXISTS `orders` (
  17.   `Order_ID` int(11) DEFAULT NULL,
  18.   `Product` varchar(8) DEFAULT NULL,
  19.   `Category` varchar(10) DEFAULT NULL,
  20.   `Amount` int(11) DEFAULT NULL,
  21.   `Date` datetime DEFAULT NULL,
  22.   `Country` varchar(14) DEFAULT NULL
  23. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  24.  
  25. -- Dumping data for table just4test.orders: ~213 rows (approximately)
  26. /*!40000 ALTER TABLE `orders` DISABLE KEYS */;
  27. INSERT INTO `orders` (`Order_ID`, `Product`, `Category`, `Amount`, `Date`, `Country`) VALUES
  28.     (1, 'Carrots', 'Vegetables', 4270, '2016-01-06 00:00:00', 'United States'),
  29.     (2, 'Broccoli', 'Vegetables', 8239, '2016-01-07 00:00:00', 'United Kingdom'),
  30.     (3, 'Banana', 'Fruit', 617, '2016-01-08 00:00:00', 'United States'),
  31.     (4, 'Banana', 'Fruit', 8384, '2016-01-10 00:00:00', 'Canada'),
  32.     (5, 'Beans', 'Vegetables', 2626, '2016-01-10 00:00:00', 'Germany'),
  33.     (6, 'Orange', 'Fruit', 3610, '2016-01-11 00:00:00', 'United States'),
  34.     (7, 'Broccoli', 'Vegetables', 9062, '2016-01-11 00:00:00', 'Australia'),
  35.     (8, 'Banana', 'Fruit', 6906, '2016-01-16 00:00:00', 'New Zealand'),
  36.     (9, 'Apple', 'Fruit', 2417, '2016-01-16 00:00:00', 'France'),
  37.     (10, 'Apple', 'Fruit', 7431, '2016-01-16 00:00:00', 'Canada'),
  38.     (11, 'Banana', 'Fruit', 8250, '2016-01-16 00:00:00', 'Germany'),
  39.     (12, 'Broccoli', 'Vegetables', 7012, '2016-01-18 00:00:00', 'United States'),
  40.     (13, 'Carrots', 'Vegetables', 1903, '2016-01-20 00:00:00', 'Germany'),
  41.     (14, 'Broccoli', 'Vegetables', 2824, '2016-01-22 00:00:00', 'Canada'),
  42.     (15, 'Apple', 'Fruit', 6946, '2016-01-24 00:00:00', 'France'),
  43.     (16, 'Banana', 'Fruit', 2320, '2016-01-27 00:00:00', 'United Kingdom'),
  44.     (17, 'Banana', 'Fruit', 2116, '2016-01-28 00:00:00', 'United States'),
  45.     (18, 'Banana', 'Fruit', 1135, '2016-01-30 00:00:00', 'United Kingdom'),
  46.     (19, 'Broccoli', 'Vegetables', 3595, '2016-01-30 00:00:00', 'United Kingdom'),
  47.     (20, 'Apple', 'Fruit', 1161, '2016-02-02 00:00:00', 'United States'),
  48.     (21, 'Orange', 'Fruit', 2256, '2016-02-04 00:00:00', 'France'),
  49.     (22, 'Banana', 'Fruit', 1004, '2016-02-11 00:00:00', 'New Zealand'),
  50.     (23, 'Banana', 'Fruit', 3642, '2016-02-14 00:00:00', 'Canada'),
  51.     (24, 'Banana', 'Fruit', 4582, '2016-02-17 00:00:00', 'United States'),
  52.     (25, 'Beans', 'Vegetables', 3559, '2016-02-17 00:00:00', 'United Kingdom'),
  53.     (26, 'Carrots', 'Vegetables', 5154, '2016-02-17 00:00:00', 'Australia'),
  54.     (27, 'Mango', 'Fruit', 7388, '2016-02-18 00:00:00', 'France'),
  55.     (28, 'Beans', 'Vegetables', 7163, '2016-02-18 00:00:00', 'United States'),
  56.     (29, 'Beans', 'Vegetables', 5101, '2016-02-20 00:00:00', 'Germany'),
  57.     (30, 'Apple', 'Fruit', 7602, '2016-02-21 00:00:00', 'France'),
  58.     (31, 'Mango', 'Fruit', 1641, '2016-02-22 00:00:00', 'United States'),
  59.     (32, 'Apple', 'Fruit', 8892, '2016-02-23 00:00:00', 'Australia'),
  60.     (33, 'Apple', 'Fruit', 2060, '2016-02-29 00:00:00', 'France'),
  61.     (34, 'Broccoli', 'Vegetables', 1557, '2016-02-29 00:00:00', 'Germany'),
  62.     (35, 'Apple', 'Fruit', 6509, '2016-03-01 00:00:00', 'France'),
  63.     (36, 'Apple', 'Fruit', 5718, '2016-03-04 00:00:00', 'Australia'),
  64.     (37, 'Apple', 'Fruit', 7655, '2016-03-05 00:00:00', 'United States'),
  65.     (38, 'Carrots', 'Vegetables', 9116, '2016-03-05 00:00:00', 'United Kingdom'),
  66.     (39, 'Banana', 'Fruit', 2795, '2016-03-15 00:00:00', 'United States'),
  67.     (40, 'Banana', 'Fruit', 5084, '2016-03-15 00:00:00', 'United States'),
  68.     (41, 'Carrots', 'Vegetables', 8941, '2016-03-15 00:00:00', 'United Kingdom'),
  69.     (42, 'Broccoli', 'Vegetables', 5341, '2016-03-16 00:00:00', 'France'),
  70.     (43, 'Banana', 'Fruit', 135, '2016-03-19 00:00:00', 'Canada'),
  71.     (44, 'Banana', 'Fruit', 9400, '2016-03-19 00:00:00', 'Australia'),
  72.     (45, 'Beans', 'Vegetables', 6045, '2016-03-21 00:00:00', 'Germany'),
  73.     (46, 'Apple', 'Fruit', 5820, '2016-03-22 00:00:00', 'New Zealand'),
  74.     (47, 'Orange', 'Fruit', 8887, '2016-03-23 00:00:00', 'Germany'),
  75.     (48, 'Orange', 'Fruit', 6982, '2016-03-24 00:00:00', 'United States'),
  76.     (49, 'Banana', 'Fruit', 4029, '2016-03-26 00:00:00', 'Australia'),
  77.     (50, 'Carrots', 'Vegetables', 3665, '2016-03-26 00:00:00', 'Germany'),
  78.     (51, 'Banana', 'Fruit', 4781, '2016-03-29 00:00:00', 'France'),
  79.     (52, 'Mango', 'Fruit', 3663, '2016-03-30 00:00:00', 'Australia'),
  80.     (53, 'Apple', 'Fruit', 6331, '2016-04-01 00:00:00', 'France'),
  81.     (54, 'Apple', 'Fruit', 4364, '2016-04-01 00:00:00', 'Canada'),
  82.     (55, 'Carrots', 'Vegetables', 607, '2016-04-03 00:00:00', 'United Kingdom'),
  83.     (56, 'Banana', 'Fruit', 1054, '2016-04-06 00:00:00', 'New Zealand'),
  84.     (57, 'Carrots', 'Vegetables', 7659, '2016-04-06 00:00:00', 'United States'),
  85.     (58, 'Broccoli', 'Vegetables', 277, '2016-04-12 00:00:00', 'Germany'),
  86.     (59, 'Banana', 'Fruit', 235, '2016-04-17 00:00:00', 'United States'),
  87.     (60, 'Orange', 'Fruit', 1113, '2016-04-18 00:00:00', 'Australia'),
  88.     (61, 'Apple', 'Fruit', 1128, '2016-04-21 00:00:00', 'United States'),
  89.     (62, 'Broccoli', 'Vegetables', 9231, '2016-04-22 00:00:00', 'Canada'),
  90.     (63, 'Banana', 'Fruit', 4387, '2016-04-23 00:00:00', 'United States'),
  91.     (64, 'Apple', 'Fruit', 2763, '2016-04-25 00:00:00', 'Canada'),
  92.     (65, 'Banana', 'Fruit', 7898, '2016-04-27 00:00:00', 'United Kingdom'),
  93.     (66, 'Banana', 'Fruit', 2427, '2016-04-30 00:00:00', 'France'),
  94.     (67, 'Banana', 'Fruit', 8663, '2016-05-01 00:00:00', 'New Zealand'),
  95.     (68, 'Carrots', 'Vegetables', 2789, '2016-05-01 00:00:00', 'Germany'),
  96.     (69, 'Banana', 'Fruit', 4054, '2016-05-02 00:00:00', 'United States'),
  97.     (70, 'Mango', 'Fruit', 2262, '2016-05-02 00:00:00', 'United States'),
  98.     (71, 'Mango', 'Fruit', 5600, '2016-05-02 00:00:00', 'United Kingdom'),
  99.     (72, 'Banana', 'Fruit', 5787, '2016-05-03 00:00:00', 'United States'),
  100.     (73, 'Orange', 'Fruit', 6295, '2016-05-03 00:00:00', 'Canada'),
  101.     (74, 'Banana', 'Fruit', 474, '2016-05-05 00:00:00', 'Germany'),
  102.     (75, 'Apple', 'Fruit', 4325, '2016-05-05 00:00:00', 'France'),
  103.     (76, 'Banana', 'Fruit', 592, '2016-05-06 00:00:00', 'United States'),
  104.     (77, 'Orange', 'Fruit', 4330, '2016-05-08 00:00:00', 'United States'),
  105.     (78, 'Banana', 'Fruit', 9405, '2016-05-08 00:00:00', 'United Kingdom'),
  106.     (79, 'Apple', 'Fruit', 7671, '2016-05-08 00:00:00', 'France'),
  107.     (80, 'Carrots', 'Vegetables', 5791, '2016-05-08 00:00:00', 'United Kingdom'),
  108.     (81, 'Banana', 'Fruit', 6007, '2016-05-12 00:00:00', 'Canada'),
  109.     (82, 'Banana', 'Fruit', 5030, '2016-05-14 00:00:00', 'Germany'),
  110.     (83, 'Carrots', 'Vegetables', 6763, '2016-05-14 00:00:00', 'United Kingdom'),
  111.     (84, 'Banana', 'Fruit', 4248, '2016-05-15 00:00:00', 'Australia'),
  112.     (85, 'Banana', 'Fruit', 9543, '2016-05-16 00:00:00', 'France'),
  113.     (86, 'Broccoli', 'Vegetables', 2054, '2016-05-16 00:00:00', 'United Kingdom'),
  114.     (87, 'Beans', 'Vegetables', 7094, '2016-05-16 00:00:00', 'Germany'),
  115.     (88, 'Carrots', 'Vegetables', 6087, '2016-05-18 00:00:00', 'United States'),
  116.     (89, 'Apple', 'Fruit', 4264, '2016-05-19 00:00:00', 'Australia'),
  117.     (90, 'Mango', 'Fruit', 9333, '2016-05-20 00:00:00', 'United States'),
  118.     (91, 'Mango', 'Fruit', 8775, '2016-05-22 00:00:00', 'Germany'),
  119.     (92, 'Broccoli', 'Vegetables', 2011, '2016-05-23 00:00:00', 'United Kingdom'),
  120.     (93, 'Banana', 'Fruit', 5632, '2016-05-25 00:00:00', 'United States'),
  121.     (94, 'Banana', 'Fruit', 4904, '2016-05-25 00:00:00', 'New Zealand'),
  122.     (95, 'Beans', 'Vegetables', 1002, '2016-05-25 00:00:00', 'Australia'),
  123.     (96, 'Orange', 'Fruit', 8141, '2016-05-26 00:00:00', 'United Kingdom'),
  124.     (97, 'Orange', 'Fruit', 3644, '2016-05-26 00:00:00', 'Canada'),
  125.     (98, 'Orange', 'Fruit', 1380, '2016-05-26 00:00:00', 'Australia'),
  126.     (99, 'Broccoli', 'Vegetables', 8354, '2016-05-26 00:00:00', 'Germany'),
  127.     (100, 'Banana', 'Fruit', 5182, '2016-05-27 00:00:00', 'United States'),
  128.     (101, 'Apple', 'Fruit', 2193, '2016-05-27 00:00:00', 'France'),
  129.     (102, 'Mango', 'Fruit', 3647, '2016-05-28 00:00:00', 'United States'),
  130.     (103, 'Apple', 'Fruit', 4104, '2016-05-28 00:00:00', 'United States'),
  131.     (104, 'Carrots', 'Vegetables', 7457, '2016-05-28 00:00:00', 'United States'),
  132.     (105, 'Mango', 'Fruit', 3767, '2016-05-29 00:00:00', 'Canada'),
  133.     (106, 'Broccoli', 'Vegetables', 4685, '2016-05-30 00:00:00', 'Germany'),
  134.     (107, 'Banana', 'Fruit', 3917, '2016-06-04 00:00:00', 'United States'),
  135.     (108, 'Apple', 'Fruit', 521, '2016-06-04 00:00:00', 'Canada'),
  136.     (109, 'Apple', 'Fruit', 5605, '2016-06-10 00:00:00', 'France'),
  137.     (110, 'Broccoli', 'Vegetables', 9630, '2016-06-11 00:00:00', 'Germany'),
  138.     (111, 'Banana', 'Fruit', 6941, '2016-06-20 00:00:00', 'Canada'),
  139.     (112, 'Broccoli', 'Vegetables', 7231, '2016-06-20 00:00:00', 'United Kingdom'),
  140.     (113, 'Broccoli', 'Vegetables', 8891, '2016-06-23 00:00:00', 'Australia'),
  141.     (114, 'Banana', 'Fruit', 107, '2016-06-25 00:00:00', 'France'),
  142.     (115, 'Banana', 'Fruit', 4243, '2016-06-26 00:00:00', 'United States'),
  143.     (116, 'Orange', 'Fruit', 4514, '2016-06-27 00:00:00', 'United States'),
  144.     (117, 'Mango', 'Fruit', 5480, '2016-07-02 00:00:00', 'United States'),
  145.     (118, 'Banana', 'Fruit', 5002, '2016-07-02 00:00:00', 'France'),
  146.     (119, 'Banana', 'Fruit', 8530, '2016-07-05 00:00:00', 'Canada'),
  147.     (120, 'Orange', 'Fruit', 4819, '2016-07-07 00:00:00', 'New Zealand'),
  148.     (121, 'Broccoli', 'Vegetables', 6343, '2016-07-11 00:00:00', 'United Kingdom'),
  149.     (122, 'Orange', 'Fruit', 2318, '2016-07-13 00:00:00', 'United Kingdom'),
  150.     (123, 'Orange', 'Fruit', 220, '2016-07-20 00:00:00', 'United Kingdom'),
  151.     (124, 'Orange', 'Fruit', 6341, '2016-07-20 00:00:00', 'New Zealand'),
  152.     (125, 'Apple', 'Fruit', 330, '2016-07-20 00:00:00', 'Germany'),
  153.     (126, 'Broccoli', 'Vegetables', 3027, '2016-07-20 00:00:00', 'United Kingdom'),
  154.     (127, 'Orange', 'Fruit', 850, '2016-07-22 00:00:00', 'New Zealand'),
  155.     (128, 'Banana', 'Fruit', 8986, '2016-07-23 00:00:00', 'United Kingdom'),
  156.     (129, 'Broccoli', 'Vegetables', 3800, '2016-07-25 00:00:00', 'United States'),
  157.     (130, 'Carrots', 'Vegetables', 5751, '2016-07-28 00:00:00', 'United Kingdom'),
  158.     (131, 'Apple', 'Fruit', 1704, '2016-07-29 00:00:00', 'United Kingdom'),
  159.     (132, 'Banana', 'Fruit', 7966, '2016-07-30 00:00:00', 'Australia'),
  160.     (133, 'Banana', 'Fruit', 852, '2016-07-31 00:00:00', 'United States'),
  161.     (134, 'Beans', 'Vegetables', 8416, '2016-07-31 00:00:00', 'Australia'),
  162.     (135, 'Banana', 'Fruit', 7144, '2016-08-01 00:00:00', 'France'),
  163.     (136, 'Broccoli', 'Vegetables', 7854, '2016-08-01 00:00:00', 'United States'),
  164.     (137, 'Orange', 'Fruit', 859, '2016-08-03 00:00:00', 'United States'),
  165.     (138, 'Broccoli', 'Vegetables', 8049, '2016-08-12 00:00:00', 'United States'),
  166.     (139, 'Banana', 'Fruit', 2836, '2016-08-13 00:00:00', 'Germany'),
  167.     (140, 'Carrots', 'Vegetables', 1743, '2016-08-19 00:00:00', 'United States'),
  168.     (141, 'Apple', 'Fruit', 3844, '2016-08-23 00:00:00', 'France'),
  169.     (142, 'Apple', 'Fruit', 7490, '2016-08-24 00:00:00', 'France'),
  170.     (143, 'Broccoli', 'Vegetables', 4483, '2016-08-25 00:00:00', 'Germany'),
  171.     (144, 'Apple', 'Fruit', 7333, '2016-08-27 00:00:00', 'Canada'),
  172.     (145, 'Carrots', 'Vegetables', 7654, '2016-08-28 00:00:00', 'United States'),
  173.     (146, 'Apple', 'Fruit', 3944, '2016-08-29 00:00:00', 'United Kingdom'),
  174.     (147, 'Beans', 'Vegetables', 5761, '2016-08-29 00:00:00', 'Germany'),
  175.     (148, 'Banana', 'Fruit', 6864, '2016-09-01 00:00:00', 'New Zealand'),
  176.     (149, 'Banana', 'Fruit', 4016, '2016-09-01 00:00:00', 'Germany'),
  177.     (150, 'Banana', 'Fruit', 1841, '2016-09-02 00:00:00', 'United States'),
  178.     (151, 'Banana', 'Fruit', 424, '2016-09-05 00:00:00', 'Australia'),
  179.     (152, 'Banana', 'Fruit', 8765, '2016-09-07 00:00:00', 'United Kingdom'),
  180.     (153, 'Banana', 'Fruit', 5583, '2016-09-08 00:00:00', 'United States'),
  181.     (154, 'Broccoli', 'Vegetables', 4390, '2016-09-09 00:00:00', 'New Zealand'),
  182.     (155, 'Broccoli', 'Vegetables', 352, '2016-09-09 00:00:00', 'Canada'),
  183.     (156, 'Apple', 'Fruit', 8489, '2016-09-11 00:00:00', 'United States'),
  184.     (157, 'Banana', 'Fruit', 7090, '2016-09-11 00:00:00', 'France'),
  185.     (158, 'Banana', 'Fruit', 7880, '2016-09-15 00:00:00', 'United States'),
  186.     (159, 'Orange', 'Fruit', 3861, '2016-09-18 00:00:00', 'United States'),
  187.     (160, 'Broccoli', 'Vegetables', 7927, '2016-09-19 00:00:00', 'Germany'),
  188.     (161, 'Banana', 'Fruit', 6162, '2016-09-20 00:00:00', 'United States'),
  189.     (162, 'Mango', 'Fruit', 5523, '2016-09-25 00:00:00', 'Australia'),
  190.     (163, 'Broccoli', 'Vegetables', 5936, '2016-09-25 00:00:00', 'United Kingdom'),
  191.     (164, 'Carrots', 'Vegetables', 7251, '2016-09-26 00:00:00', 'Germany'),
  192.     (165, 'Orange', 'Fruit', 6187, '2016-09-27 00:00:00', 'Australia'),
  193.     (166, 'Banana', 'Fruit', 3210, '2016-09-29 00:00:00', 'Germany'),
  194.     (167, 'Carrots', 'Vegetables', 682, '2016-09-29 00:00:00', 'Germany'),
  195.     (168, 'Banana', 'Fruit', 793, '2016-10-03 00:00:00', 'Australia'),
  196.     (169, 'Carrots', 'Vegetables', 5346, '2016-10-04 00:00:00', 'Germany'),
  197.     (170, 'Banana', 'Fruit', 7103, '2016-10-07 00:00:00', 'New Zealand'),
  198.     (171, 'Carrots', 'Vegetables', 4603, '2016-10-10 00:00:00', 'United States'),
  199.     (172, 'Apple', 'Fruit', 8160, '2016-10-16 00:00:00', 'France'),
  200.     (173, 'Apple', 'Fruit', 7171, '2016-10-23 00:00:00', 'United Kingdom'),
  201.     (174, 'Banana', 'Fruit', 3552, '2016-10-23 00:00:00', 'New Zealand'),
  202.     (175, 'Banana', 'Fruit', 7273, '2016-10-25 00:00:00', 'Australia'),
  203.     (176, 'Banana', 'Fruit', 2402, '2016-10-26 00:00:00', 'Germany'),
  204.     (177, 'Banana', 'Fruit', 1197, '2016-10-26 00:00:00', 'Australia'),
  205.     (178, 'Beans', 'Vegetables', 5015, '2016-10-26 00:00:00', 'Australia'),
  206.     (179, 'Orange', 'Fruit', 5818, '2016-11-02 00:00:00', 'United States'),
  207.     (180, 'Banana', 'Fruit', 4399, '2016-11-03 00:00:00', 'United Kingdom'),
  208.     (181, 'Carrots', 'Vegetables', 3011, '2016-11-03 00:00:00', 'United States'),
  209.     (182, 'Apple', 'Fruit', 4715, '2016-11-09 00:00:00', 'United Kingdom'),
  210.     (183, 'Apple', 'Fruit', 5321, '2016-11-12 00:00:00', 'France'),
  211.     (184, 'Banana', 'Fruit', 8894, '2016-11-15 00:00:00', 'United States'),
  212.     (185, 'Carrots', 'Vegetables', 4846, '2016-11-25 00:00:00', 'United Kingdom'),
  213.     (186, 'Broccoli', 'Vegetables', 284, '2016-11-25 00:00:00', 'Germany'),
  214.     (187, 'Orange', 'Fruit', 8283, '2016-11-26 00:00:00', 'United Kingdom'),
  215.     (188, 'Orange', 'Fruit', 9990, '2016-11-28 00:00:00', 'Canada'),
  216.     (189, 'Banana', 'Fruit', 9014, '2016-11-28 00:00:00', 'Australia'),
  217.     (190, 'Apple', 'Fruit', 1942, '2016-11-29 00:00:00', 'France'),
  218.     (191, 'Banana', 'Fruit', 7223, '2016-11-30 00:00:00', 'United States'),
  219.     (192, 'Carrots', 'Vegetables', 4673, '2016-12-02 00:00:00', 'United States'),
  220.     (193, 'Carrots', 'Vegetables', 9104, '2016-12-04 00:00:00', 'France'),
  221.     (194, 'Apple', 'Fruit', 6078, '2016-12-05 00:00:00', 'United States'),
  222.     (195, 'Beans', 'Vegetables', 3278, '2016-12-06 00:00:00', 'Germany'),
  223.     (196, 'Banana', 'Fruit', 136, '2016-12-12 00:00:00', 'Canada'),
  224.     (197, 'Banana', 'Fruit', 8377, '2016-12-12 00:00:00', 'Australia'),
  225.     (198, 'Banana', 'Fruit', 2382, '2016-12-12 00:00:00', 'United States'),
  226.     (199, 'Banana', 'Fruit', 8702, '2016-12-15 00:00:00', 'Germany'),
  227.     (200, 'Banana', 'Fruit', 5021, '2016-12-16 00:00:00', 'United States'),
  228.     (201, 'Apple', 'Fruit', 1760, '2016-12-16 00:00:00', 'Australia'),
  229.     (202, 'Banana', 'Fruit', 4766, '2016-12-18 00:00:00', 'Germany'),
  230.     (203, 'Beans', 'Vegetables', 1541, '2016-12-19 00:00:00', 'United Kingdom'),
  231.     (204, 'Orange', 'Fruit', 2782, '2016-12-20 00:00:00', 'United Kingdom'),
  232.     (205, 'Apple', 'Fruit', 2455, '2016-12-20 00:00:00', 'Canada'),
  233.     (206, 'Apple', 'Fruit', 4512, '2016-12-22 00:00:00', 'New Zealand'),
  234.     (207, 'Apple', 'Fruit', 8752, '2016-12-22 00:00:00', 'Germany'),
  235.     (208, 'Carrots', 'Vegetables', 9127, '2016-12-25 00:00:00', 'United States'),
  236.     (209, 'Apple', 'Fruit', 1777, '2016-12-28 00:00:00', 'France'),
  237.     (210, 'Beans', 'Vegetables', 680, '2016-12-28 00:00:00', 'France'),
  238.     (211, 'Orange', 'Fruit', 958, '2016-12-29 00:00:00', 'United States'),
  239.     (212, 'Carrots', 'Vegetables', 2613, '2016-12-29 00:00:00', 'Australia'),
  240.     (213, 'Carrots', 'Vegetables', 339, '2016-12-30 00:00:00', 'Australia');
  241. /*!40000 ALTER TABLE `orders` ENABLE KEYS */;
  242.  
  243. /*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
  244. /*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
  245. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
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!