I have table on MySQL server and would like to get the SQL that would re-create the table.
How do I get the query to recreate the SQL table?
mysqldump can do it - http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html
You can use it like this:
mysqldump [databasename] [tablename] > mysqltablesql.sql