UPDATE disease_types
SET adapted_code = "A" || code;

##</code><code>##

INSERT INTO disease_types (adapted_code)
SELECT "A" || code FROM disease_types;