How to change null and empty string in sqlite?

Question

Here is my sqlite databse ,you can see some cell are null or empty string when opening with sqlitemanager.

How can i change all the null and empty string into 0 (zero) in this sqlite database ,not by hand one by one (you can do it in sqlite manager,but it is stupid to change all in one database).

enter image description here

josepn · Accepted Answer · 2014-05-06 15:50:47Z

1

UPDATE grade SET d3 = 0
   WHERE d3 IS NULL OR d3 = ''

answered May 6, 2014 at 15:50

josepn

3674 silver badges5 bronze badges

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

Collectives™ on Stack Overflow

How to change null and empty string in sqlite?

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