ahhh...
thanks.
good to know.
- philip
On May 28, 2005, at 8:57 PM, Paul DuBois wrote:
At 20:50 -0500 5/28/05, Philip George wrote:
ya, i just meant when you go to the main table of contents page for
the docs:
http://dev.mysql.com/doc/mysql/en/index.html
... there's no mention of it.
there's SHOW CREATE PROCEDURE and SHOW CREATE FUNCTION and SHOW
CREATE VIEW, but no SHOW CREATE TABLE.
It appears "deeper" in the TOC than the other statements. The main
page
TOC goes only to three levels. (Otherwise it'd be a mile long.)
- philip
On May 28, 2005, at 8:38 PM, Paul DuBois wrote:
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]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
