Unique column data update
I’ve a table with 6 columns, column_1 is PK, column_2 is not null and UNIQUE. I can insert new rows from a reporting tool but when I update data in column_2 for an existing row it creates a new row. Is it not possible to update row data in a UNIQUE column? The new data is not duplicate or anything.
SQL: Unique column data update
I’ve a table with 6 columns, column_1 is PK, column_2 is not null and UNIQUE. I can insert new rows from a reporting tool but when I update data in column_2 for an existing row it creates a new row. Is it not possible to update row data in a UNIQUE column? The new data is not duplicate or anything.