Hi! Could we please enable some services and cookies to improve your experience and our website?
Online Sandbox for SQL and PHP: Write, Run, Test, and Share SQL Queries and PHP Code
SELECT tbl.*
FROM JSON_TABLE(
'{"data":[{"id":1,"name":"one"},{"id":2,"name":"two"},{"id":3,"name":"three"}]}',
'$.data[*]' COLUMNS (
id VARCHAR(40) PATH '$.id',
name VARCHAR(100) PATH '$.name')
) tbl
<?php
$array = [
['id' => 1, 'name' => 'one'],
['id' => 2, 'name' => 'two'],
['id' => 3, 'name' => 'three']
];
$data = json_encode($array);
$sql = "SELECT tbl.*
FROM JSON_TABLE(
'{\"data\":$data}',
'$.data[*]' COLUMNS (
id VARCHAR(40) PATH '$.id',
name VARCHAR(100) PATH '$.name')
) tbl";
echo $sql;