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, 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 later MySQL version? It's in the manual on mysql.com, bo no version info available. -- Seks, seksić, seksolatki... news:pl.soc.seks.moderowana http://hyperreal.info { iWanToDie } WiNoNa ) ( http://szatanowskie-ladacznice.0-700.pl foReVeR( * ) Poznaj jej zwiewne kształty... http://www.opera.com 007 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
