8 messages in com.mysql.lists.mysqlRe: RESOLVED : exporting table struct...
FromSent OnAttachments
Philip George28 May 2005 18:19 
Paul DuBois28 May 2005 18:25 
Philip George28 May 2005 18:26 
Philip George28 May 2005 18:28 
Paul DuBois28 May 2005 18:38 
Philip George28 May 2005 18:49 
Paul DuBois28 May 2005 18:57 
Philip George28 May 2005 19:01 
Subject:Re: RESOLVED : exporting table structure/data in mysql?
From:Paul DuBois (pa@mysql.com)
Date:05/28/2005 06:38:02 PM
List:com.mysql.lists.mysql

At 20:26 -0500 5/28/05, Philip George wrote:

this is what i was looking for:

SHOW CREATE TABLE tablename;

for some reason it isn't on the main doc page.

- philip

http://dev.mysql.com/doc/mysql/en/show-create-table.html

On May 28, 2005, at 8:19 PM, Philip George wrote:

what's the sql syntax (in mysql) for exporting a table's structure and and data (the one that reiterates the original CREATE TABLE statement)?

..so that i'll end up with something that can be put in a .sql script for later imports if needed.

thanks.

- philip

-- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com