Member Avatar for basketmen

Hi guys,

I have a table, the table name is account,
its have 2 fields : membersid, and categoryid

i want to change the categoryid field content, i run this in phpmyadmin :

update `account` set categoryid = replace (categoryid, '1' , '2');

but get this error message

#1062 - Duplicate entry '23933-27243-0' for key 'membersid'

- what should i do so i can change the field content? Please help.
I already tried changing the field TYPE, from INT, to BIGINT, like other person suggested, but still get that error message

- this is the screenshot from the field Structure

[IMG]http://i291.photobucket.com/albums/ll284/basketmen/field.jpg[/IMG]

  • 2 Contributors
  • 1 Reply
  • 109 Views
  • 20 Hours Discussion Span
  • Latest Post Latest Post by smantscheff
Member Avatar for smantscheff

Show the output of SHOW CREATE TABLE account . This table has a unique index on three fields which seems to be semantically wrong.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.