Sqlite: how to update only empty fields

Question

Hi and thanks for your help,

I am really new to SQL, so I kindly ask your help.

I did my research, but so far I have not been able to find a solution.

I have a partiality populated column is my Sqlite database.

Some fields are empty, some contain a number.

I need to populate only the empty fields with the number 60000.

Thank for ant help

HSQL · Accepted Answer · 2013-05-15 19:12:11Z

1

Try this :-

Update tablename SET number = 60000 where field IS NULL

answered May 15, 2013 at 19:12

HSQL

742 bronze badges

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

1 Comment

@HSQL Please format code in your answer.

Gordon Linoff · Accepted Answer · 2013-05-15 19:11:58Z

1

Try something like this:

update t
    set col = 60000
    where col is null;

That is, you can add a where clause to the update statement to limit the rows that are affected.

answered May 15, 2013 at 19:11

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

peterm · Accepted Answer · 2013-05-15 19:16:54Z

1

Try using UPDATE with WHERE columnname IS NULL

UPDATE yourtable
   SET yourcolumn = 60000
 WHERE yourcolumn IS NULL

answered May 15, 2013 at 19:11

peterm

93k16 gold badges157 silver badges162 bronze badges