May 19, 2003
Hawkee.com Admin

mySQL Code Snippets

Hawkee created a Page  -  Oct 05, 2012
3 936 

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.

Hawkee created a Page  -  Apr 15, 2012
2 220 

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.

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.