From the imaginative minds of the science-fiction fans to your salad plate, you could soon be eating purple tomatoes! Yes, according to news from CNN.com, researchers in Salem, Oregon are perfecting the purple tomato, said to be the color of blueberries. Apparently, these are not genetically engineered, as there are genetic roots to a rare purple tomato in Southern Africa. Sources say these new veggies (yes, I know… they are technically fruit) could help reduce the risk of cancer and could be quite tasty in a Garden Salad. At the very least, it would add some color to your plate.

Purple Tomatoes [www.cnn.com]

I heard an interesting tidbit of information yesterday… did you know that virtually all calico cats are female? I was not aware of that, so I used the intarweb to research this. Of course, we all know that the internet is full of facts, it’s just a matter of finding them. My intense 30 second search unearthed the following site:  www.PetPlace.com.

The site briefly discusses the genetic makeup of calicos. From the site:

For the sex chromosomes, there is a battle for power. This is especially true for the X chromosome. If two X chromosomes are present, which determines female sex, one X chromosome will become inactivated at some point in fetal development. When this happens, all the cells descended from the activated X chromosome will have the same characteristics, including coat color.

So, there you have it - a drop of knowledge to broaden your horizon.

Yesterday, I continued my journey into the joy that is MySQL. I grew up, career-wise, in the house of SQL Server, so I am familiar with SQL and all that. However, when it comes to SQL skills, I don’t have the “mad” skills… just the “know enough to be officially dangerous” type of skills.

Anyway, I wanted to share with you one of my goals of yesterday. I needed to join two tables, getting values from the second table, if they existed, and also combining columns together in order to create a new column. Of course, I used a left join to achieve the joining goal, but I had issues when it came to concatenating field values together. I kept receiving NULLs for my new column value. This was due to there being NULL values being pulled from the second table durin the join.

So, I stumbled upon the COALESCE keyword in MySQL.  There may be something similar to this in SQL Server, but I am not aware of it at this time.  COALESCE  detects when a specified field value is NULL and then replaces it with  the given value in the parameter. This was useful for me when attempting to concatenate  string values to create a new column value.

So my sample code looks like this:

SELECT CONCAT(P.pname, ‘-’, COALESCE(C.cname,”)) AS NewColumn1, CONCAT(p.id, ‘-’, COALESCE(C.id,”)) AS NewColumn2
FROM Table1 as P
LEFT JOIN Table2 as C ON P.id = C.Name

Of course, many of you will have more complex uses for such a function, but for someone getting the feet wet with a different technology, I thought this was useful. Let me know if you know of any other useful functions within MySQL.

Find more information here: http://dev.mysql.com/doc/refman/5.0/en/comparison-operators.html