Robin Rodricks
Reputation: 114126
SQL to delete the value from a column where both columns exist
Is this correct? Will it work with Sqlite as well?
UPDATE table SET oldCol=NULL WHERE (oldCol!=NULL AND newCol!=NULL)
Upvotes: 0
Views: 44
Answers (2)
Mowgli
Reputation: 129
you can use this also. UPDATE table SET oldCol=NULL WHERE (oldCol is not NULL AND newCol is not NULL)
Upvotes: -1
potashin
Reputation: 44601
No, you should use is not null:
update tbl set oldcol = null where oldcol is not null and newcol is not null
Upvotes: 3
Related Questions
- Delete row from table where match exists in second table
- How to delete 1 row by 2 variables in sqlite?
- SQLITE3 - Deleting rows that have multiple columns of the same value
- How do I delete a row using two different column values sqlite
- SQLite delete rows based on multiple columns
- how to delete not a specific row but a specific field in a row SQLITE
- Sqlite delete data from columns
- Delete rows by pair of columns that exist in a table
- Delete From SQLite Using Select Statement
- deleting a row where a particular column is empty