Find null values from table and replace it with space - sqlite

Question

I am having sqlite database.

In some columns I am having null values.

I want to replace null values with space..

Is there any query for this?

Please let me know

CL. · Accepted Answer · 2012-09-25 14:54:24Z

3

Use IFNULL. In a query:

SELECT IFNULL(mycolumn, ' ') FROM mytable

Or to change the data in the table:

UPDATE mytable SET mycolumn = IFNULL(mycolumn, ' ')

Alternatively:

UPDATE mytable SET mycolumn = ' ' WHERE mycolumn IS NULL

answered Sep 25, 2012 at 14:54

CL.

182k18 gold badges241 silver badges282 bronze badges

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

1 Answer 1