Search code examples
sqldatabasesqlitesqlitemanager

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

Solution

  • 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..!