Latest mySQL Code Snippets

Popular / Snippets

mortl92 created a Page  -  Apr 24, 2013
1 208 

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 for more details about the usage.

Hawkee created a Page  -  Oct 05, 2012
3 884 

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.

sean created a Page  -  May 04, 2012
1 276 

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. While the * wildcard will grant the user access to all tables within the supplied database. You can change either to match your specific needs.

Hawkee created a Page  -  Apr 15, 2012
2 214 

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 following the first. If you leave out SQL_CALC_FOUND_ROWS from the first query FOUND_ROWS() will simply return the number or results you got, 10 in this case.

alabama created a Page  -  Oct 13, 2011

Saw someone make something similar to this, but this is all the chrs in 1 dialog

Hawkee created a Page  -  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 the old table or move the data from an older table to a newer one.

Are you sure you want to unfollow this person?
Are you sure you want to delete this?
Click "Unsubscribe" to stop receiving notices pertaining to this post.
Click "Subscribe" to resume notices pertaining to this post.