How to link mysql tables?

Question

MySQL

There are two tables, but adress contains the number of the house (home), that is, 453 is 4 house 53 apartment how to link such tables? data type integer in two cases.

Answer 1

many-to-many foreign key relationships , etc.
In general, it is correct to store the house number and apartment number in different columns of the table. And already house numbers and house type to bind many-to-many, through an intermediate table.