I've got a table of Product records from an old db that I must change to import on a new php system. They have the form:
name, property1_IT, property1_EN, property1_FR
I need to transform them by duplicating each row and change it like:
name, language, property1
property1 will have the related translated value.
In other words, I'll need one row for each product translation, thus adding a language column and deleting the property translation fields.
Is it possible with sql or should I just use php to cicle through the records and doing the duplication tasks?