SHARE
TWEET

Orders table structure + data

Replace Dec 29th, 2017 154 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  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 */;
RAW Paste Data
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
 
Top