Re: Cloning a table

[Paul DuBois]

At 11:53 AM -0400 6/14/1999, Adam Sherman wrote:
>Is there any way to reverse engineer a table and generate the sql
>statements needed to recreated it?

mysqldump db_name tbl_name

If you only want the CREATE TABLE statement, and not the data, use:

mysqldump -d db_name tbl_name



mysqldump --help for more information.

--
Paul DuBois, paul@stripped
Northern League Chronicles: http://www.snake.net/nl/