Re: Good structure for diversified data

[Rick James]

> contains one question and one answer per record

Yet your SELECT contains two questions and two answers??
Consider COALESCE() function.

> contains one question and one answer per record, in two languages

That is, you are presenting the question twice, once in each language?

> I want to split one existing table in two because I do not want to add 30 fields each time I add a language-specific field and umpteen other fields if I add another language. So, I split in a table with base data (_Stamm) and another table that has (for instance) 30 records per base record in the base table (_Lang). My question was if that makes sense or if there is a better way.

If you mean that there will be N records for N languages, then yes. This will not be in the main table, but a secondary table.