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:
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, bo no version
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
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 MySQL version?
It's in