SQLite Forum

FEATURE REQUEST: use of DEFAULT in INSERTs
Login
I agree with you.
I see it less about changing my mind, more about having another option.

Using the word DEFAULT would allow me to specify the column for the insert, but choosing the default value from the table definition.

Mention col and a value -> use it

Mention col and DEFAULT OR
not Mentioning col
-> use the default from the CREATE TABLE definition

It helps to write bigger INSERTS, instead of several INSERTS.

In the example it seems silly, but that's due to its simplicity.

Thank you very much!