How to implement such a structure?

Таблица_Язык id название 1 РУС 2 УКР 3 АНГ Таблица_Новости id язык_id текст 1 2 новость на украинском 2 3 новость на английском 3 1 новость на русском

I understand that in the Table_News table is a duplicate key id ? If the news in 3 languages:

 id язык_id текст 1 1 Привет 1 2 Привiт 1 3 Hello

If they do not repeat ( id = 1,2,3), as shown above, then should I choose IN (id, id + 1, id + 2) ? To select one news in 3 languages?

    1 answer 1

    Yes, either the primary key is divided into two columns (if id is the news id, not the row), or split into two tables.

    • Yes, in one table languages, in another news in 3 languages, that is, the key is the same, not unique, thanks. - Man