表結(jié)構(gòu):v_date為虛擬列CREATE TABLE `test` ( `json` TEXT NULL, `date` DATETIME NULL DEFAULT NULL, `v_date` DATE AS (json_extract(`json`,'$.date')) VIRTUAL)COMMENT='測(cè)試表\r\n'COLLATE='utf8mb4_general_ci'ENGINE=InnoDB;插入:INSERT INTO test (json) VALUES ('{"date":"2019-01-21 00:00:00"}');報(bào)錯(cuò):ERROR 3156 (22018): Invalid JSON value for CAST to DATE/TIME/DATETIME/TIMESTAMP from column json_extract at row 1嘗試了各種格式:INSERT INTO `test`.`test_virtual_column` (`json`) VALUES ('{"date":"20191221"}');/* SQL錯(cuò)誤(3156):Invalid JSON value for CAST to DATE/TIME/DATETIME/TIMESTAMP from column json_extract at row 1 */INSERT INTO `test`.`test_virtual_column` (`json`) VALUES ('{"date":20191221}');/* SQL錯(cuò)誤(3156):Invalid JSON value for CAST to DATE/TIME/DATETIME/TIMESTAMP from column
json_extract at row 1 */請(qǐng)問(wèn)如何保存Date類型的數(shù)據(jù)到虛擬列中?
Mysql5.7 虛擬列數(shù)據(jù)類型為DATE時(shí),如何存入數(shù)據(jù)?
料青山看我應(yīng)如是
2019-02-06 21:39:06