Apr 24, 2013
This stored sql procedure is used to replace a special character (or string) of your field with another string.
Oct 05, 2012
This is a very handy query that sorts your tables by their physical size in megabytes. Just be sure to edit the query to include the database name.
May 04, 2012
The below snippet will create a MySQL user and grant them all permissions on the given database. The % wildcard identifier will allow this particular user to be accessible via any hostname...
Apr 15, 2012
This is a very handy command to avoid running the same query twice. It will tell you how many total rows there are when you only need a handful. You need to run the second query immediately..
Mar 28, 2007
This is more of a note to myself, but I use it to dump databases where there are additional fields in the new table. When you're upgrading a database you can either add the new fields to..