Back
Syntax
Study
Editor
Mode:
HTML
CSS
JavaScript
PHP
Reset
Run »
HTML / CSS / JS
-- Build a JSON array of product names per category SELECT c.name, JSON_ARRAYAGG(p.name) AS products FROM categories c JOIN products p ON p.category_id = c.id GROUP BY c.id, c.name; -- JSON object: id => name SELECT JSON_OBJECTAGG(id, name) FROM products;
Result
Open