Back
Syntax
Study
Editor
Mode:
HTML
CSS
JavaScript
PHP
Reset
Run »
HTML / CSS / JS
-- Build JSON object dynamically SELECT JSON_OBJECT('name', name, 'price', price) FROM products; -- Get top-level keys SELECT JSON_KEYS(attributes) FROM products WHERE id = 1; -- ["color", "ram", "gpu"] -- Merge two JSON objects SELECT JSON_MERGE_PATCH('{"a":1}', '{"b":2}'); -- {"a": 1, "b": 2}
Result
Open