MySQL 8.0

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

select version();


version()


8.0.30


create table card (
  id int,
  column_for_update int
)
insert into card 
  values
(1,10),
(2,11),
(3,12),
(4,13),
(5,14)

Records: 5  Duplicates: 0  Warnings: 0


select * from card


id
column_for_update


1
10

2
11

3
12

4
13

5
14


UPDATE card a
INNER JOIN card b ON a.id = b.id
SET a.column_for_update = (b.id * 1000)

Rows matched: 5  Changed: 5  Warnings: 0


select * from card


id
column_for_update


1
1000

2
2000

3
3000

4
4000

5
5000