RE: Indicating an INDEX during TEMPORARY table creation

2004-08-11 Thread Victor Pendleton
during TEMPORARY table creation When executing: CREATE TEMPORARY TABLE temp_1 AS SELECT * FROM table_name Is it possible to indicate an index within the syntax of this statement - as opposed to issuing an ALTER TABLE command after the table is created? Thanks in advance for any help

Indicating an INDEX during TEMPORARY table creation

2004-08-11 Thread David Perron
When executing: CREATE TEMPORARY TABLE temp_1 AS SELECT * FROM table_name Is it possible to indicate an index within the syntax of this statement - as opposed to issuing an ALTER TABLE command after the table is created? Thanks in advance for any help. -- MySQL General Mailing List For