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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
