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 [...]
Archive for the 'MySQL' Category
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:
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).
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.