Yes, just i need to make it from code, and from a windows machine, so i cant use shell() or something like that... So i need to upgrade...
Vaso -----Original Message----- From: Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: 2002. január 30. 19:31 To: Vasoczki Ferenc; '[EMAIL PROTECTED]' Subject: Re: Structure copy... At 17:29 +0100 1/30/02, Vasoczki Ferenc wrote: >Hi, i want to copy a table structure. >I saw on the archive, there is a syntax like: >create [newtable] select * from [sourcetable] where 1=2; > >This is not work on my MySQL server v.3.22 >Is it a 3.23 feature, or am i do something wrong ? It's a 3.23 feature. > >If you know the solution please tell me that. >Thx > >Vaso You may be able to use the output from mysqldump --no-data db_name tbl_name, which will produce the CREATE TABLE statement for the table. Do a substitution to change the name in the statement, then execute it. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
