ایجاد ( create ) فیلد Json

18

CREATE TABLE t(id INT PRIMARY KEY AUTO_INCREMENT,

               json_col JSON,

               name VARCHAR(100) AS (json_col->>'$.name'),

               age INT AS (json_col->'$.age'));

منبع