Is it possible to uniqueize identical values ​​in phpMyAdmin by adding numbers to them (entry, entry 1, entry 2....)?

Question

MySQL

Hello. You need to uniqueize values ​​in the same database column if they are repeated. That is, change the values ​​from "entry", "entry", "entry" to "entry", "entry 1", "entry 2"... Is it possible to implement this in phpMyAdmin?

Answer 1

it is possible, for example

SET @tempVariable = 0;

UPDATE myTable SET col1 = 5, col2 = (@tempVariable := @tempVariable + 1);