How to set all values in a column to empty (null)?. To reset the value of a nullable column for every row in a table.
Asked
Active
Viewed 999 times
1 Answers
2
Just ignore the WHERE
clause would do the trick. How to change a value in a column on a SQLite database?
UPDATE table_name SET column_name = NULL

XY L
- 25,431
- 14
- 84
- 143