Sqlite delete data from columns

Question

I have a table with 4 columns like this:

Date           Col1          Col2        Col3

27/03/2012     data          data        data

28/03/2012     data          data        data

I want to delete data from Col1 and Col2 from the row where date is 27/03/2012. Can anybody tell me how the query must be made?

Alex Wilson · Accepted Answer · 2012-07-03 18:47:41Z

10

Is this what you want?

DELETE FROM tableName WHERE Col1="27/03/2012" OR Col2="27/03/2012"

Update in response to some clarifications:

To set Col2 to NULL for a particular date:

UPDATE tableName SET Col2=NULL WHERE Date="27/03/2012"

edited Jul 3, 2012 at 18:47

answered Jul 3, 2012 at 18:23

Alex Wilson

6,79030 silver badges44 bronze badges

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

5 Comments

Taziano Over a year ago

Sorry, I didn't ask my question clear. I want to delete the data from col1 and col2 from the row where the column date has the date 27/03/2012, which is in the same row. Hope its clear now what I want.

Alex Wilson Over a year ago

Just to be clear, you want to find the row where date is 27/03/2012. Do you then want to delete that row, or do you want to set the data in col2 to NULL (or something else)?

Taziano Over a year ago

Yes, first I want to find the row where date is 27/03/2012. And then I want to set the data in col2 to NULL.

Alex Wilson Over a year ago

Excellent. Fancy accepting the answer with the big tick too? :-)

Taziano Over a year ago

I cannot vote up because I don't have enough reputations. I will do this later when I have enough reputations.

Collectives™ on Stack Overflow

Sqlite delete data from columns

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related