View Single Post
Old 02-18-2013, 04:38 PM   PM User | #2
Old Pedant
Supreme Master coder!

 
Old Pedant's Avatar
 
Join Date: Feb 2009
Posts: 23,248
Thanks: 59
Thanked 3,999 Times in 3,968 Posts
Old Pedant is a name known to allOld Pedant is a name known to allOld Pedant is a name known to allOld Pedant is a name known to allOld Pedant is a name known to allOld Pedant is a name known to all
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.
__________________
An optimist sees the glass as half full.
A pessimist sees the glass as half empty.
A realist drinks it no matter how much there is.
Old Pedant is offline   Reply With Quote