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
Python, Lua and Tcl - public course schedule [here]
Private courses on your site - see [here]
Please ask about maintenance training for Perl, PHP, Java, C, C++, Ruby, MySQL and Linux / Tomcat systems
Copying a table structure

Posted by Eggie44 (Eggie44), 12 January 2004

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 2004
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 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 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., 2018: Well House Manor • 48 Spa Road • Melksham, Wiltshire • United Kingdom • SN12 7NY
PH: 01225 708225 • FAX: 01225 793803 • EMAIL: • WEB: • SKYPE: wellho