"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,
, December 15, 2003 10:28 AM
To: Lista PHP DB
Subject: [PHP-DB] CREATE TABLE LIKE, error
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 l
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, bo no version info
available.
--
Seks, seks
