Category Archives: Database

The time has come to upgrade to MySQL 5

We’ve finally hit the point at work where we’re ready to upgrade from MySQL 4.0 to 5. Data integrity has been a problem since I started at this job. Part of the reason is that MySQL 4.0 has an odd … Continue reading

Posted in Database, Software Engineering, Systems Administration | Leave a comment

MySQL and not null is not good!

On a daily basis I continue to be unimpressed with MySQL when using MyISAM tables. Today I discovered that if you set a field to be non-nullable and then do an insert without specifying the field, MySQL happily completes the … Continue reading

Posted in Database | 2 Comments