Dynamic Unpivoting of a Table
['rearrange-products-table']
['Truncate table Products', "insert into Products (product_id, LC_Store, Nozama, Shop, Souq) values ('1', '100', NULL, '110', NULL)", "insert into Products (product_id, LC_Store, Nozama, Shop, Souq) values ('2', NULL, '200', NULL, '190')", "insert into Products (product_id, LC_Store, Nozama, Shop, Souq) values ('3', NULL, NULL, '1000', '1900')"]
{"mysql": [], "mssql": [], "oraclesql": [], "database": true, "manual": true, "name": "dynamic_unpivoting_of_a_table"}
{"mysql": ["MySQL", "<p><code>MySQL 8.0</code>.</p>"], "mssql": ["MS SQL Server", "<p><code>mssql server 2019</code>.</p>"], "oraclesql": ["Oracle", "<p><code>Oracle Sql 11.2</code>.</p>"], "pythondata": ["Pandas", "<p>Python 3.10 with Pandas 2.2.2 and NumPy 1.26.4</p>"]}
['Database']