python将数据导入数据库 atomic_Python3 连接 Sqlite3

import sqlite3

从指定位置连接Sqlite3，用原始字符r‘’来省略转义符\

conn = sqlite3.connect(r'D:\Sqlite3\mydb\foods.db')

python2 用str，python3用bytes

设置python使用什么类型来处理sqlite3的text类型。

默认是unicode，所以才会产生 OperationalError: Could not decode to UTF-8 column 'name' with xxx 这个错误

因为从数据库中取出数据时，是gbk编码(因为你上次存进去的是gbk)

conn.text_factory的默认值是unicode，python会尝试将text类型的字段转换成unicode，就产生了错误

conn.text_factory = bytes

print('Opend successfully')

返回的是sqlite3的Cursor类型的结果

cursor = conn.execute('''select * from foods limit 10''')

遍历Cursor游标结果

for raw in cursor:

for i in range(len(raw)):

print(i,'is',raw[i],sep=' ')

print()

关闭数据库连接

conn.close()

--------------------------------以下是建表sql，方便测试---------------------------

PRAGMA foreign_keys=OFF;

BEGIN TRANSACTION;

CREATE TABLE foods(

id integer primary key,

type_id integer,

name text );

INSERT INTO foods VALUES(1,1,'Bagels');

INSERT INTO foods VALUES(2,1,'Bagels, raisin');

INSERT INTO foods VALUES(3,1,'Bavarian Cream Pie');

INSERT INTO foods VALUES(4,1,'Bear Claws');

INSERT INTO foods VALUES(5,1,'Black and White cookies');

INSERT INTO foods VALUES(6,1,'Bread (with nuts)');

INSERT INTO foods VALUES(7,1,'Butterfingers');

INSERT INTO foods VALUES(8,1,'Carrot Cake');

INSERT INTO foods VALUES(9,1,'Chips Ahoy Cookies');

INSERT INTO foods VALUES(10,1,'Chocolate Bobka');

INSERT INTO foods VALUES(11,1,'Chocolate Eclairs');

INSERT INTO foods VALUES(12,1,'Chocolate Cream Pie');

INSERT INTO foods VALUES(13,1,'Cinnamon Bobka');

INSERT INTO foods VALUES(14,1,'Cinnamon Swirls');

INSERT INTO foods VALUES(15,1,'Cookie');

INSERT INTO foods VALUES(16,1,'Crackers');

INSERT INTO foods VALUES(17,1,'Cupcake');

INSERT INTO foods VALUES(18,1,'Cupcakes');

INSERT INTO foods VALUES(19,1,'Devils Food Cake');

INSERT INTO foods VALUES(20,1,'Dinky Donuts');

INSERT INTO foods VALUES(21,1,'Dog biscuits');

INSERT INTO foods VALUES(22,1,'Donuts');

INSERT INTO foods VALUES(23,1,'Drakes Coffee Cakes');

INSERT INTO foods VALUES(24,1,'Entenmann''s Cake');

INSERT INTO foods VALUES(25,1,'Kaiser Rolls');

INSERT INTO foods VALUES(26,1,'Marble Ryes');

INSERT INTO foods VALUES(27,1,'Mini Ritz');

INSERT INTO foods VALUES(28,1,'Muffin');

INSERT INTO foods VALUES(29,1,'Muffin Tops');

INSERT INTO foods VALUES(30,1,'Muffin Stumps');

INSERT INTO foods VALUES(31,1,'Nut Bread');

INSERT INTO foods VALUES(32,1,'Pastries (of the Gods)');

INSERT INTO foods VALUES(33,1,'Peach Muffin');

INSERT INTO foods VALUES(34,1,'Peppridge Farms Cookies (Milanos)');

INSERT INTO foods VALUES(35,1,'Pizza Bagels');

INSERT INTO foods VALUES(36,1,'Pie');

INSERT INTO foods VALUES(37,1,'Pie (blueberry)');

INSERT INTO foods VALUES(38,1,'Pie (Blackberry) Pie');

INSERT INTO foods VALUES(39,1,'Pie (Boysenberry)');

INSERT INTO foods VALUES(40,1,'Pie (Huckleberry)');

INSERT INTO foods VALUES(41,1,'Pie (Raspberry)');

INSERT INTO foods VALUES(42,1,'Pie (Strawberry)');

INSERT INTO foods VALUES(43,1,'Pie (Cranberry)');

