Question

How to INSERT INTO with SELECT and default values

Hi friends, can't find related material online.

Question, I have a table with column a, b and c, a is a sequence and b is defaulted to be say 0.
I take column c from a SELECT clause.

How do I do this kind of things?

I tried:

INSERT INTO table
SELECT
default,
default,
c
FROM whatever

This doesn't work. Any idea? Thanks!

It seems that I cannot SELECT default. If I can't do that how am I supposed to INSERT into any table with less columns?

+1

Just specify the columns into which you actually want to insert something:

INSERT INTO the_table(
 c
)
SELECT
  c
FROM whatever;

@marcothesane said:
Just specify the columns into which you actually want to insert something:
INSERT INTO the_table(
 c
)
SELECT
  c
FROM whatever;

Thanks, it works! Perfect~~

Sign up