Cooking With SQL: Short And Sweet

June 22, 2010

Cooking With SQL: Short And Sweet

By Michael Marr

One of my fondest childhood memories revolves around my Grandmother's cooking. She was able to take out store bought hot dogs, boil them in a pot of water, and serve them up on piece of bread for many of my childhood lunches. Likewise, one my of fondest SQL memories is the first time I used conditional statements in my SQL to significantly shorten my overall code. Nothing better than hot dogs and SQL...

SQL conditional statements can be used anywhere to replace an IF/THEN or SWITCH statement you might otherwise use on the results of a SQL statement. However, an even bigger benefit comes from using conditional statements to handle the data from two adjoined tables to produce the output that otherwise would take a considerable amount of code to organize.

Let's say we have the main content of our site in table1, and a secondary table called table2. Table2 links to table1's content, and sometimes will use that content verbatim. If table2 data exists, however, it does not copy table1's values.

Continue Reading

Today's Top Videos:

How Accurate Are Search Results?

It's interesting how much weight we put on search results. Search is not only the primary method that we use...

Watch Video

How Caffeine Is Already Changing...

When people talk about the future of search, they often include factors such as mobile, social, real-time, and other...

Watch Video

Openness and Privacy: Finding the...

Can a person be both open and maintain his privacy? It's an interesting scenario and one that many people find themselves...

Watch Video

Recent Articles:

A Uniform Query To The Community

The language of SQL is a lot like the English language. You have North American and Great Britain dialects of the language, not to mention significantly varying degrees of those dialects broken down amongst the geographical regions in which they're spoken.

And so is the fate of the Structured Query Language. Although the base of the language remains somewhat intact, programming in Oracle, Microsoft SQL, PostgreSQL, or other SQL extensions when you're from a MySQL background becomes painfully difficult at times (or switch MySQL with any of the other languages and the same occurs). The line between proper SQL and the...

Read More...

Get a human. Host with The Planet.
Double Your Ram Free

Teradata Releases New Database Features

Todd Walters introduced the new release - 13.10. Not every feature is equally interesting to me but a couple were important to note: One of the key features in the new database release is the support for temporal tables. Default for a temporal...

Read More...

MySQL Incremental Backup

Best practices encourage SQL administrators to have a system in place to automatically and routinely backup their database. Let's take a look at a line of Joe Sysop's crontab file: 30 15 * * 3,5 mysqldump --user=user --password=pass...

This guide is designed to be used for Linux desktops and servers. For best results, use the same Linux version for the desktop as is installed on the server. To quote the authors: MySQL Workbench is a cross-platform, visual database design...

Read More...

Other iEntry Business Resources:

	WebProNews.com
	Jayde.com
	MarketingNewz.com

	SalesNewz.com
	CareerNewz.com
	InvestNewz.com

	eCommNewz.com
	WebsiteNotes.com
	AdvertisingDay.com