Update But not Duplicate

[carl024]

table data
Ename=Melsi
Payrate=100

I Update Ename Melsei to Carl in update query and result it
Ename= Carl
Payrate=100

but i update other data wrongly change Ename is Johan to Carl for example orignal data
Ename=Johan
Payrate=100

update data
Ename= Carl
Payrate=100

i need tip to update data but not allow duplicate

 

[MStef]

Tray with an index on this fields, with UNIQUE = Yes.

 

[mujib ur rahman]

u should be require to write where conditions like update table_name set ename=carl where id= "write id here" which u update record