INSERT INTO foods VALUES(44,1,'Pie (Peach)');

INSERT INTO foods VALUES(45,1,'Poppy Seed Muffins');

INSERT INTO foods VALUES(46,1,'Triscuits');

INSERT INTO foods VALUES(47,1,'Wedding Cake (Royal)');

INSERT INTO foods VALUES(48,2,'Bran');

INSERT INTO foods VALUES(49,2,'Cheerios');

INSERT INTO foods VALUES(50,2,'Corn Flakes');

INSERT INTO foods VALUES(51,2,'Double Crunch');

INSERT INTO foods VALUES(52,2,'Fruit Loops');

INSERT INTO foods VALUES(53,2,'Grape Nuts');

INSERT INTO foods VALUES(54,2,'Honey Combs');

INSERT INTO foods VALUES(55,2,'Kasha');

INSERT INTO foods VALUES(56,2,'Kix');

INSERT INTO foods VALUES(57,2,'Life');

INSERT INTO foods VALUES(58,2,'Pancakes');

INSERT INTO foods VALUES(59,2,'Reese''s Peanut-Butter Puffs');

INSERT INTO foods VALUES(60,2,'Rice Krispies');

INSERT INTO foods VALUES(61,2,'Special K');

INSERT INTO foods VALUES(62,2,'Tightly Wrapped Magic Pan Crepes');

INSERT INTO foods VALUES(63,3,'Broiled Chicken');

INSERT INTO foods VALUES(64,3,'Casserole');

INSERT INTO foods VALUES(65,3,'Chicken');

INSERT INTO foods VALUES(66,3,'Chicken (for wedding)');

INSERT INTO foods VALUES(67,3,'Chicken Cashew (not ordered)');

INSERT INTO foods VALUES(68,3,'Chicken Kiev');

INSERT INTO foods VALUES(69,3,'Kung-Pao Chicken');

INSERT INTO foods VALUES(70,3,'Chicken Marsala');

INSERT INTO foods VALUES(71,3,'Chicken Piccata');

INSERT INTO foods VALUES(72,3,'Chicken with Poppy Seeds');

INSERT INTO foods VALUES(73,3,'Chicken, whole stuffed w/Gorganzolla and Ham');

INSERT INTO foods VALUES(74,3,'Chicken Skins');

INSERT INTO foods VALUES(75,3,'Chicken Wing (Shoulder Blades)');

INSERT INTO foods VALUES(76,3,'Chicken (Kenny Rogers) ');

INSERT INTO foods VALUES(77,3,'Chicken (Tyler) ');

INSERT INTO foods VALUES(78,3,'Colonel Chang Chicken');

INSERT INTO foods VALUES(79,3,'Cornish Game Hen');

INSERT INTO foods VALUES(80,3,'Duck');

INSERT INTO foods VALUES(81,3,'Duck, juicy breasts of');

INSERT INTO foods VALUES(82,3,'Turkey');

INSERT INTO foods VALUES(83,3,'Turkey, Kramer');

INSERT INTO foods VALUES(84,3,'Turkey Jerky');

INSERT INTO foods VALUES(85,3,'Turkey Chili');

INSERT INTO foods VALUES(86,4,'A1 Sauce');

INSERT INTO foods VALUES(87,4,'Barbeque Sauce');

INSERT INTO foods VALUES(88,4,'Dijon Mustard');

INSERT INTO foods VALUES(89,4,'Dill');

INSERT INTO foods VALUES(90,4,'Ginger');

INSERT INTO foods VALUES(91,4,'Gravy');

INSERT INTO foods VALUES(92,4,'Honey Mustard');

INSERT INTO foods VALUES(93,4,'Ketchup and Mustard together');

INSERT INTO foods VALUES(94,4,'Ketchup');

INSERT INTO foods VALUES(95,4,'Ketchup (secret)');

INSERT INTO foods VALUES(96,4,'Maple Syrup');

INSERT INTO foods VALUES(97,4,'Mustard (fancy)');

INSERT INTO foods VALUES(98,4,'Parsley');

INSERT INTO foods VALUES(99,4,'Pepper');

INSERT INTO foods VALUES(100,4,'Pesto');

INSERT INTO foods VALUES(101,4,'Salad Dressing');

INSERT INTO foods VALUES(102,4,'Salsa');

INSERT INTO foods VALUES(103,4,'Tarragon');

