Dear Oláh,
> "SELECT * INTO [temptablename] FROM [sourcetablename] WHERE id is
null"
In MySQL, you simply do:
CREATE TABLE temptable SELECT * FROM sourcetable LIMIT 0
That's even simpler, 100% reliable and FAST! :)
HTH!
--
Stefan Hinz <[EMAIL PROTECTED]>
Geschäftsführer / CEO iConnect GmbH
Oláh,
Thursday, December 05, 2002, 2:44:24 PM, you wrote:
OB> I want to copy one table's structure to another (non existing) table, but i
OB> didn't find any command or example to do that. Exactly, the situation is the
OB> following:
OB> A dynamic database structure has tables. We want to copy any
On 5 Dec 2002, at 14:44, Ol h Barnab s wrote:
> "SELECT * INTO [temptablename] FROM [sourcetablename] WHERE id is null"
>
> and the SQL server creates a [temptablename] table with no records (or we
> hope that ;) )
> But we can't do this on MySQL server, 'cause MySQL isn't know the
> "SELECT...INT
