如何在我的mysql数据库中实现语言系统？

Question

I am creating a video player application with php and mysql.

The application has videos that are gathered in playlists like this:

Playlists table:

+----+------------------+------+
| id | name             | lang |
+----+-------------------------+
|  1 | Introduction     |   1  |
+----+-------------------------+

Videos table:

+----+--------------+-------------+
| id | name         | playlist_id |
+----+--------------+-------------+
|  1 | Video1       |           1 |
|  2 | Video2       |           1 |
+----+--------------+-------------+

It worked fine until now, because I need to build a searcher that finds videos depending on its name and language.

I though of creating another field called lang in the videos table, but then I realize that this maybe would contradict the normalization database rules. Because I would be repeating unnecessary information.

What can I do to select the videos without creating another field? Or do I need to create a new one with the repeated information?

EDIT: JOIN LEFT both tables is not a solution, because I maybe add in the future a new table that links to playlists such as courses.

Answer 1

You can make LANGUAGE_ID COLUMN in Videos table,which will foreign key references to Playlists.lang .

Try above solution.

Hope this will help you.