Copying a table structure
Posted by Eggie44 (Eggie44), 12 January 2004Hello,
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.
I use version 4.0.12-max-debug on Win98...
Posted by Eggie44 (Eggie44), 12 January 2004Hmmm
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.
Posted by admin (Graham Ellis), 13 January 2004I 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
PH: 01144 1225 708225 • FAX: 01144 1225 899360 • EMAIL: email@example.com • WEB: http://www.wellho.net • SKYPE: wellho