SQL Nuts and Bolts (Part 3)

We’ll be progressing from simply selecting records from a database to actually changing the data that resides in it. In this installment, we’ll add data with SQL’s insert statement.

The insert statement is a very straightforward one, and you’ll be surprised on how easy it is to add records to a database. Here is a simplistic example of what the code looks like:

INSERT INTO table_name (column_name1, column_name2, column_name3, column_name4)
VALUES ('value_1','value_2','value_3','value_4')

The first of the two lines needed begins with the insert into clause, proceeded by the name of the table, then in parenthesis all the columns you wish to insert data into. The second line starts with the term value followed by the individual records that are to be inserted into the table. The specific records are enclosed in single quotation marks, separated by commas, and the entire group lays inside parenthesis…

Blair and Zakk WyldeTeam Up For Berserker Brand Hot Sauces

Berserker Brand Label - Blair's and Zakk Wylde Join Forces For Berserker Brand Hot Sauces

Hot off the press from Blair Lazar:

“Dear ChiliPal,

So many things have been going on in Death Sauce Land over the last few months. So much in fact that I could not explain everything in just one e-Mail. Over the next couple of weeks I will be sending out several additional messages covering many exciting topics.

Today I want to announce that Blair’s and Zakk Wylde have…

Review: Ott’s Original Wing Sauce

Ott's Wing Sauce in the pre-2008 bottleHow many hot sauces have you tried that have become an instant staple in your house, where you absolutely had to have a bottle on hand at all times and became as commonplace in your kitchen as ketchup and white bread? My “must-have” in the hot sauce world is Ott’s Wing Sauce.

I first became addicted to Ott’s sometime in the mid-1990s when St. Louis area Denny’s restaurants used Ott’s on their Buffalo Chicken Strips. I tasted them and knew I had to get my grubby little paws on the sauce. After a bit of research my wife and I found the answer, and a bottle of it has been in our kitchen ever since.

Sadly, our local Denny’s ditched Ott’s a few years ago in favor of a runnier, redder, and weaker buffalo sauce on their chicken breast strips. It’s a shame that more scraggly 2:00 am diner-goers who ordered the Buffalo Chicken Strips wouldn’t be able to experience what I consider the best mild-to-medium buffalo sauce in the world…

Blair’s New Pure Death Sauce

A new sauce has just been made available on the Blair’s Website: Pure Death. No, it’s not one to top the 750,000 SHU threshold of Jersey Death. Blair promises this one to be around the same as level as After Death, which measures just shy of the 50,000 mark (still pretty darned hot). Unlike a lot of liquid super scorchers on the market, Pure Death contains no extract, and gets it’s heat from the pods of bhut jolokia and orange habanero peppers…

Growing Bhut Jolokias – Step Two – Planting the Seeds

In my last article about growing bhut jolokia peppers, I briefly described the seeds and my experience eating a pepper flake. Now we get to the good part – planting the seeds!

Starting Indoors

Like a good bulk of the United States, my home state of Missouri has a climate that won’t allow for the outdoor starting of hot pepper plants. The good news is that with the right indoor conditions it’s easy to have your pepper seeds germinate and sprout up into nice little seedlings. What are those conditions, you might ask?

Keep Your Plants Warm

First, make sure you’re able to keep your peppers in a place that is able to get plenty of heat. It can be…

The Beatles Featuring David Lee Roth

You’ve got to hand it to the guys who think up these things and then construct them. Here’s a nicely edited audio/video mashup featuring The Beatles and David Lee Roth performing “Drive My Car” and “Runnin’ With the Devil”:

In case you were wondering, the Beatles footage was taken from their 1968 “Revolution” video, and Van Halen’s from their “Runnin’ With the Devil” clip produced ten years later. Audio was the naked David Lee Roth studio vocal track of “Runnin'” (that surfaced some time last year) inserted into the Fab Four’s classic hit from Rubber Soul.

Scotty’s Gut-Pleasing Spicy BBQ Sauce Recipe

Scotty's BBQ Sauce RecipeRecipe time! If you’re looking for a good, sweet, dark, and rich barbecue sauce to slather on your grilled steaks, chops, ribs, and chicken, give this one a try next weekend:

1 (8 oz.) Can Tomato Sauce
1/2 Cup Chopped Onions
2 Tbsp Brown Sugar
1 Serrano Chile Pepper or Jalapeńo Peppers (Take Your Pick), Finely Diced
1 1/4 Cup Ketchup
2 Tbsp Prepared Yellow Mustard
1 Tbsp Worcestershire Sauce
1 Tbsp Olive Oil
1 Dash Garlic Powder
1 Dash Tabasco Habanero Sauce
1 Cup Water or Beer (Take Your Pick)

Combine all ingredients in a medium saucepan, cover and simmer for 45-60 minutes. The sauce will reduce and slightly thicken the longer it cooks. If you like spicy sauces, use a serrano pepper instead of the jalapeńo. If you prefer it milder, substitute regular Tabasco Sauce or Frank’s Hot Sauce for the hotter Tabasco Habanero Sauce. In my opinion, it tastes similar to Bull’s-Eye Original Barbecue Sauce with an extra added “kick” from the peppers and the beer. Apply it to meat and you’ll have BBQ heaven!

Garfield Comic Spoofs

GarfieldHave you always loved the antics of Garfield, the lasagna-loving cat? Yeah, me neither. Here are a few links that poke fun at the ridiculously unfunny comic:

Remove that wisecracking orange feline from every frame of the comic strip and you get Garfield Minus Garfield. It’s amusing to see Garfield’s owner, Jon Arbuckle, turn into a lonely, depressed, schizophrenic man who has conversations with thin air.

Realfield borrows from that last idea and pushes it further by replacing Garfield with a real, non-talking cat. Jon is even more psychopathically sad in this one.

My favorite is…