INSERT INTO foods VALUES(104,4,'Tomatoe Sauce');

INSERT INTO foods VALUES(105,4,'Tomatoe Sauce (Hot and Spicey)');

INSERT INTO foods VALUES(106,4,'Oregano');

INSERT INTO foods VALUES(107,4,'Parmisan');

INSERT INTO foods VALUES(108,5,'Banana Yogurt');

INSERT INTO foods VALUES(109,5,'Butter');

INSERT INTO foods VALUES(110,5,'Danon Blueberry Yogurt');

INSERT INTO foods VALUES(111,5,'Egg Beaters Omelette with cottage cheese');

INSERT INTO foods VALUES(112,5,'Egg White Omelette');

INSERT INTO foods VALUES(113,5,'Eggs for breakfast');

INSERT INTO foods VALUES(114,5,'Eggs');

INSERT INTO foods VALUES(115,5,'Egg Rolls');

INSERT INTO foods VALUES(116,5,'Egg Salad');

INSERT INTO foods VALUES(117,5,'Fete Cheese Omelette');

INSERT INTO foods VALUES(118,5,'French Toast');

INSERT INTO foods VALUES(119,5,'Large Block of Cheese');

INSERT INTO foods VALUES(120,5,'Scambled Eggs with Lobster');

INSERT INTO foods VALUES(121,5,'Soft Boiled Egg');

INSERT INTO foods VALUES(122,5,'Swiss Cheese');

INSERT INTO foods VALUES(123,5,'Quiche thing');

INSERT INTO foods VALUES(124,5,'Western Omelette');

INSERT INTO foods VALUES(125,6,'Generic (as a meal)');

INSERT INTO foods VALUES(126,6,'Good Dip');

INSERT INTO foods VALUES(127,6,'Guacamole Dip');

INSERT INTO foods VALUES(128,6,'Hummus');

INSERT INTO foods VALUES(129,7,'Apple Cider');

INSERT INTO foods VALUES(130,7,'Arabian Mocha Java (beans)');

INSERT INTO foods VALUES(131,7,'Beaujolais');

INSERT INTO foods VALUES(132,7,'Beer');

INSERT INTO foods VALUES(133,7,'Bosco');

INSERT INTO foods VALUES(134,7,'Cafe Latte');

INSERT INTO foods VALUES(135,7,'Champagne Coolies');

INSERT INTO foods VALUES(136,7,'Chardonnay');

INSERT INTO foods VALUES(137,7,'Cider');

INSERT INTO foods VALUES(138,7,'Club Soda');

INSERT INTO foods VALUES(139,7,'Coca Cola');

INSERT INTO foods VALUES(140,7,'Cocoa');

INSERT INTO foods VALUES(141,7,'Coffe');

INSERT INTO foods VALUES(142,7,'Colt 45');

INSERT INTO foods VALUES(143,7,'Cream Soda');

INSERT INTO foods VALUES(144,7,'Cranberry juice with two limes');

INSERT INTO foods VALUES(145,7,'Decaf Coffee');

INSERT INTO foods VALUES(146,7,'Decaf Cappaccino');

INSERT INTO foods VALUES(147,7,'Dr. Pepper (diet)');

INSERT INTO foods VALUES(148,7,'Duty Free Kalua');

INSERT INTO foods VALUES(149,7,'Folger''s Crystals');

INSERT INTO foods VALUES(150,7,'Gatorade');

INSERT INTO foods VALUES(151,7,'Grape Juice');

INSERT INTO foods VALUES(152,7,'Morning Thunder (with caffine)');

INSERT INTO foods VALUES(153,7,'Hennigen''s');

INSERT INTO foods VALUES(154,7,'Hershey''s');

INSERT INTO foods VALUES(155,7,'Hot Coffee');

INSERT INTO foods VALUES(156,7,'Juice box');

INSERT INTO foods VALUES(157,7,'Latte');

INSERT INTO foods VALUES(158,7,'Mellow Yellow soda');

INSERT INTO foods VALUES(159,7,'Merlot');

INSERT INTO foods VALUES(160,7,'Milk');

INSERT INTO foods VALUES(161,7,'Milkshake');

INSERT INTO foods VALUES(162,7,'Molotov Cocktail');

INSERT INTO foods VALUES(163,7,'Morning Thunder (with caffein)');

INSERT INTO foods VALUES(164,7,'Naya Water');

