Answer the question
In order to leave comments, you need to log in
How to remove rows from a table if their value is less than 10000?
Tried such request:
the request is fulfilled, and lines are not deleted. DELETE FROM "pos" WHERE num = '<10000'
Answer the question
In order to leave comments, you need to log in
Maybe still ?
UPD. If you have postgres, not mysql (by the way - what do you have? What motivates the simultaneous presence of these two tags?) - then you will probably need to do type conversion, something like this: . DELETE FROM pos WHERE num < 10000
num::integer < 10000
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question