MySQL 8.0

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

select version();


version()


8.0.36


CREATE TABLE addresses ( 
  id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
  line_1 VARCHAR(40),
  line_2 VARCHAR(40),
  line_3 VARCHAR(40),
  postal_code VARCHAR(40),
  hash_code VARCHAR(32) AS (MD5(CONCAT(line_1, line_2, line_3, postal_code)))
);

INSERT INTO addresses(line_1, line_2, line_3, postal_code) VALUES(
'Foo', 'Bar', 'Baz', 'ABC123'
);
SELECT * FROM addresses


id
line_1
line_2
line_3
postal_code
hash_code


1
Foo
Bar
Baz
ABC123
78669a19f984313b4544439f64a41c43