MXimize by Carlos Gallupa, thoughts about and experiments with coldfusion, css, sql, components and javascript

Insert with a select

Sometimes you need to update a table from another table and what you can do then is SELECT all data.. loop over it with CF en INSERT the data into the other table....OR.... you can let the database sort it out.

INSERT INTO table1 (column1,column2,column3....)
SELECT column1,
    column2,
    'somevalue' AS column3,
    ....
FROM table2

5412 viewed | 2 opinion(s)  | del.icio.us | Digg it | Tjarko @ 02/06/05 14:59 cet