用一个独特的值更新MySQL字段。

I am looking for a mysql update query that will concatenate two fields together and then where unique values still exist add a increment to each value and update a third field. If the concatenated value is unique it should still have to add 1 to the concatenation.I am looking for a mysql update query that will