mySQL Code Snippets

SQL: replace a string with another string

This stored sql procedure is used to replace a special character (or string) of your field with another string. See:http://wiki.coolorange.com/index.php?title=documentAnalyzer/5._Migration_PSP_to_Vault/Tips_&_Tricks..

Tables sorted by size in Megabytes

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.

Create User with all Permissions

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

Find the Total number or rows with a Limit

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

mySQLdump Complete Insert

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