asked on 9/3/2013

phpmyadmin

Is there a way t build a new table in phpmyadmin from an existing table making the table structure identical?

I need a table like that where I will add one new column, but all the rest is identical.

Thanks

MySQL Server

Last Comment

Dave Baldwin

9/3/2013

dsacker

9/3/2013

Use a query statement like this:

SELECT TOP 0 *
INTO MyNewTable
FROM MyOldTable

Open in new window

After you do that, then you can add your one new column at whatever point is applicable.

ALTER TABLE MyNewTable
ADD MyNewField varchar(50)

Open in new window

Or whatever size and type you really want.

Richard Korts

9/3/2013

ASKER

It fails & gives this message (whick I think is a catchall):

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '0 * INTO ttask FROM cl_task LIMIT 0, 30' at line 1

The EXACT query I used is:

SELECT TOP 0 *
INTO ttask
FROM cl_task

ttask does not exist; do I have to create an empty table first?

ASKER CERTIFIED SOLUTION

dsacker

9/3/2013

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

Dave Baldwin

9/3/2013

In phpMyAdmin, select your database and table. One of the tabs across the top is 'Operations'. Click on that and one of the functions on that page is 'Copy table to ...' with several options.