INSERT INTO foods VALUES(165,7,'Nestle''s Quick');

INSERT INTO foods VALUES(166,7,'Orange Juice');

INSERT INTO foods VALUES(167,7,'Ovaltine');

INSERT INTO foods VALUES(168,7,'Peach Schnapps');

INSERT INTO foods VALUES(169,7,'Pepsi');

INSERT INTO foods VALUES(170,7,'Pertussin with Club Soda');

INSERT INTO foods VALUES(171,7,'Postum');

INSERT INTO foods VALUES(172,7,'Prune Juice');

INSERT INTO foods VALUES(173,7,'Royal Crown Cola');

INSERT INTO foods VALUES(174,7,'Sanka');

INSERT INTO foods VALUES(175,7,'Scotch');

INSERT INTO foods VALUES(176,7,'Seltzer');

INSERT INTO foods VALUES(177,7,'Snapple');

INSERT INTO foods VALUES(178,7,'Sour milk out of the carton');

INSERT INTO foods VALUES(179,7,'Tea');

INSERT INTO foods VALUES(180,7,'Tomato Juice');

INSERT INTO foods VALUES(181,7,'Tropicana Orange Juice');

INSERT INTO foods VALUES(182,7,'Vodka');

INSERT INTO foods VALUES(183,7,'Vodka and Cranberry Juice');

INSERT INTO foods VALUES(184,7,'Water, bottled');

INSERT INTO foods VALUES(185,7,'Wild Turkey');

INSERT INTO foods VALUES(186,7,'Wine, boxed');

INSERT INTO foods VALUES(187,7,'Wine');

INSERT INTO foods VALUES(188,7,'Yoo Hoo');

INSERT INTO foods VALUES(189,8,'Apple');

INSERT INTO foods VALUES(190,8,'Apple Pie');

INSERT INTO foods VALUES(191,8,'Avacado');

INSERT INTO foods VALUES(192,8,'Banana');

INSERT INTO foods VALUES(193,8,'Canned Fruit');

INSERT INTO foods VALUES(194,8,'Cantaloupe');

INSERT INTO foods VALUES(195,8,'Grape');

INSERT INTO foods VALUES(196,8,'Grapefruit');

INSERT INTO foods VALUES(197,8,'Hamptons Tomatoes');

INSERT INTO foods VALUES(198,8,'Macinaw peaches');

INSERT INTO foods VALUES(199,8,'Mangos');

INSERT INTO foods VALUES(200,8,'Melons');

INSERT INTO foods VALUES(201,8,'Nectarine');

INSERT INTO foods VALUES(202,8,'Oranges');

INSERT INTO foods VALUES(203,8,'Papaya');

INSERT INTO foods VALUES(204,8,'Peaches');

INSERT INTO foods VALUES(205,8,'Pineapple');

INSERT INTO foods VALUES(206,8,'Plantains');

INSERT INTO foods VALUES(207,8,'Plumbs');

INSERT INTO foods VALUES(208,8,'Prunes, Figs, any Dried Fruit');

INSERT INTO foods VALUES(209,8,'Raisins');

INSERT INTO foods VALUES(210,8,'Shredded Coconut');

INSERT INTO foods VALUES(211,8,'Strawberries with Chocolate Sauce');

INSERT INTO foods VALUES(212,9,'Almond Joy');

INSERT INTO foods VALUES(213,9,'All Day Sucker');

INSERT INTO foods VALUES(214,9,'Big Hunk');

INSERT INTO foods VALUES(215,9,'Black Jacks - black licorice gum');

INSERT INTO foods VALUES(216,9,'Bubble Gum');

INSERT INTO foods VALUES(217,9,'Candy Apple');

INSERT INTO foods VALUES(218,9,'Cashew Nuts');

INSERT INTO foods VALUES(219,9,'Cashews (bag of)');

INSERT INTO foods VALUES(220,9,'Clark Bar');

INSERT INTO foods VALUES(221,9,'Chinese Chewing Gum');

INSERT INTO foods VALUES(222,9,'Chocolates, box of');

INSERT INTO foods VALUES(223,9,'Chocolate Chip Mint');

INSERT INTO foods VALUES(224,9,'Chocolate Covered Cherries');

INSERT INTO foods VALUES(225,9,'Chuckles (5 flavors)');

INSERT INTO foods VALUES(226,9,'Chunky Bar');

INSERT INTO foods VALUES(227,9,'Cracker Jacks');

