MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select version();


version()


8.0.27


CREATE TABLE contabb1(
  id int AUTO_INCREMENT PRIMARY KEY,
  pereje int
  );
INSERT INTO contabb1 (pereje) VALUES
  (5),(4),(3),(2),(1);
CREATE TABLE contabb1backup
  SELECT * FROM contabb1;
UPDATE contabb1 set pereje=NULL;
SELECT * FROM contabb1;


id
pereje


1
null

2
null

3
null

4
null

5
null


UPDATE contabb1
  JOIN contabb1backup USING(id)
  set contabb1.pereje=contabb1backup.pereje;
SELECT * FROM contabb1;


id
pereje


1
5

2
4

3
3

4
2

5
1

id	pereje
1	null
2	null
3	null
4	null
5	null