SQLite Forum

FEATURE REQUEST: use of DEFAULT in INSERTs
Login
Do you mean perhaps to define the table as follows:

```
CREATE TABLE t1 
(
    a    INTEGER NOT NULL ON CONFLICT REPLACE DEFAULT 1,
    b    INTEGER NOT NULL ON CONFLICT REPLACE DEFAULT 2,
    c    INTEGER NOT NULL ON CONFLICT REPLACE DEFAULT 3
);
```

so that if you try to insert a NULL value you get a default instead?

```
sqlite> CREATE TABLE t1
   ...> (
   ...>     a    INTEGER NOT NULL ON CONFLICT REPLACE DEFAULT 1,
   ...>     b    INTEGER NOT NULL ON CONFLICT REPLACE DEFAULT 2,
   ...>     c    INTEGER NOT NULL ON CONFLICT REPLACE DEFAULT 3
   ...> );
sqlite> insert into t1 values (58,null,null);
sqlite> insert into t1 values (null,36,null);
sqlite> insert into t1 values (null,38,1748);
sqlite> select * from t1;
┌────┬────┬──────┐
│ a  │ b  │  c   │
├────┼────┼──────┤
│ 58 │ 2  │ 3    │
│ 1  │ 36 │ 3    │
│ 1  │ 38 │ 1748 │
└────┴────┴──────┘
sqlite>
```