Jonathan,
You can use "Describe TABLENAME" as a query and then use that information
to built you create statements.
Eric
Eric Girard
Varsity Crew Team
Computer Science major,
Management Information Systems minor,
Worcester Polytechnic Institute Class of '03
-----Original Message-----
From: Jonathan Villa [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 26, 2003 6:36 PM
To: [EMAIL PROTECTED]
Subject: RE: [PHP-DB] Re: Get MySQL table schema for a dump
Sorry, I should have explained that I want to do this via PHP.
---> Jonathan
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
Of Fredrik de Vibe
Sent: Wednesday, February 26, 2003 5:31 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Re: Get MySQL table schema for a dump
[EMAIL PROTECTED] (Jonathan Villa) writes:
> Is there was to get a database's table schema?
I don't think it's called schemas in mysql, but I'm not sure :-)
> So far, I have a simple function which will output
> INSERT INTO table (x,x,x,) VALUES(x,x,x);
> [ ... ]
> but what I'm missing is
> CREATE table blah, blah, blah
mysqldump is the tool you need.
e.g.
$ mysqldump -u user [-p] Database > db_dump_file.sql
man mysqldump for more info.
--
--Fredrik
If God is dead, who will save the Queen?
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
