Archive for the 'Databases' Category



Before continuing to read, please note that there is a Part II to this post which addresses a performance issue in the following approach. However, please do continue reading because Part II assumes you have read this entire post and only makes minor changes to the code herein…
I have seen a couple of approaches to […]

MySQL 5.0

A number of new features have been added to MySQL 5.0 and I have been trying them out. Among the new features are Stored Procedures, Triggers and Views. These are features that have been around in so-called corporate databases like Oracle and DB2 (and PostgreSQL also) for years. Yesterday I added a trigger to a […]