Pls, check create sql query?
ps. screenshot is in attach
yes and when i create and change field from heidiSql
HeidiSql is generate folow sql with error
ALTER TABLE good ADD COLUMN attr_prop_int INT DEFAULT NULL AS (json_value(attr,'$.prop_int')) VIRTUAL AFTER attr;
I remove the expression "DEFAULT NULL" from sql and the query works well
ALTER TABLE good ADD COLUMN attr_prop_int INT AS (json_value(attr,'$.prop_int')) VIRTUAL AFTER attr;
Please login to leave a reply, or register at first.