New Table based on Old Table design

[Anon]

OK. I've got a table for a product catalog with a jillion items in it. Now I'd like to create another product catalog for a seperate product line (different country) with the exact same layout. Is there an easy way to create a new table based on the fields in the old table without bringing in all of the exsiting products??

[dstockto]

The easiest way is to do a "DESC table" or something similar on your table. Then just do a new create table with the same field names and types.

Dave

[Anon]

Hi Mark,
If you are using MySQL you can use this query to create a new table but, this will also copy the data(You can delete the simply by executing .... delete from .....isn't it?)

$qry="create table $newtablename select * from $sourcetablename";

Cheers
Ajay