Updating auto_increment ID Column/Selecting Duplicate Rows

hi, i have 2 questions that i badly need answered. i use phpmyadmin, but any answers containing SQL syntax should work in this app... 1) this should be simple but i don't know it. i use the following mysql table field as the Key for my tables: id int(10) unsigned NOT NULL auto_increment,

Re: Updating auto_increment ID Column/Selecting Duplicate Rows

Tom Churm wrote: hi, i have 2 questions that i badly need answered. i use phpmyadmin, but any answers containing SQL syntax should work in this app... 1) this should be simple but i don't know it. i use the following mysql table field as the Key for my tables: id int(10)

RE: Updating auto_increment ID Column/Selecting Duplicate Rows

This would give you a list of all users that have entered things more than once; However, it would not give you all the rows that are duplicated. SELECT Count(User) from mail_form2 GROUP BY User HAVING Count(User) 1 Hope this helps! Daniel Von Fange