this is what i was looking for:
SHOW CREATE TABLE tablename;
for some reason it isn't on the main doc page.
- philip
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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
