Another MySQL DBA

Here is a quick and simple way to generate a password your application using MySQL. This query will create a upper and lower case randomly...

Well it has been awhile since I posted, sorry about that. Today I was watching reruns of the TV show Fringe and when Walter referenced the ...

So I noticed a few different questions and posts about parsing a string out of another string recently. While some solutions included creat...

So this is just a simple example of how to set up a PARTITION and a SUBPARTITION in MySQL. The concept here is that you have data in a tabl...

Backup ... backup... Backup... but of course.. you also need to monitor and test those backups often otherwise they could be worthless.  Ha...