Re: CREATE TABLE LIKE, error
| From: | CPT John W. Holmes | Date: | Mon, 15 Dec 2003 17:13:36 +0000 |
| Subject: | Re: CREATE TABLE LIKE, error | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-32056@lists.php.net to get a copy of this message | ||
From: "Gary Every" <Gary.Every@ingramentertainment.com>
> Try:
> CREATE table new_table SELECT * from old_table limit 1;
>
> delete from new_table;
>
> This will give you the same structure in both tables, and the
> deletion will make the new_table empty.
Not quite the same as it will not copy indexes/keys...
---John Holmes...