MYSQL: Creating a table with same columns on remote machine I am trying to create a table on my local machine which has the same description as some other table on a remote machine. I just want to create the table with same columns, don't worry about the row data.

The table has around 150 columns, so its very tedious to write the CREATE TABLE command. Is there an elegant way of doing this?
On Remote Machine :


Open command prompt
Log in to mysql :   mysql -uusername -p -h 
fire : show create table TABLE_NAME
copy whole 
exit

On local machine's command prompt, type : 


mysql -uusername -p 

paste there and press enter