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