CAST 資料為 JSON 型別
這會將有效的 json 字串轉換為 MySQL JSON 型別:
SELECT CAST('[1,2,3]' as JSON) ;
SELECT CAST('{"opening":"Sicilian","variations":["pelikan","dragon","najdorf"]}' as JSON);
這會將有效的 json 字串轉換為 MySQL JSON 型別:
SELECT CAST('[1,2,3]' as JSON) ;
SELECT CAST('{"opening":"Sicilian","variations":["pelikan","dragon","najdorf"]}' as JSON);