Another MySQL DBA

I thought I posted this long ago... oh well.... We all know that math is the fundamental aspect of all life and the common language used ...

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...