How to organize a self-replenishing lookup table in MySQL?

Question

MySQL

There is a main table, and it has an address field. Addresses are often repeated. You can create a parent lookup table, Address, and in the main table, a foreign key address_id that refers to the id field in the Address table. Everything would be fine, but only new addresses can be added from time to time. To do this, you will have to manually add a new address to the Address table, after which adding an entry to the main table will become possible. It's a hemorrhoid, to be honest.
Is it possible to auto-complete a lookup table using MySQL 5.7?

Answer 1

no.
How is it that the addresses often match? my address, for example, only matches my wife's address

Answer 2

What does manually mean? Why is it impossible to check the presence of an address in the directory when creating an entry, and if it is not there, then create it immediately?

Answer 3

Triggers, when inserting into a table where there are many addresses, we saw a trigger that tries to insert the address into the reference table, but the address field must be unique there, that's all, even if the address is repeated, it will not be inserted as a new record