· 6 years ago · Aug 08, 2019, 03:22 PM
1CREATE TABLE IF NOT EXISTS 2018 (
2 `Monday` VARCHAR(6) CHARACTER SET utf8,
3 `January_1` VARCHAR(10) CHARACTER SET utf8,
4 `Column_07_48_35` VARCHAR(8) CHARACTER SET utf8,
5 `Column_36198` INT,
6 `R100085` VARCHAR(7) CHARACTER SET utf8,
7 `Column_1` INT,
8 `Breakfast_Buffet` VARCHAR(22) CHARACTER SET utf8,
9 `Column_1` INT
10);
11INSERT INTO 2018 VALUES
12 ('Monday',' January 1','07:48:39',36198,'R100085',1,'Breakfast Buffet',1),
13 ('Monday',' January 1','08:58:54',36201,'R100085',1,'Breakfast Buffet',1),
14 ('Monday',' January 1','09:04:30',36202,'R100085',1,'Breakfast Buffet',1),
15 ('Monday',' January 1','09:12:45',36204,'R100085',1,'Breakfast Buffet',1),
16 ('Monday',' January 1','09:27:12',36205,'R100085',1,'Breakfast Buffet',1),
17 ('Monday',' January 1','08:07:37',36199,'R100620',1,'Children B''Fast Buffet',1),
18 ('Monday',' January 1','09:05:29',36203,'R100620',1,'Children B''Fast Buffet',1),
19 ('Monday',' January 1','09:56:31',36207,'R100620',2,'Children B''Fast Buffet',1),
20 ('Monday',' January 1','10:11:32',36208,'R100620',1,'Children B''Fast Buffet',1),
21 ('Monday',' January 1','13:03:04',36209,'R100436',1,'Pisang Ijo',1),
22 ('Monday',' January 1','08:09:28',36200,'R100169',1,'Espresso Toraja',1);