title: mysql: Copy table structure including foreign keys
body: <p>I know how to copy a table using <code>create new_table like old_table</code>, but that does not copy over the foreign key constraints as well.  I can also do string manipulation on the result from <code>show create table old_table</code> (using regular expressions to replace the table name and the foreign key constraint names), but that seems error prone.  Is there a better way to copy the structure of a table, including the foreign keys?</p>