sqlite insert with default values for default fields

Question

The docs specify two alternatives: insert values or insert default values (https://www.sqlite.org/lang_insert.html)

The trouble is if one for example has a table:

create table address_book values(
 rowid integer primary key, 
 first_name, 
 last_name, 
 address, 
 phone_number, 
 email, notes, 
 country TEXT DEFAULT 'USA'
 )

One can no longer write insert into values(?, ?, ?, ?, ?, ?) since it expects rowid and country to be specified. Is there a shortcut for specifying insert into values with default values populating the default fields? Or is impossible without explicitly naming all the non-default fields?

Larry Lustig · Accepted Answer · 2014-12-05 20:57:15Z

1

Yes, it is impossible. In any event it is good practice to explicitly name the columns you are INSERTing into anyway -- leaving the columns out leads to more fragile code and more "silent failure" possibilities in which you're not inserting data into the column you think you are inserting it into.

answered Dec 5, 2014 at 20:57

Larry Lustig

51.2k16 gold badges119 silver badges173 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

sqlite insert with default values for default fields

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related