How to properly organize the work of node.js and MySQL?

Question

MySQL

Guys, look, there is a table with countries, let's call it coutnry, in which we store
country_id
, there is also another country_info table.
The essence of the question is, how to correctly select id = information about this country on the node?
If there are articles in Russian, I will be glad.
Thanks in advance.

Answer 1

Lyrical digression:
You will do selection by means of sql. It makes no difference which programming language and environment to use.
The code:

SELECT * 
FROM 
    `country`
    JOIN `country_info` ON (`country_info`.`country_id`=`country`.`id`)

Documentation in Russian