<div>
I would &nbsp;click on Export tab, uncheck Data checkbox and click Execute button: that's all
</div>


I would  click on Export tab, uncheck Data checkbox and click Execute button: that's all

<div>
Oh, yes: then you can copy and past the code, edit it as you need to change the table name, save it on your hard drive and then reimport it through Import tab of PhpMyAdmin. You can also past the edited code in SQL tab and click execute.<br />
Cheers
</div>


Oh, yes: then you can copy and past the code, edit it as you need to change the table name, save it on your hard drive and then reimport it through Import tab of PhpMyAdmin. You can also past the edited code in SQL tab and click execute.
Cheers

<div>
<div class="content wysiwyg-content">
I have an existing table in a database that has about 35 columns. I want to build another (empty) table with the EXACT same structure (no rows populated).<br />
<br />
Is there a way to do this in phpmyadmin?<br />
<br />
My thought is to export the structure only, edit the exported .sql file to change the name &amp;&nbsp;import it.<br />
<br />
Is there an easier way?
</div>
</div>


I have an existing table in a database that has about 35 columns. I want to build another (empty) table with the EXACT same structure (no rows populated).

Is there a way to do this in phpmyadmin?

My thought is to export the structure only, edit the exported .sql file to change the name & import it.

Is there an easier way?

phpmyadmin

PHP is a widely-used server-side scripting language especially suited for web development, powering tens of millions of sites from Facebook to personal WordPress blogs. PHP is often paired with the MySQL relational database, but includes support for most other mainstream databases. By utilizing different Server APIs, PHP can work on many different web servers as a server-side scripting language.

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.