1

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.

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

1 Answers1

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