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.
Tried regular update statements
New contributor
Ashish Jangid is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
1