phpMyadmin won't delete multiple selected records

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
slade27
Forum Newbie
Posts: 21
Joined: Tue Apr 24, 2007 3:49 am

phpMyadmin won't delete multiple selected records

Post by slade27 »

I'm using myphpadmin 2.9.0.2 and I'm having trouble deleting more than one record at a time from a table. I've tried it in two different browsers (Firefox and Safari) and get the same problem. It looks as if, even though I've selected many records, most of the selections are somehow becoming unselected the split second before the delete command takes effect.

So, for instance, I click on "check all" (to select all records) and then click on the red "X" beside the "check all" button. Just before the "confirm delete" message appears, 9/10ths or more of the selected records somehow become unselected... so that after clicking to confirm the delete, I actually succeed in deleting only a few records, even though I had originally had 30 or so checked.

Any ideas what's going on?

Thanks for your help.
User avatar
superdezign
DevNet Master
Posts: 4135
Joined: Sat Jan 20, 2007 11:06 pm

Post by superdezign »

Well, I don't uses phpMyAdmin anymore because it has too many limits. I'm sure they deselect some of your choices automatically because they have limits on how many queries to run, as I don't think they right the queries the same.

For example, if you wanted to clear a table using regular queries, you'd run:

Code: Select all

DELETE FROM `table`;
phpMyAdmin would have a separate DELETE query for every column that you selected, but it can only run so many queries at once. I don't know how you can change the limit... Maybe you try Google.
Post Reply