How to rework SQL database?

Question

MySQL

Please help me to create a SQL query or macro for Excel that would allow me to run through the entire table and find duplicate values ​​in the fields. And then if the value is repeated, then take the ID of the first element and register it for all other repetitions.
1 - value1
2 - value2
3 - value3
4 - value1
5 - value1
6 -
value2 add
1 - value1 - 1
2 - value2 - 2
3 - value3 - 3
4 - value1 - 1
5 - value1 - 1
6 - value2 - 2

Answer 1

UPDATE `table` AS `t`
  JOIN (
    SELECT MIN(`id`) AS `min`, `value`
      FROM `table`
      GROUP BY `value`
  ) AS `t1` ON `t1`.`value` = `t`.`value`
  SET `t`.`min_id` = `t1`.`min`