Coderguy’s Blog

Here is a handy query I found the mysql reference manual for how to see all the foreign keys in a database:

SELECT ke.referenced_table_name parent, ke.table_name child, ke.constraint_name
FROM information_schema.KEY_COLUMN_USAGE ke
WHERE ke.referenced_table_name IS NOT NULL
ORDER BY ke.referenced_table_name;

Read the rest of this entry »

Here is nifty little tip.  If you need to have your command line MySQL autocomplete enabled or refresh the just type \# at the command line.
mysql>\#
This is great for those times when you creating a lot of tables.

Read the rest of this entry »