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
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...INTO
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 of
://iConnect.de
Heesestr. 6, 12169 Berlin (Germany)
Tel: +49 30 7970948-0 Fax: +49 30 7970948-3
- Original Message -
From: Olh Barnabs [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, December 05, 2002 1:44 PM
Subject: Table copy problem
Hello!
I want to copy one table's