"CPT John W. Holmes" wrote:
> From: "Adam i Agnieszka Gasiorowski FNORD" <[EMAIL PROTECTED]>
>
> > I cannot use this query
> >
> > CREATE TABLE table LIKE other_table;
> >
> > , which is supposed to create an
> > empty "clone" of the other_table named
> > table.
> > Was it added in some later
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...
From: "Adam i Agnieszka Gasiorowski FNORD" <[EMAIL PROTECTED]>
> I cannot use this query
>
> CREATE TABLE table LIKE other_table;
>
> , which is supposed to create an
> empty "clone" of the other_table named
> table.
> Was it added in some later MySQL version?
> It's in the manual on mysql.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.
-Original Message-
From: Adam i Agnieszka Gasiorowski FNORD [mailto:[EMAIL PROTECTED]
Sent: Monday,