Archive for the 'MySQL' Category

Perl Regex Tip: Zero-width positive look-aheads are non-capturing.

I used to write regexes all the live long day in a language called WebQL. During that time I must’ve written somewhere between 5000-10000 lines of regular expressions to extract data from various data feeds the crawlers would pull down every day. It’s all fun and games until an angry customer calls wondering [...]

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.