Your question, your audience. Choose who sees your identity—and your question—with question security.
CREATE OR REPLACE VIEW product_view AS
SELECT
category_id,
cast(CONCAT("#",GROUP_CONCAT(CONCAT_WS('=',prod_name,prod_quantity) SEPARATOR '#'),"#") AS product_quantity_values as VARCHAR(65000))
FROM
product
GROUP BY category_id
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
From novice to tech pro — start learning today.
Open in new window