Re: create or rename table or database

[Nick Roper]

You can create a new table based on an existing table wiyj:

CREATE TABLE newtable
SELECT * FROM oldtable;

However, this will also include the data. To create the new table without the data, use a WHERE clause that returns no rows, e.g:

CREATE TABLE newtable
SELECT * FROM oldtable
WHERE 0;

You can use mysqldump and mysqlimport to replicate a database

Nck


--
Nick Roper