How to INSERT INTO with SELECT and default values

markus_zhangmarkus_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!

Answers

  • markus_zhangmarkus_zhang Community Edition User

    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?

  • marcothesanemarcothesane - Select Field - Administrator

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

    INSERT INTO the_table(
     c
    )
    SELECT
      c
    FROM whatever;
    
  • markus_zhangmarkus_zhang Community Edition User

    @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~~

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file