Posts by Jeferson Drewanz • 26 points
1 post
-
1
votes1
answer190
viewsA: Postgres/Mysql Changing the data of a repeating field
Try this: update Table set f_name = f_name || f_id where f_name in (SELECT f_name FROM table GROUP BY f_name HAVING COUNT(f_name) > 1); It’s not the best solution, because it takes all the…