drop database if exists appdev4db;
create database appdev4db;
use appdev4db;
create table T1 (C1 INT, C2 CHAR(4), C3 GEOMETRY);
insert into T1 values (1,'AAAA',ST_GeomFromGeoJSON('{"type": "Point", "coordinates": [74.6466372, 16.8241727]}'));
select * from T1;
select JSON_ARRAY(C1,C2,C3) from T1;
select JSON_ARRAY(ST_ASGEOJSON(C3)) from T1;
select JSON_ARRAY(JSON_QUERY(ST_ASGEOJSON(C3),'$')) from T1;
select JSON_ARRAY(C1,JSON_QUERY(ST_ASGEOJSON(C3),'$')) from T1;
select JSON_ARRAY(C1,C2,JSON_QUERY(ST_ASGEOJSON(C3),'$')) from T1;


