Trying to search a column in a db (sqlite) and replace specific numeric values with nothing

Question

I am trying to search the table actions in my database and delete any value within the code column that has the value of 40.

I have tried:

REPLACE (code,40,'') 
FROM actions

but no luck. Also tried the DELETE function.

Possible duplicate of how to find and replace a word in a mysql column? — eshirima
– eshirima, Commented Jul 28, 2017 at 15:11

Siyual · Accepted Answer · 2017-07-28 15:27:25Z

3

You're looking for UPDATE:

Update   actions
Set      code = Null
Where    code = 40

If you need to delete the entire row, you can do it with the following:

Delete   
From     actions
Where    code = 40

edited Jul 28, 2017 at 15:27

answered Jul 28, 2017 at 15:05

Siyual

17k8 gold badges47 silver badges60 bronze badges

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

11 Comments

ImpactGary Over a year ago

When I tried that I get the following error message:

ImpactGary Over a year ago

NOT NULL constraint failed: actions.code: Update actions Set code = Null Where code = 40

Siyual Over a year ago

You have a NOT NULL constraint on your column that you're trying to set to NULL. You will either need to update the column definition, or set the value to something other than NULL (i.e. 0 or -1 - this depends on your data and how you use it.)

ImpactGary Over a year ago

Problem though! I just found out that I need to delete any row instead of deleting the the cell content where that data shows up. How can i do that?

Shawn Over a year ago

I would HIGHLY recommend putting this in a TRANSACTION before running it, then verifying that you get what you need before you COMMIT it. It's a whole lot easier to ROLLBACK than it is to restore from a backup.

|

Collectives™ on Stack Overflow

Trying to search a column in a db (sqlite) and replace specific numeric values with nothing

1 Answer 1

11 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

11 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related