Re: Get MySQL table schema for a dump
| From: | Paul Burney | Date: | Thu, 27 Feb 2003 02:15:00 +0000 |
| Subject: | Re: Get MySQL table schema for a dump | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-25941@lists.php.net to get a copy of this message | ||
on 2/26/03 6:23 PM, Jonathan Villa at jvilla@isdesigndev.com appended the
following bits to my mbox:
> but what I'm missing is
>
> CREATE table blah, blah, blah
Here you go:
SHOW CREATE TABLE $tablename;
HTH.
Sincerely,
Paul Burney
<http://paulburney.com/>
Q: Tired of creating admin interfaces to your MySQL web applications?
A: Use MySTRI instead. Version 3.1 now available.
<http://mystri.sourceforge.net/>