How to assign the value of one field to another + numbers?

Question

MySQL

We have 2 fields

id and sku

in id there is a unique value from 1 ....
and in sku it is empty, the task is to assign all sku = id , but the difficulty is that you need to add the number 700 to sku,
for example
id sku
1 7001
245 700245

Answer 1

UPDATE `table` set `sku` = concat("700", id);