I'd like to insert into a table several pairs of values where the first
value does not change. Rather than numerous INSERT statements, I think
there should be a way to insert from a select with immediate values, but I
just can't figure it out. What I'd like:
INSERT INTO mytable
SELECT 1, *
FROM (1,2,3,4)
...which would result in inserting the pairs
1,1
1,2
1,3
1,4
Is there some clean way of doing this, or do I really need multiple
INSERTs?
--Greg