Recipes food - SQL Database
Download a free SQL food recipe database.
A database of food recipes for creating a website on the topic of cooking around the world.
Example database structure
CREATE TABLE `recipes` ( `id` int(11) default NULL, `title` varchar(255) default NULL, `titlecat` varchar(255) default NULL, `recipe` longtext, `category` varchar(64) default NULL, `category2` varchar(255) default NULL, `category3` varchar(50) default NULL, `category4` varchar(50) default NULL, KEY `category` (`category`), KEY `category2` (`category2`) ) TYPE=MyISAM;
An example of a table with data.
'pastry wrapped raspberry chipotle baked brie', 'pastry wrapped raspberry chipotle baked brie recipe | brie recipes | appetizer recipes', '<h1>Pastry Wrapped Raspberry Chipotle Baked Brie</h1><p>Posted by Chyrel at recipegoldmine.com 5/4/02 8:09:30 pm</p><p>1 sheet frozen puff pastry, defrosted <br>6 tablespoons Epicurean\'s Delight Roasted Raspberry Chipotlй Sauce <br>1 small round brie <br>1 egg, beaten <br>3 tablespoons chopped nuts (walnuts, pecans, almonds)</p><p>Butter a baking pan and line with aluminum foil. Roll the pastry on a lightly floured surface and cut one 8-inch and one approximately 4-inch circle ( a little larger than the round of brie). Keep remaining dough.</p><p>Place 8-inch circle on baking pan and center brie on top of the dough. Top brie with raspberry sauce and nuts. Bring the dough up the sides of the cheese and press firmly so it will stay. Brush edges of dough with egg. Brush outer rim on the 4-inch dough circle with egg and place over the top of the cheese with the moistened side down. Press the two edges of the dough together firmly to seal.</p><p>Brush top and sides with egg. Cut decorative designs from dough scraps and place on top. Brush decorations with egg. Refrigerate 30 minutes (minimum) before baking.</p><p>Preheat oven to 375 degrees F. Bake for 20 to 30 minutes or until golden brown. Let stand 10 minutes before serving.</p><p>To serve, transfer baked brie to serving dish by carefully lifting the brie with the foil. Trim away excess foil.</p><p>Serves 6 to 8 as an appetizer.</p>', 'appetizers', 'brie', null, null);