0
![Database Administrators](http://cdn.sstatic.net/dba/img/apple-touch-icon.png)
Im trying to do an UPDATE statement.
UPDATE `users` SET
`Email` = 'email@domain.com',
`Mobile` = '123456789',
`City` = 'Chicago',
`Firstname` = 'John',
`Lastname` = 'Smith',
`DOB` = '1980-01-01',
`Sex` = 'male'
#1062 - Duplicate entry '123456789' for key 'Mobile'
But I'm updating the record w...