Quote:
Originally Posted by danielkza
Best way to do this is to add a PRIMARY KEY column for the table, normally using AUTO_INCREMENT, that should represent each row with an unique number. Then you can read it and do 'DELETE FROM table WHERE id=%d LIMIT 1'.
|
That's the problem, If have a primary key, I'm not allowed duplicate rows am I? Because the table is set up "<Entity Model> <X><Y><Z>" but I have the same entity model in the table. If I set a key, it throws the "duplicate row" error.
__________________