INSERT INTO foods VALUES(228,9,'Cupcakes (upsidedown)');

INSERT INTO foods VALUES(229,9,'Dentyne');

INSERT INTO foods VALUES(230,9,'Double Crunch Ice Cream');

INSERT INTO foods VALUES(231,9,'Double Fudge Sundae');

INSERT INTO foods VALUES(232,9,'Doublemint Gum');

INSERT INTO foods VALUES(233,9,'Frozen Yogurt');

INSERT INTO foods VALUES(234,9,'Godiva Chocolates');

INSERT INTO foods VALUES(235,9,'Gum');

INSERT INTO foods VALUES(236,9,'Jucyfruit Gum');

INSERT INTO foods VALUES(237,9,'Haagen Dazs');

INSERT INTO foods VALUES(238,9,'Hot Fudge Sundae');

INSERT INTO foods VALUES(239,9,'Ice Cream');

INSERT INTO foods VALUES(240,9,'Ice Cream (Breyer''s vanilla)');

INSERT INTO foods VALUES(241,9,'Ice Cream Triple Minute Man');

INSERT INTO foods VALUES(242,9,'Ice Cream Rum and Raisin');

INSERT INTO foods VALUES(243,9,'Jello with Bananas');

INSERT INTO foods VALUES(244,9,'JujyFruit');

INSERT INTO foods VALUES(245,9,'Junior Mints');

INSERT INTO foods VALUES(246,9,'Klondike Bars');

INSERT INTO foods VALUES(247,9,'M and M''s');

INSERT INTO foods VALUES(248,9,'Macadamia Nuts');

INSERT INTO foods VALUES(249,9,'Mints');

INSERT INTO foods VALUES(250,9,'Mr. Goodbar');

INSERT INTO foods VALUES(251,9,'Nutrageous');

INSERT INTO foods VALUES(252,9,'Nuts, Filbert and Hazel');

INSERT INTO foods VALUES(253,9,'Oh Henry Bar');

INSERT INTO foods VALUES(254,9,'Peanut Butter');

INSERT INTO foods VALUES(255,9,'Peanuts');

INSERT INTO foods VALUES(256,9,'Pecan');

INSERT INTO foods VALUES(257,9,'Pez');

INSERT INTO foods VALUES(258,9,'Pineapple Italian Ice');

INSERT INTO foods VALUES(259,9,'Popcorn');

INSERT INTO foods VALUES(260,9,'Pretzels (unsalted)');

INSERT INTO foods VALUES(261,9,'Pretzels (salted)');

INSERT INTO foods VALUES(262,9,'Pudding Skins');

INSERT INTO foods VALUES(263,9,'Ring Dings');

INSERT INTO foods VALUES(264,9,'Rold Gold Pretzles');

INSERT INTO foods VALUES(265,9,'Snackwells');

INSERT INTO foods VALUES(266,9,'Snickers');

INSERT INTO foods VALUES(267,9,'Three Musketeers');

INSERT INTO foods VALUES(268,9,'Tic Tacs');

INSERT INTO foods VALUES(269,9,'Tootsie Pop');

INSERT INTO foods VALUES(270,9,'Twinkies');

INSERT INTO foods VALUES(271,9,'Twix Bar');

INSERT INTO foods VALUES(272,9,'Wheat Thins (reduced fat)');

INSERT INTO foods VALUES(273,10,'Arby''s Roast Beef');

INSERT INTO foods VALUES(274,10,'Bacon');

INSERT INTO foods VALUES(275,10,'Beef-A-Reeno');

INSERT INTO foods VALUES(276,10,'Brisket');

INSERT INTO foods VALUES(277,10,'Chili');

INSERT INTO foods VALUES(278,10,'Cold-cuts');

INSERT INTO foods VALUES(279,10,'Dog Food');

INSERT INTO foods VALUES(280,10,'Five Alarm Chili');

INSERT INTO foods VALUES(281,10,'Franks and Beans');

INSERT INTO foods VALUES(282,10,'Gyro');

INSERT INTO foods VALUES(283,10,'Hamburger (Meduim)');

INSERT INTO foods VALUES(284,10,'Hamburger (Skyburger)');

INSERT INTO foods VALUES(285,10,'Hamburger');

INSERT INTO foods VALUES(286,10,'Hash');

INSERT INTO foods VALUES(287,10,'Sausages (homemade)');

