JfHyxhwc

1CREATE TABLE IF NOT EXISTS `users` (
2  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
3  `username` varchar(50) COLLATE utf8_unicode_ci NOT NULL COMMENT 'username',
4  `auth_list` json DEFAULT NULL COMMENT 'mac address list',
5  PRIMARY KEY (`id`),
6  UNIQUE KEY `id` (`id`)
7) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=5 ;
8	
9INSERT INTO users ( username,auth_list )
10VALUES('admin','{"mac":["b0fc361479de"]}')
11	
12UPDATE users SET auth_list = JSON_INSERT(auth_list , '$.mac','c84wr8492eda') WHERE username='admin'
13	
14{"mac": "b0fc361479de"}
15	
16{"mac": ["b0fc361479de","c84wr8492eda"]}