I've got legacy ecommerce database, which is awfully designed and I need to move all products from it to new solution. But I stuck with how product properties stored. So it basically has tens of tables named
category_properties_<category_id> that have first column named
product_id and then variable number of columns that contain
I. e. there can be table
category_properties_42 with records like
category_properties_43 with records like
Is it possible using MySQL to export this data in more reasonable format? Because variable number of columns and variable table names makes querying by product almost impossible. Thanks in advance.