Originally Posted by Old Pedant
If you don't have something that uniquely identifies each record, you can't select which one to delete. In other words, if you don't have a PRIMARY KEY in your (very badly named) TABLE then you can't do this easily.
If you do have a primary key, just SELECT it along with the other fields and *probably* PhpMyAdmin will be able to do it.
Well, I used TABLE just to mask the table name...so yes, I would suppose my ruse would be a badly named table.
The reason I asked the question is I recently switched hosts and the previous hosts PHPMyAdmin allowed me to use the exact query (with the correct table name) with no problem, but the new hosts phpmyadmin does not.
And no, I do not have a primary key defined as I was not the original creator of the database and now that I have 23k+ records, I was never sure of the implications of trying to define one now, and especially because there isn't a field that can be truly unique...a link in the lnktxt field would have the same dsptxt field info, but could have a multiple entries, each with a unique cattxt....I would almost have to create a brand new field and populate it with data just to be able to have a primary key.