The latest from the MySQL community

Great news! Monty released Maria, the new transactional storage engine for MySQL. This is fantastic news! I can't wait to try it out. I remember when it was in the planning stage. Now it's here!

http://monty-says.blogspot.com/2008/01/maria-engine-is-released.html

First saw this off of Planet MySQL:

 New Vendor Neutral Database Certification (Dave's Stuff)

Following the link to the CIW site, there are six domains that are being tested:

1. Relational Database Fundamentals
2. Relational Database Design and Application
3. Normalization and Database Design
4. Structured Query Language (SQL)
   
5. Relational Algebra and Databases
6. Transactions, Concurrency Control and Security

I wonder how much traction this independent certification will get, given the flavors each of the various database platforms use of SQL and …

A friend asked for this, so I thought it’d be helpful: All tables with no primary key:

use INFORMATION_SCHEMA; select CONCAT(t.table_name,".",t.table_schema) as tbl, from TABLES AS t LEFT JOIN KEY_COLUMN_USAGE AS c ON (t.TABLE_NAME=c.TABLE_NAME AND c.CONSTRAINT_SCHEMA=t.TABLE_SCHEMA AND constraint_name='PRIMARY') WHERE t.table_schema!="information_schema" AND constraint_name IS NULL;

All tables and their primary keys, if exist:

use INFORMATION_SCHEMA; select CONCAT(t.table_name,".",t.table_schema) as tbl, c.column_name,c.constraint_name from TABLES AS t LEFT JOIN [...]

Lefred pointed us to O'Reilly Maker

This one really is my preferred one

It's sad, but so true.

This Nokia rant makes me wonder where the Mac version is.

Didn't Scott Adams already write this one ?

That's Wally right ? :)

And even the IT Crowd also has it's own manual already.

Dave wrote about new vendor neutral database certification, or as I like to call it "Jack-of-all-trades-but-master-of-none certification "

This post is mostly off topic, but I do no know there are quite a few runners in the open source world. We have a modest-sized running club at MySQL with many marathoners, and there's also guys like Marc Fleury, Matt Asay who have also run marathons. (The SugarCRM guys seem to be avid cyclists, and once in a while I ride with them in the hills around Cupertino, but for me it's not the same thrill as running a marathon. Call me weird.) At any rate, I went to see the movie "Spirit of the Marathon" the other night.... READ MORE

This is all my personal rant based on my little investigation as I have been very upset.

If you're the one who I am targeting this post to: please don't take it personally. You have no one but yourself to blame for this backlash.

==start rant==
So, Looking at the sites of one-who-shall-not-be-named-or-linked-to-any-more or aka wolf in sheep's clothing, I am coming to an opinion. To me, it seems like he is basically using his sites to benefit his current and/or future clients. He also seems to be a DMOZ editor or very closely associate with it, something that really hurts his credibility in my eyes. DMoz should be shredded by now as it has absolutely no value other than to lame SEOs who still either beg editors to get their site listed or enjoy being begged to. Even the parent company of DMoz has no interest in it. I mean come on. If you are 1% serious in your "database research" business you wouldn't spend time …

For those that worried about having to go to lulu.com to order copies of the Cluster certification study guide, I just noticed that the Amazons of the world now have the book listed:

Not only do they have them, they stock them too, so you can have immediate delivery.

If you’re not an Amazon customer, you will undoubtedly be able to find/order the book in other places as well.

So after my recent battle with "dirty" email addresses, I decided to find some validating functions to help people and myself in the future. Most of them use regular expressions.
So here they are:

MySQL stored function
Taken from - http://forge.mysql.com/snippets/view.php?id=62

DELIMITER $$
DROP FUNCTION IF EXISTS `test`.`is_valid_email` $$
CREATE DEFINER=`root`@`localhost` FUNCTION `is_valid_email`(p_email varchar(64)) RETURNS tinyint(1)
BEGIN
CASE
WHEN NOT (SELECT p_email REGEXP '^[A-Z0-9._%-]+@[A-Z0-9.-]+\.[A-Z]{2,4}$')
THEN
-- bad data
RETURN FALSE;
ELSE
-- good email
RETURN TRUE;
END CASE;
END $$
…

Hardly rocket science, but this annoyed me enough to jot it down in case it might be useful for others…

The MySQL manual page on INSERT syntax could perhaps be a little more thorough on how to write INSERTs with ON DUPLICATE KEY UPDATE. So here’s a slightly more thorough example of valid syntax than the one given in the manual.

In the example, the reports table’s Primary Key is (id, year)

INSERT INTO reports
SET id='9612', year='2007', net_income=123456, equity=12345, number_of_employees=123
ON DUPLICATE KEY UPDATE net_income=123456, equity=12345, number_of_employees=123


Notice in this syntax:

• I’m using SET colname=value syntax in the INSERT part of the statement. You don’t need to do this, but notice how the parts marked in blue are the exact same in both parts of the …