ftsführer / CEO iConnect GmbH <http://iConnect.de>
Heesestr. 6, 12169 Berlin (Germany)
Tel: +49 30 7970948-0 Fax: +49 30 7970948-3
- Original Message -
From: "Oláh Barnabás" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, December 05, 2002 1:44 PM
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
Hello!
I want to copy one table's structure to another (non existing) table, but i
didn't find any command or example to do that. Exactly, the situation is the
following:
A dynamic database structure has tables. We want to copy any of tha tables
(while we don't know that table's structure) to anot
