Leetcode Problem 2253. Dynamic Unpivoting of a Table

2253. Dynamic Unpivoting of a Table

Leetcode Solutions

Set the group_concat_max_len session variable to a large number to ensure that the dynamically created SQL query does not get truncated.
Initialize a variable @sql to NULL.
Use GROUP_CONCAT to concatenate all the SELECT statements for each store column in the Products table, excluding the product_id column.
For each store column, create a SELECT statement that selects the product_id, the store name as store, and the store column as price only where the store column is not NULL.
Use UNION to combine all the SELECT statements into one single query.
Prepare a statement from the dynamically created SQL query stored in @sql.
Execute the prepared statement.
Deallocate the prepared statement.

erDiagram
    Products {
        int product_id PK
        int store_name1
        int store_name2
        int store_namen
    }

Programming Language

Purpose:

General Question

Debug My Code

image/screenshot of info(optional)

Full Screen