At 20:19 -0500 5/28/05, 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.
SHOW CREATE TABLE tbl_name
From the command line:
mysqldump --no-data db_name [tbl_name] ...
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]