You have not included a critical information Are all tables InnoDB or do you have MyISAM as well?
uid is thr column which you should delete one of uids? What if there are 3 equal uids? Still i need to know if there is a column which uniquely identies the rows such as a dat...