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
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
8 messages in com.mysql.lists.mysqlRe: RESOLVED : exporting table struct...