INSERT tablename (value1, value2)
SELECT value1, value2
FROM someothertable
WHERE somewhereclause
I often forget this syntax. It of course inserts the row or rows returned by the select into the table given on the insert line.
Wednesday, February 28, 2007
Subscribe to:
Post Comments (Atom)
1 comment:
Boy, this sure is a short post. You criticized me for the same- why would that be?
Post a Comment