As for MySQL tables to store the data of the multilingual website?

The website contains a lot of textual information.
This information is translated into several languages (Russian, English ...)

1. How best to organize the storage of this information in MySQL tables?
2. How to optimize queries when the selected one particular language?

I create SQL queries and use Dapper
April 4th 20 at 00:49
2 answers
April 4th 20 at 00:51
1. There is a table with the languages
2. Each table with textual information, for which you need a translation, there is a field with the ID of the language.
3. What can optimize if the query is added to only the sample for the current language?
April 4th 20 at 00:53

In fact the page text is another attribute, the disadvantage of this approach is that you need to handle fulbeck with an empty translation, or add flags/bitmask for the finished translation

another option

A separate table with translations
tid - int
page - text
lang_iso_code - int

Find more questions by tags MySQL