How can we transpose a table using Sql?

Database engin is mysql

it depend on database engine for example if you use sql server you can user wizard to transpose table from database to another by right click on database --> Task ---> Export data

this provide to you transpose structure of table and it data.

but if you use native sql language you can generate table script and transfer to target database and run this script after change database name.

tell more about type of database engine(SQL Server or orcle or mysql or access or etc) and I will explaine the way to you