PRIMARY KEY

baba's profile image baba posted 2 months ago in General Permalink

Hey, support I am having a problem when I try to put something in this problem is popping up, please help me!!

1 attachment(s):
  • image
ansgar's profile image ansgar posted 2 months ago Permalink

Well, the error already says it - the table has data rows with non-unique values, in a column which you want to define as a primary unique key. You need to update all duplicate values before creating a unique index.

baba's profile image baba posted 2 months ago Permalink

how to you duplicate values before creating a unique index?

baba's profile image baba posted 2 months ago Permalink

i mean how do i update all duplicate values before creating a unique index?

ansgar's profile image ansgar posted 2 months ago Permalink

In the data tab, by watching out for duplicate values in the column.

You should probably make yourself more familiar with databases in general.

Please login to leave a reply, or register at first.