Hello,

Today I was trying to create a temporary table with the same structure as an existing table using the CREATE TEMPORARY TABLE...LIKE... syntax, and I couldn't have it work in spite of my having full privileges on the db.
Then I go to the online manual and in paragraph 10.2.3 CREATE TABLE SYNTAX there is nothing after the "or:" which tends to indicate there is no "LIKE" syntax anymore.
Right??

I use version 4.0.12-max-debug on Win98...

Eg

Hmmm  
I found a rather inelegant way to solve the problem :
CREATE TEMPORARY TABLE tmp_table_name SELECT * FROM old_table WHERE clause_that_returns_empty_set;
I'm not happy with the clause usage since it implies some knowledge of the table content.

Eg

I agree that it's inelegant, but you don't need any knowledge of the table content if you use a where clause such as WHERE 1 = 0

---