DominikStyp/expected_result.csv

## expected_result.csv

          
            name
            color
            price

            
              Laptop
              black
              11000.00

            
              Jeans
              blue
              NULL

## select_from_json_table.sql
USE test;

set @json='
[
  {"name":"Laptop", "color":"black", "price":"1000"},
  {"name":"Jeans",  "color":"blue"}
]';

select * from json_table(@json, '$[*]'
  columns(
   name  varchar(10) path '$.name',
   color varchar(10) path '$.color',
   price decimal(8,2) path '$.price' )
) as jt;
	USE test;

	set @json='
	[
	{"name":"Laptop", "color":"black", "price":"1000"},
	{"name":"Jeans", "color":"blue"}
	]';

	select * from json_table(@json, '$[*]'
	columns(
	name varchar(10) path '$.name',
	color varchar(10) path '$.color',
	price decimal(8,2) path '$.price' )
	) as jt;