I want to do this:

INSERT INTO Table2(column1,column2,column3)
SELECT column1,column2,'somecustomvalue'
FROM Table1 WHERE id IN(1,2,3);

Of course the above query is not proper - what I want is to put a custom
value for column3 but copy the rest from Table1. Is this possible like this
and in a single query?

I am actually looking for this for SQLite but mysql solution will do as
well.

forgot to mention - both tables have identical structure.

On 8/29/2011 12:36 PM, A wrote:
What error did you get when you tried to run the query exactly as you
typed it above (I don't see anything wrong with it)?

OMG... I gave myself a solution without even trying it... I assumed that
would never work it was too damn obvious.
Yes, you're right, it works and also works in SQLite too.... thanks
anonymous!