Re: How to store different languages

> i.e.
>
> http://www.mysqltutorial.org/mysql-create-table/
>
> ;)

[Quoted] Ahahah! Lol! :D

I understood your db idea, so you think to create a languages table, ingredients table and users table.

In the ingredients table you have id not primary key and not autoincrement so it'll be

languages

0  | English
1  | Dutch
2  | Italian

ingredients

1  | 0              | Milk
1  | 1              | Melk
2  | 0              | Spelt
3  | 0              | Onion
4  | 1              | Boter
5  | 1              | Eieren
1  | 2              | Latte
6  | 2              | Miele

But I should start to add every ingredients in the main language (english) also if the ingredient doesn't have a translation.

You're the second person who said the same solution to solve my "problem" and I understood it's the right solution but... what do you think about my first idea to create a main language table with every english ingredients and a translation table connected to the main table by a FK?

If I use my idea I should copy in the translation table also all english ingredients and set them like "english" in the language column!

^Bart Received on Mon Apr 22 2019 - 20:11:39 CEST