faqts : Computers : Databases : MySQL : Common Problems : Unusual Queries

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

20 of 28 people (71%) answered Yes
Recently 6 of 10 people (60%) answered Yes

Entry

What is the syntax to an insert query with a select query inside ?

Mar 29th, 2001 05:32
Richard Mitchell, seb foucault, 


INSERT INTO t1 (col1,col2) SELECT c1,c2 FROM t2