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;

©著作权归作者所有,转载或内容合作请联系作者
  • 人面猴
    序言：七十年代末，一起剥皮案震惊了整个滨河市，随后出现的几起案子，更是在滨河造成了极大的恐慌，老刑警刘岩，带你破解...
    沈念sama阅读 204,590评论 6赞 478
  • 死咒
    序言：滨河连续发生了三起死亡事件，死亡现场离奇诡异，居然都是意外死亡，警方通过查阅死者的电脑和手机，发现死者居然都...
    沈念sama阅读 86,808评论 2赞 381
  • 救了他两次的神仙让他今天三更去死
    文/潘晓璐 我一进店门，熙熙楼的掌柜王于贵愁眉苦脸地迎上来，“玉大人，你说我怎么就摊上这事。” “怎么了？”我有些...
    开封第一讲书人阅读 151,151评论 0赞 337
  • 道士缉凶录：失踪的卖姜人
    文/不坏的土叔 我叫张陵，是天一观的道长。 经常有香客问我，道长，这世上最难降的妖魔是什么？ 我笑而不...
    开封第一讲书人阅读 54,779评论 1赞 277
  • 港岛之恋（遗憾婚礼）
    正文 为了忘掉前任，我火速办了婚礼，结果婚礼上，老公的妹妹穿的比我还像新娘。我一直安慰自己，他们只是感情好，可当我...
    茶点故事阅读 63,773评论 5赞 367
  • 恶毒庶女顶嫁案：这布局不是一般人想出来的
    文/花漫 我一把揭开白布。 她就那样静静地躺着，像睡着了一般。 火红的嫁衣衬着肌肤如雪。 梳的纹丝不乱的头发上，一...
    开封第一讲书人阅读 48,656评论 1赞 281
  • 城市分裂传说
    那天，我揣着相机与录音，去河边找鬼。 笑死，一个胖子当着我的面吹牛，可吹牛的内容都是我干的。 我是一名探鬼主播，决...
    沈念sama阅读 38,022评论 3赞 398
  • 双鸳鸯连环套：你想象不到人心有多黑
    文/苍兰香墨 我猛地睁开眼，长吁一口气：“原来是场噩梦啊……” “哼！你这毒妇竟也来了？” 一声冷哼从身侧响起，我...
    开封第一讲书人阅读 36,678评论 0赞 258
  • 万荣杀人案实录
    序言：老挝万荣一对情侣失踪，失踪者是张志新（化名）和其女友刘颖，没想到半个月后，有当地人在树林里发现了一具尸体，经...
    沈念sama阅读 41,038评论 1赞 299
  • 护林员之死
    正文 独居荒郊野岭守林人离奇死亡，尸身上长有42处带血的脓包…… 初始之章·张勋 以下内容为张勋视角 年9月15日...
    茶点故事阅读 35,659评论 2赞 321
  • 白月光启示录
    正文 我和宋清朗相恋三年，在试婚纱的时候发现自己被绿了。 大学时的朋友给我发了我未婚夫和他白月光在一起吃饭的照片。...
    茶点故事阅读 37,756评论 1赞 330
  • 活死人
    序言：一个原本活蹦乱跳的男人离奇死亡，死状恐怖，灵堂内的尸体忽然破棺而出，到底是诈尸还是另有隐情，我是刑警宁泽，带...
    沈念sama阅读 33,411评论 4赞 321
  • 日本核电站爆炸内幕
    正文 年R本政府宣布，位于F岛的核电站，受9级特大地震影响，放射性物质发生泄漏。R本人自食恶果不足惜，却给世界环境...
    茶点故事阅读 39,005评论 3赞 307
  • 男人毒药：我在死后第九天来索命
    文/蒙蒙 一、第九天 我趴在偏房一处隐蔽的房顶上张望。 院中可真热闹，春花似锦、人声如沸。这庄子的主人今日做“春日...
    开封第一讲书人阅读 29,973评论 0赞 19
  • 一桩弑父案，背后竟有这般阴谋
    文/苍兰香墨 我抬头看了看天上的太阳。三九已至，却和暖如春，着一层夹袄步出监牢的瞬间，已是汗流浃背。 一阵脚步声响...
    开封第一讲书人阅读 31,203评论 1赞 260
  • 情欲美人皮
    我被黑心中介骗来泰国打工， 没想到刚下飞机就差点儿被人妖公主榨干…… 1. 我叫王不留，地道东北人。 一个月前我还...
    沈念sama阅读 45,053评论 2赞 350
  • 代替公主和亲
    正文 我出身青楼，却偏偏与公主长得像，于是被迫代替她去往敌国和亲。 传闻我的和亲对象是个残疾皇子，可洞房花烛夜当晚...
    茶点故事阅读 42,495评论 2赞 343

推荐阅读更多精彩内容

  • rljs
    rljs by sennchi Timeline of History Part One The Cognitiv...
    sennchi阅读 7,285评论 0赞 10
  • iOS sqlite3数据库解析
    多个应用程序或者同一个应用程序的多个例程能同时存取同一个数据库文件吗？ 多进程可以同时打开同一个数据库，也可以同时...
    woshishui1243阅读 740评论 0赞 0
  • sqlite3 表连接
    表连接主要有以下内连接、外连接、交叉连接。 inner join(内连接) 只返回两个表中联结字段相等的行 lef...
    小何才鲁尖尖角阅读 2,177评论 0赞 0
  • python 连接sqlite3
    sqlite3 安装 及使用 Python 2.5.x以上版本默认自带了该模块。 使用 sqlite3 进入sql...
    ktide阅读 833评论 0赞 0
  • python连接sqlite3
    import sqlite3#查询def load(table):#连接数据库con = sqlite3.conn...
    Arsenic一觉到天亮阅读 316评论 0赞 0