Re: How to clone an existing table structure?

[Dan Nelson]

In the last episode (Nov 13), indrek siitan said:
> Hi,
> 
> > me@foo> mysqldump --no-data mydb peopletable \
> >         | sed -e "/CREATE TABLE /s/peopletable/newpeople/" \
> >         | mysql mydb
> 
> CREATE TABLE newpeople SELECT * FROM peopletable;

.. and if you only want to copy table structure, and no data:

  CREATE TABLE newpeople SELECT * FROM peopletable WHERE 1=0

You'll have to recreate indexes manually.

-- 
	Dan Nelson
	dnelson@stripped