Answer the question
In order to leave comments, you need to log in
How to replace values in SQLlite table?
In How to make a query correctly so that in the entire table tab1 to replace NULL values with 1 is acceptable.
I re-read, I can not fully understand these requests.
Answer the question
In order to leave comments, you need to log in
UPDATE tab1 SET fieldName = 1 WHERE fieldName IS NULL;
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question