INSERT INTO foods VALUES(288,10,'Hot Dog');

INSERT INTO foods VALUES(289,10,'Hot Dog (Papaya King)');

INSERT INTO foods VALUES(290,10,'Hot Dog (Nathan''s)');

INSERT INTO foods VALUES(291,10,'Hot Dog (phone)');

INSERT INTO foods VALUES(292,10,'Lamb Chops');

INSERT INTO foods VALUES(293,10,'Meat Loaf');

INSERT INTO foods VALUES(294,10,'Meatball Sandwich');

INSERT INTO foods VALUES(295,10,'Mutton');

INSERT INTO foods VALUES(296,10,'Pastrami');

INSERT INTO foods VALUES(297,10,'Corned Beef');

INSERT INTO foods VALUES(298,10,'Salami');

INSERT INTO foods VALUES(299,10,'Bologna');

INSERT INTO foods VALUES(300,10,'Pork Chops');

INSERT INTO foods VALUES(301,10,'Porterhouse Steak');

INSERT INTO foods VALUES(302,10,'Red Meat');

INSERT INTO foods VALUES(303,10,'Salted Cured Meats');

INSERT INTO foods VALUES(304,10,'Steak');

INSERT INTO foods VALUES(305,10,'Stuffed Cabbage');

INSERT INTO foods VALUES(306,10,'Steak (T-Bone)');

INSERT INTO foods VALUES(307,10,'Tamale');

INSERT INTO foods VALUES(308,10,'Steak (US Prime)');

INSERT INTO foods VALUES(309,11,'Calzone (Paisano''s)');

INSERT INTO foods VALUES(310,11,'Canolli');

INSERT INTO foods VALUES(311,11,'Chow Fung (noodle)');

INSERT INTO foods VALUES(312,11,'Macaroni');

INSERT INTO foods VALUES(313,11,'Fusilli');

INSERT INTO foods VALUES(314,11,'Paella');

INSERT INTO foods VALUES(315,11,'Pasta Primavera');

INSERT INTO foods VALUES(316,11,'Pasta at Chadways');

INSERT INTO foods VALUES(317,11,'Pizza');

INSERT INTO foods VALUES(318,11,'Pizza (Paccino''s)');

INSERT INTO foods VALUES(319,11,'Raviolli');

INSERT INTO foods VALUES(320,11,'Rigatoni');

INSERT INTO foods VALUES(321,11,'Rissoto');

INSERT INTO foods VALUES(322,11,'Spaghetti');

INSERT INTO foods VALUES(323,11,'Tamales');

INSERT INTO foods VALUES(324,11,'Vegetable Lasagna');

INSERT INTO foods VALUES(325,12,'Atomic Sub');

INSERT INTO foods VALUES(326,12,'Bologna');

INSERT INTO foods VALUES(327,12,'Bacon Club (no turkey)');

INSERT INTO foods VALUES(328,12,'BLT');

INSERT INTO foods VALUES(329,12,'Brisket Sandwich');

INSERT INTO foods VALUES(330,12,'Chicken Salad on Rye');

INSERT INTO foods VALUES(331,12,'Cold Chicken');

INSERT INTO foods VALUES(332,12,'Egg Salad');

INSERT INTO foods VALUES(333,12,'Grilled Cheese');

INSERT INTO foods VALUES(334,12,'Ham and Cheese');

INSERT INTO foods VALUES(335,12,'Hero Sandwich');

INSERT INTO foods VALUES(336,12,'Little sandwiches');

INSERT INTO foods VALUES(337,12,'Ostrich Burger');

INSERT INTO foods VALUES(338,12,'Pastrami Sandwich');

INSERT INTO foods VALUES(339,12,'Peanut Butter');

INSERT INTO foods VALUES(340,12,'Reuben');

INSERT INTO foods VALUES(341,12,'Salami Sandwich');

INSERT INTO foods VALUES(342,12,'Salmon');

INSERT INTO foods VALUES(343,12,'Tuna');

INSERT INTO foods VALUES(344,12,'Tuna on toast');

INSERT INTO foods VALUES(345,12,'Turkey Club');

INSERT INTO foods VALUES(346,12,'Turkey Roll');

INSERT INTO foods VALUES(347,12,'Turkey Sandwich');

INSERT INTO foods VALUES(348,13,'Clams Casino');

INSERT INTO foods VALUES(349,13,'Crab Legs');

