faqts : Computers : Databases : MySQL : Language and Syntax : Table Types

+ Search
Add Entry AlertManage Folder Edit Entry Add page to http://del.icio.us/
Did You Find This Entry Useful?

27 of 33 people (82%) answered Yes
Recently 8 of 10 people (80%) answered Yes

Entry

How can I copy rows from a temporary table into a real table?

May 18th, 2000 20:43
Nathan Wallace, Tim Smith


This one's easy:
    insert into real_table (col1, col2) select x, y from temp_table;