MariaDB 10.3

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE `FoodLog` (
  `id` int(11) NOT NULL,
  `studentID` int(11) NOT NULL,
  `logId` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
  `foodName` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `calories` smallint(5) DEFAULT 0,
  `carbs` smallint(5) DEFAULT 0,
  `fat` smallint(5) DEFAULT 0,
  `protein` smallint(5) DEFAULT 0,
  `logDate` date NOT NULL,
  `amount` char(6) COLLATE utf8mb4_unicode_ci NOT NULL,
  `unit` char(10) COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `FoodLog` (`id`, `studentID`, `logId`, `foodName`, `calories`, `carbs`, `fat`, `protein`, `logDate`, `amount`, `unit`) VALUES
(578, 1329, '24794060811', 'Milk', 62, 5, 2, 4, '2021-02-02', '0', 'cups'),
(567, 1329, '24792463399', 'Milk', 123, 10, 5, 8, '2021-02-02', '1', 'cups'),
(568, 1329, '24793322330', 'Espresso', 7, 1, 0, 0, '2021-02-02', '1', 'servings'),
(569, 1329, '24794493486', 'Whipped Cream', 10, 0, 0, 0, '2021-02-02', '1', 'tbsp'),
(570, 1329, '24790882300', 'Egg, Chicken, Fried', 92, 0, 7, 6, '2021-02-02', '1', 'larges'),
(571, 1329, '24791304710', 'Bacon', 119, 0, 10, 4, '2021-02-02', '4', 'strips'),
(575, 1329, '24792692553', 'Sausage', 300, 0, 28, 10, '2021-02-02', '2', 'servings'),
(572, 1329, '24791757624', 'Whipped Cream', 10, 0, 0, 0, '2021-02-02', '1', 'tbsp'),
(573, 1329, '24791945218', 'Banana', 121, 28, 0, 1, '2021-02-02', '1', 'larges'),
(574, 1329, '24791974280', 'Bagel, Plain Bagel', 260, 51, 2, 9, '2021-02-02', '1', 'bagels'),
(576, 1329, '24793805486', 'Pineapple', 34, 8, 0, 0, '2021-02-02', '0', 'cups'),
(577, 1329, '24793893474', 'Strawberry / Strawberries', 10, 2, 0, 0, '2021-02-02', '2', 'larges'),
(540, 1329, '24776678847', 'Espresso', 7, 1, 0, 0, '2021-02-01', '1', 'servings'),
(539, 1329, '24775625962', 'Whipped Cream', 10, 0, 0, 0, '2021-02-01', '1', 'tbsp'),
(538, 1329, '24776268371', 'Milk', 123, 10, 5, 8, '2021-02-01', '1', 'cups'),
(516, 1329, '24758559433', 'Blueberries', 21, 5, 0, 0, '2021-01-31', '0', 'cups'),
(514, 1329, '24758815161', 'Milk', 123, 10, 5, 8, '2021-01-31', '1', 'cups'),
(515, 1329, '24758244329', 'Pineapple', 34, 8, 0, 0, '2021-01-31', '0', 'cups'),
(505, 1329, '24749678677', 'Sausage', 150, 0, 14, 5, '2021-01-30', '1', 'servings'),
(504, 1329, '24749580620', 'Egg, Chicken, Fried', 92, 0, 7, 6, '2021-01-30', '1', 'larges'),
(503, 1329, '24751203105', 'Milk', 123, 10, 5, 8, '2021-01-30', '1', 'cups'),
(495, 1329, '24743267907', 'Whipped Cream', 10, 0, 0, 0, '2021-01-29', '1', 'tbsp'),
(494, 1329, '24742156649', 'Milk', 62, 5, 2, 4, '2021-01-29', '0', 'cups'),
(493, 1329, '24734837038', 'Milk', 123, 10, 5, 8, '2021-01-29', '1', 'cups'),
(477, 1329, '24728165665', 'Milk', 123, 10, 5, 8, '2021-01-28', '1', 'cups'),
(460, 1329, '24711743529', 'Whipped Cream', 10, 0, 0, 0, '2021-01-27', '1', 'tbsp'),
(459, 1329, '24710848338', 'Espresso', 7, 1, 0, 0, '2021-01-27', '1', 'servings'),
(458, 1329, '24711222208', 'Milk', 123, 10, 5, 8, '2021-01-27', '1', 'cups'),
(406, 1329, '24686341139', 'Espresso', 7, 1, 0, 0, '2021-01-26', '1', 'servings'),
(405, 1329, '24687453488', 'Milk', 123, 10, 5, 8, '2021-01-26', '1', 'cups'),
(386, 1329, '24677449693', 'Milk', 62, 5, 2, 4, '2021-01-25', '0', 'cups'),
(387, 1329, '24679839121', 'Espresso', 7, 1, 0, 0, '2021-01-25', '1', 'servings'),
(388, 1329, '24680969695', 'Whipped Cream', 20, 1, 1, 0, '2021-01-25', '2', 'tbsp'),
(366, 1329, '24659941398', 'Whipped Cream', 10, 0, 0, 0, '2021-01-24', '1', 'tbsp'),
(365, 1329, '24661141132', 'Milk', 123, 10, 5, 8, '2021-01-24', '1', 'cups'),
(357, 1329, '24542658098', 'English Muffin, Original', 135, 26, 1, 5, '2021-01-15', '1', 'muffins'),
(358, 1329, '24544104238', 'Cream Cheese', 34, 0, 3, 0, '2021-01-15', '1', 'tbsp'),
(348, 1329, '24507283016', 'Egg, Chicken, Fried', 92, 0, 7, 6, '2021-01-13', '1', 'larges'),
(349, 1329, '24508552762', 'Pinealpple, Raw', 27, 6, 0, 0, '2021-01-13', '2', 'oz'),
(350, 1329, '24506889232', 'Sausage', 150, 0, 14, 5, '2021-01-13', '1', 'servings'),
(354, 1329, '24506800656', 'Hash Browns', 125, 12, 8, 1, '2021-01-13', '1', 'oz'),
(351, 1329, '24507184825', 'Whipped Cream', 20, 1, 1, 0, '2021-01-13', '2', 'tbsp'),
(352, 1329, '24507391246', 'Danish Pastry, Raspberry', 263, 33, 13, 3, '2021-01-13', '1', 'pastries'),
(353, 1329, '24508257616', 'Cream Cheese, Lowfat', 46, 1, 3, 2, '2021-01-13', '2', 'tbsp'),
(355, 1329, '24504960262', 'Espresso', 7, 1, 0, 0, '2021-01-13', '1', 'servings'),
(356, 1329, '24507863708', 'Banana', 90, 21, 0, 1, '2021-01-13', '100', 'grams')
;

ALTER TABLE `FoodLog`
  ADD PRIMARY KEY (`id`,`studentID`,`logId`) USING BTREE,
  ADD UNIQUE KEY `logId` (`logId`);

ALTER TABLE `FoodLog`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=938;
  
SELECT * FROM FoodLog;

id	studentID	logId	foodName	calories	carbs	fat	protein	logDate	amount	unit
348	1329	24507283016	Egg, Chicken, Fried	92	0	7	6	2021-01-13	1	larges
349	1329	24508552762	Pinealpple, Raw	27	6	0	0	2021-01-13	2	oz
350	1329	24506889232	Sausage	150	0	14	5	2021-01-13	1	servings
351	1329	24507184825	Whipped Cream	20	1	1	0	2021-01-13	2	tbsp
352	1329	24507391246	Danish Pastry, Raspberry	263	33	13	3	2021-01-13	1	pastries
353	1329	24508257616	Cream Cheese, Lowfat	46	1	3	2	2021-01-13	2	tbsp
354	1329	24506800656	Hash Browns	125	12	8	1	2021-01-13	1	oz
355	1329	24504960262	Espresso	7	1	0	0	2021-01-13	1	servings
356	1329	24507863708	Banana	90	21	0	1	2021-01-13	100	grams
357	1329	24542658098	English Muffin, Original	135	26	1	5	2021-01-15	1	muffins
358	1329	24544104238	Cream Cheese	34	0	3	0	2021-01-15	1	tbsp
365	1329	24661141132	Milk	123	10	5	8	2021-01-24	1	cups
366	1329	24659941398	Whipped Cream	10	0	0	0	2021-01-24	1	tbsp
386	1329	24677449693	Milk	62	5	2	4	2021-01-25	0	cups
387	1329	24679839121	Espresso	7	1	0	0	2021-01-25	1	servings
388	1329	24680969695	Whipped Cream	20	1	1	0	2021-01-25	2	tbsp
405	1329	24687453488	Milk	123	10	5	8	2021-01-26	1	cups
406	1329	24686341139	Espresso	7	1	0	0	2021-01-26	1	servings
458	1329	24711222208	Milk	123	10	5	8	2021-01-27	1	cups
459	1329	24710848338	Espresso	7	1	0	0	2021-01-27	1	servings
460	1329	24711743529	Whipped Cream	10	0	0	0	2021-01-27	1	tbsp
477	1329	24728165665	Milk	123	10	5	8	2021-01-28	1	cups
493	1329	24734837038	Milk	123	10	5	8	2021-01-29	1	cups
494	1329	24742156649	Milk	62	5	2	4	2021-01-29	0	cups
495	1329	24743267907	Whipped Cream	10	0	0	0	2021-01-29	1	tbsp
503	1329	24751203105	Milk	123	10	5	8	2021-01-30	1	cups
504	1329	24749580620	Egg, Chicken, Fried	92	0	7	6	2021-01-30	1	larges
505	1329	24749678677	Sausage	150	0	14	5	2021-01-30	1	servings
514	1329	24758815161	Milk	123	10	5	8	2021-01-31	1	cups
515	1329	24758244329	Pineapple	34	8	0	0	2021-01-31	0	cups
516	1329	24758559433	Blueberries	21	5	0	0	2021-01-31	0	cups
538	1329	24776268371	Milk	123	10	5	8	2021-02-01	1	cups
539	1329	24775625962	Whipped Cream	10	0	0	0	2021-02-01	1	tbsp
540	1329	24776678847	Espresso	7	1	0	0	2021-02-01	1	servings
567	1329	24792463399	Milk	123	10	5	8	2021-02-02	1	cups
568	1329	24793322330	Espresso	7	1	0	0	2021-02-02	1	servings
569	1329	24794493486	Whipped Cream	10	0	0	0	2021-02-02	1	tbsp
570	1329	24790882300	Egg, Chicken, Fried	92	0	7	6	2021-02-02	1	larges
571	1329	24791304710	Bacon	119	0	10	4	2021-02-02	4	strips
572	1329	24791757624	Whipped Cream	10	0	0	0	2021-02-02	1	tbsp
573	1329	24791945218	Banana	121	28	0	1	2021-02-02	1	larges
574	1329	24791974280	Bagel, Plain Bagel	260	51	2	9	2021-02-02	1	bagels
575	1329	24792692553	Sausage	300	0	28	10	2021-02-02	2	servings
576	1329	24793805486	Pineapple	34	8	0	0	2021-02-02	0	cups
577	1329	24793893474	Strawberry / Strawberries	10	2	0	0	2021-02-02	2	larges
578	1329	24794060811	Milk	62	5	2	4	2021-02-02	0	cups

logDate
2021-01-24