Archive for the 'Database' Category

Sql Server is quite selecty!

I got this during chat completely unrelated to SQL Server.

Zebra Ultra says: i love microsoft’s sql server Zebra Ultra says: it is quite selecty zebra ultra

Yup, it’s one of those days.

MySQL Triggers: How do you abort an INSERT, UPDATE or DELETE with a trigger?

On EfNet’s #mysql someone asked:

How do I make a trigger abort the operation if my business rule fails?

In MySQL 5.0 and 5.1 you need to resort to some trickery to make a trigger fail and deliver a meaningful error message. The MySQL Stored Procedure FAQ says this about error handling:

SP [...]

Is MySQL the model 21st-century company?

MySQL: Workers in 25 countries with no HQ This open-source software maker has figured out how to manage a world-wide workforce that rarely meets. Is MySQL the model 21st-century company? http://money.cnn.com/

I posted this hastily yesterday, just a bit of tidying up today (2006-06-03).

Solving Soduku with T-SQL

Found this interesting article about solving Soduku with SQL and had to share it. I’d really like to see this implemented with MySQL Stored Procedures and Functions for a good compare/contrast. If you do it, let me know.

Using FireFox Keyword Searches for MySQL Documentation

I answer questions on IRC every day… most questions can be answered by searching the manual. I personally search the manual about 5-10 times per day. I’d suggest that every MySQL users create a FireFox keyword search for the manual an save themselves some trouble.

Navigate to http://dev.mysql.com/doc/ and choose [...]