MySQL中的JSON-GONE WITH THE WIND-51CTO博客
CREATE TABLE IF NOT EXISTS `spss`.`variable` (`name` VARCHAR(512) NOT NULL,
`type` JSON NOT NULL,
`width` INT NOT NULL,
`decimals` INT NOT NULL,
`label` VARCHAR(512) NOT NULL,
`values` JSON NOT NULL,
`missing` JSON NOT NULL,
`columns` INT NOT NULL,
`align` ENUM('Left', 'Right', 'Center') NOT NULL,
`measure` ENUM('Scale', 'Ordinal', 'Norminal') NOT NULL,
`role` ENUM('Input', 'Target', 'Both', 'None', 'Partation', 'Split') NOT NULL,
PRIMARY KEY (`name`))
ENGINE = InnoDB;
insert into variable values('S1', '{"Numeric":"8:0"}', 8, 0, '您的性别?', '{"1":"男","2":"女"}', '{"Missing":"None"}',8,'Left','Nominal', 'Input');
insert into variable values('S2', '{"Numeric":"8:0"}', 8, 0, '您的实际年龄?', '{}', '{}',8,'Left','Nominal', 'Input');
select * from variable where JSON_Extract( `values`,'$."1"') = '男';
select * from variable where `values`->'$."1"' = '男';
select * from variable where measure = 'Nominal';
页:
[1]