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.