Remove multiple rows from table

[Fynnon]

In table 'users' i have too many rows and i want to delete most of them.
How can i delete every row from 5001 to 50000 ? I want to keep just the first 5000 rows

[blind-eddie]

Why so many tables and what is in them?

[Fynnon]

they are unused user accounts.
i have access to phpmyadmin but i'm not sure how can i remove those

[Kane@airrifle]

Why not just prune users from ACP/Users with the criteria set at whatever "Has not logged on for x days" and post count less than 1?

[blind-eddie]

Backup your database from within phpmyadmin.
On your main database, select each table you are wanting to drop, scroll below the table list and select, "Drop Selected".
Good Luck!

[Paul M]

Originally Posted by Fynnon

In table 'users' i have too many rows and i want to delete most of them.
How can i delete every row from 5001 to 50000 ? I want to keep just the first 5000 rows

One word. Dont.

Its a bad idea, there are far more tables associated with users than just the user table.

There is also nothing to be gained by doing it.

[Fynnon]

I'll leave the users as it is, thanks !

there is another table from a mod which records everyone who used the chat and it has over 2.000.000 rows
of course it would take forever to remove them page by page so i'm looking for an sql command to clean old & inactive ones

[Mark.B]

What is the table called?
If it's specific to that mod and the mod is now uninstalled you MIGHT be able to get rid of it but we would need more details.

Be careful also of the differences between tables and columns.

[Fynnon]

the database is called: 'infernoshoutusers'
i use the mod but it has '2.882.822' rows, they are 1/3 of the forum db size

[Mark.B]

Before doing anything in the database, does the mod have any sort of pruning option?
Or does it have a cron job as part of it, and if so, is it running? Try running any cron for it manually.

Beyond that it might be worth backing up the data from that table alone, then truncating it and seeing what effect it has on the modification.

It shouldn't affect the main forums as it's a custom table, it should inky affect the mod.