how to delete not a specific row but a specific field in a row SQLITE

Question

like if table has three columns

just to delete the data of columnA and columnB but not the columnC

since where clause only allows to select a specific row not data in various columns of that row

idarwin · Accepted Answer · 2016-01-31 14:41:10Z

1

Why not just do

update table set columnA=null, columnB=null where ...

Assuming you get the "where" clause right, this should remove the data from the requested columns.

answered Jan 31, 2016 at 14:41

idarwin

6471 gold badge5 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

you saved my life. thank you! why did i not think of it that way? pressure i guess:-)

@nadir Probably because you've not gone through the basics of sql