R
R
rafaelSalihov2020-01-18 17:31:03
SQLite
rafaelSalihov, 2020-01-18 17:31:03

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

2 answer(s)
D
Dmitry Gordinskiy, 2020-01-18
@rafaelSalihov

UPDATE tab1 SET fieldName = 1 WHERE fieldName IS NULL;

D
Dimonchik, 2020-01-18
@dimonchik2013


I try an example like this:
you need it like this:
it turns out like this:

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question