1. 准备要求 参考 MySQL-MGR和主从分离 安装MySQL 8.0.23 版本,用于JSON测试 1 2 3 4 5 6 7 8 9 10 11 12 -- 创建表 CREATETABLE`testjsontable`(`id`intNOTNULL,`jsonfield`jsonDEFAULTNULL,PRIMARYKEY(`id`))ENGINE=InnoDBDEFAULTCHARSET=utf8mb4;-- 创建测试数据 insertintotestjsontable(id,jsonfield)values(1,'{"email":"email","address":[{"line":"abc"},{"name":"456"}]}');insertintotestjsontable(id,jsonfield)values(2,'{"email":"email2","address":[{"line":"abc1"},{"name":"456"}]}');insertintotestjsontable(id,jsonfield)values(3,'{"email":"email","address":[{"line":"abc"},{"name":"123"}]}'); 2. json对