Deal with null value in sqlite

Question

I want to insert a zero in a record that contains a null value by updating that table. I have used the following code but to no avail.

Statement statementXIV = db.createStatement("UPDATE Temp54 SET bal53 = '0' WHERE balan = NULL ");
                    statementXIV.prepare();
                    statementXIV.execute();       
                    statementXIV.close();

What is the right way to use a null in a WHERE clause?

score 1 · Accepted Answer · edited May 23 '17 at 11:56

1

I would suggest using:

UPDATE Temp54 SET bal53 = '0' WHERE balan IS NULL OR balan = ''

Also, see this link, SQLite select where empty?. The accepted answer gives a variety of methods which is always good to know.

edited May 23 '17 at 11:56

Community

1
1

answered May 15 '12 at 18:01

CM Kanode

1,436
1
11
14

Deal with null value in sqlite

1 Answers1