clear markdown compare help best fiddles feedback dbanow.uk
clear markdown donate comments/suggestions/bugs a leap of faith? bible365 diddy dollings
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 2805483 fiddles created (40797 in the last week).

CREATE TabLE table_name (column_name int,b int)
 hidden batch(es)


INSERT INTO table_name VALUES (NULL,1)
 hidden batch(es)


SELECT JSON_ARRAYAGG(column_name) FROM table_name;
JSON_ARRAYAGG(column_name)
[null]
 hidden batch(es)


SELECT IF( (SELECT GROUP_CONCAT(column_name) FROM table_name) IS NOT NULL, (SELECT JSON_ARRAY(GROUP_CONCAT(column_name)) FROM table_name), NULL );
IF( (SELECT GROUP_CONCAT(column_name) FROM table_name) IS NOT NULL, (SELECT JSON_ARRAY(GROUP_CONCAT(column_name)) FROM table_name), NULL )
 hidden batch(es)