Training, Open Source computer languages
PerlPHPPythonMySQLApache / TomcatTclRubyJavaC and C++LinuxCSS 
Search for:
Home Accessibility Courses Diary The Mouth Forum Resources Site Map About Us Contact
Copying a table structure

Posted by Eggie44 (Eggie44), 12 January 2004
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

Posted by Eggie44 (Eggie44), 12 January 2004
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

Posted by admin (Graham Ellis), 13 January 2004
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



This page is a thread posted to the opentalk forum at www.opentalk.org.uk and archived here for reference. To jump to the archive index please follow this link.

You can Add a comment or ranking to this page

© WELL HOUSE CONSULTANTS LTD., 2014: Well House Manor • 48 Spa Road • Melksham, Wiltshire • United Kingdom • SN12 7NY
PH: 01144 1225 708225 • FAX: 01144 1225 899360 • EMAIL: info@wellho.net • WEB: http://www.wellho.net • SKYPE: wellho