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, 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
        Was it added in some later MySQL version?
 It's in the manual on, bo no version info

Seks, seksić, seksolatki... news:pl.soc.seks.moderowana  { iWanToDie }   WiNoNa    )   (  foReVeR(  *  )
Poznaj jej zwiewne kształty... 007

PHP Database Mailing List (
To unsubscribe, visit:

PHP Database Mailing List (
To unsubscribe, visit:

Reply via email to