Starting from unique and progressive `ID` to build a new string using MySQL

Starting from a MySQL table with the following unique and progressive IDs

I need update the column pID of the same MySQL table by constructing a string of type YYYY-ID

Expected Output:

Any help really appreciated.

>Solution :

You can CONCAT ‘2022-‘ string to your ID column, padded with LPAD, filled with 0 on the left:

UPDATE table SET pID = CONCAT('2022-', LPAD(ID, 4, 0))

If you need current year:

UPDATE table SET pID = CONCAT(DATE_FORMAT(CURDATE(), '%Y'), '-', LPAD(ID, 4, 0))