I had a situation where i have a table with huge lot of fields. i want to recreate this table with some other name. It would be very easy if i have any user interface like php myadmin or mysql work bench but since i am working on the server there is no UI. Therefore i was looking on the internet for a way to get the sql code for existing table, so that i can just recreate the table by just running a single command.
then i found this on My Sql Developer page
SHOW CREATE TABLE tableName
Here is the results
Now i just need to copy the existing code and change the name of the table to the name i want and then run the script. thats it.