Solved

phpmyadmin

Posted on 2011-09-02
4
327 Views
Last Modified: 2012-05-12
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?
0
Comment
Question by:Richard Korts
  • 2
4 Comments
 
LVL 30

Expert Comment

by:Marco Gasi
Comment Utility
I would  click on Export tab, uncheck Data checkbox and click Execute button: that's all
0
 
LVL 30

Expert Comment

by:Marco Gasi
Comment Utility
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
0
 
LVL 108

Accepted Solution

by:
Ray Paseur earned 500 total points
Comment Utility
I think the action you want is something along the lines of CREATE TABLE LIKE myTable.
http://forums.mysql.com/read.php?97,23324,26293
http://dev.mysql.com/doc/refman/5.1/en/create-table.html
0
 

Author Closing Comment

by:Richard Korts
Comment Utility
Perfect!
0

Featured Post

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Generating table dynamically is the most common issue faced by php developers.... So it seems there is a need of an article that explains the basic concept of generating tables dynamically. It just requires a basic knowledge of html and little maths…
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.
The viewer will learn how to create a basic form using some HTML5 and PHP for later processing. Set up your basic HTML file. Open your form tag and set the method and action attributes.: (CODE) Set up your first few inputs one for the name and …

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now