How to INSERT INTO with SELECT and default values
markus_zhang
Community Edition User ✭
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!
0
Answers
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?
Just specify the columns into which you actually want to insert something:
Thanks, it works! Perfect~~