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.
phpMyadmin won't delete multiple selected records
Moderator: General Moderators
- superdezign
- DevNet Master
- Posts: 4135
- Joined: Sat Jan 20, 2007 11:06 pm
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:
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.
For example, if you wanted to clear a table using regular queries, you'd run:
Code: Select all
DELETE FROM `table`;