From: "Gary Every" <[EMAIL PROTECTED]>

> 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...

PHP Database Mailing List (
To unsubscribe, visit:

Reply via email to