chiheb khodrane chiheb khodrane - 27 days ago 6
SQL Question

How to delete multiple rows in Sqlite Manager

i have a sql database, it contain 50.000 records but i want only 100 records.
it is very hard to delete it manually, so there is not a solution to delete it with SQl Commands (using SQlite Manager of Firfox)

Thank you

Answer Source

Finally i've found my solution, its just simple condition code:

DELETE FROM `TABLE_NAME`
WHERE `id` > '100'

after you run this code, all rows which have id > 100 will be deleted. you can change the condition as you want, like changing table name, condition name (in my case its "id"), and the condition "<" or ">"...

i hope its helpfull..!