Entry

How can I copy a table or table structure?

Can I use mysqldump to print out table definitions?

Jan 23rd, 2000 22:10
Nathan Wallace, James Treworgy, Sinisa Milivojevic

The shell command:

    mysqldump -d -p -u root db_name

will dump out the table definitions/create statements.  More information
is available here:

    http://www.mysql.com/Manual_chapter/manual_Tools.html#mysqldump

You could also try one of these SQL commands:

    CREATE from SELECT is available since 3.23.0.

    INSERT from SELECT is available since 3.22.0.

    SELECT INTO OUTFILE is available since 3.21.xx.