Archive for August, 2009

Running a case sensitive query in on a case insensitive table

Posted: 27th August 2009 by Darren Cassar in MySQL
Tags: , , , ,
8

A colleague at work asked me “how can I run a case sensitive select on a case insensitive table?” out of curiosity and for a moment I hesitated, then said, yeah why not :) ….

Securich – 0.1.4

Posted: 10th August 2009 by Darren Cassar in Beginner, MySQL
Tags: , , , , , , , , , , , ,
1

New Securich release – 0.1.4
* Added Password complexity
* Enhanced `set_password` – Old password is now necessary to replace it by a new one
* Enhanced Revoke privileges to accept regexp
* Added Block user@hostname on a database level
* Added Creation of reserved usernames

Once upon a timestamp(milliseconds)….

Posted: 6th August 2009 by Darren Cassar in Databases, Intermediate, MySQL, Uncategorized
Tags: , , ,
10

Once upon a time`stamp`, in a `data`base far far away, someone filed a bug named: `Microseconds precision is not retained by TIME, DATETIME, and TIMESTAMP field types.` – Bug Number 8523. This was the beginning of 2005, yet now that we are approaching the end of 2009, after 4.5 years, many (including myself) are still asking for this.