RE: [PHP-DB] CREATE TABLE LIKE, error
| From: | Gary Every | Date: | Mon, 15 Dec 2003 16:43:15 +0000 |
| Subject: | RE: [PHP-DB] CREATE TABLE LIKE, error | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-32054@lists.php.net to get a copy of this message | ||
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:agquarx@venus.ci.uw.edu.pl]
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