INSERT INTO foods VALUES(350,13,'Flounder Supreme - #47');

INSERT INTO foods VALUES(351,13,'Halibut');

INSERT INTO foods VALUES(352,13,'Lobster');

INSERT INTO foods VALUES(353,13,'Lobster on Monk''s menu');

INSERT INTO foods VALUES(354,13,'Lobster Shells');

INSERT INTO foods VALUES(355,13,'Salmon');

INSERT INTO foods VALUES(356,13,'Sardines');

INSERT INTO foods VALUES(357,13,'Shrimp');

INSERT INTO foods VALUES(358,13,'Sole');

INSERT INTO foods VALUES(359,13,'Swordfish');

INSERT INTO foods VALUES(360,13,'Tuna Fishy');

INSERT INTO foods VALUES(361,13,'Whitefish');

INSERT INTO foods VALUES(362,14,'Bouillabaisse');

INSERT INTO foods VALUES(363,14,'Carrot Soup');

INSERT INTO foods VALUES(364,14,'Chicken Gumbo');

INSERT INTO foods VALUES(365,14,'Consomm?);

INSERT INTO foods VALUES(366,14,'Crab Bisque');

INSERT INTO foods VALUES(367,14,'Creamed Soups');

INSERT INTO foods VALUES(368,14,'Cuppa Soup');

INSERT INTO foods VALUES(369,14,'Deli Soup');

INSERT INTO foods VALUES(370,14,'Jambalaya');

INSERT INTO foods VALUES(371,14,'Lobster Bisque');

INSERT INTO foods VALUES(372,14,'Lima Bean Soup');

INSERT INTO foods VALUES(373,14,'Motzah Ball');

INSERT INTO foods VALUES(374,14,'Medium Turkey Chili');

INSERT INTO foods VALUES(375,14,'Mulligatawny soup');

INSERT INTO foods VALUES(376,14,'Mushroom Barley');

INSERT INTO foods VALUES(377,14,'Pea Soup');

INSERT INTO foods VALUES(378,14,'Tomatoe Soup');

INSERT INTO foods VALUES(379,14,'Wild Mushroom');

INSERT INTO foods VALUES(380,14,'Yankee Bean');

INSERT INTO foods VALUES(381,15,'Artichokes');

INSERT INTO foods VALUES(382,15,'Baked Beans');

INSERT INTO foods VALUES(383,15,'Baked Potato w/Sour Cream');

INSERT INTO foods VALUES(384,15,'Big Salad');

INSERT INTO foods VALUES(385,15,'Brocolli');

INSERT INTO foods VALUES(386,15,'Chef Salad');

INSERT INTO foods VALUES(387,15,'Carrots');

INSERT INTO foods VALUES(388,15,'Cole Slaw');

INSERT INTO foods VALUES(389,15,'Cucumber');

INSERT INTO foods VALUES(390,15,'Egg Plant');

INSERT INTO foods VALUES(391,15,'Foliage (edible)');

INSERT INTO foods VALUES(392,15,'French Fries');

INSERT INTO foods VALUES(393,15,'French Fried Onion Rings');

INSERT INTO foods VALUES(394,15,'Hampton Tomatoes');

INSERT INTO foods VALUES(395,15,'Insalata Grande');

INSERT INTO foods VALUES(396,15,'Kugel');

INSERT INTO foods VALUES(397,15,'Kreplach');

INSERT INTO foods VALUES(398,15,'Latkas');

INSERT INTO foods VALUES(399,15,'Lettuce (as a brain)');

INSERT INTO foods VALUES(400,15,'Olives');

INSERT INTO foods VALUES(401,15,'Onion');

INSERT INTO foods VALUES(402,15,'Peas');

INSERT INTO foods VALUES(403,15,'Pea Pods');

INSERT INTO foods VALUES(404,15,'Pickle');

INSERT INTO foods VALUES(405,15,'Potato Salad');

INSERT INTO foods VALUES(406,15,'Potatoes');

INSERT INTO foods VALUES(407,15,'Radish Roses');

INSERT INTO foods VALUES(408,15,'Roasted Potatoes');

INSERT INTO foods VALUES(409,15,'Salad');

INSERT INTO foods VALUES(410,15,'Tzimmis');

INSERT INTO foods VALUES(411,15,'Veggie burger');

INSERT INTO foods VALUES(412,15,'Wax Beans (Generic brand)');

COMMIT;