MySQL 8 Cookbook

How to do it...

1. Consider the emp_details table that you created in Chapter 3, Using MySQL (Advanced), Using JSON section:

mysql> SHOW CREATE TABLE emp_details\G*************************** 1. row ***************************       Table: emp_detailsCreate Table: CREATE TABLE `emp_details` (  `emp_no` int(11) NOT NULL,  `details` json DEFAULT NULL,  PRIMARY KEY (`emp_no`)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb41 row in set (0.00 sec)

2. Insert a few dummy records:

mysql> INSERT IGNORE INTO emp_details(emp_no, details) VALUES      ('1', '{ "location": "IN", "phone": "[phone]", "email": "[e-mail]", "address": { "line1": "abc", "line2": "xyz street", "city": "Bangalore", "pin": "560103"}}'), ('2', '{ "location": "IN", "phone": "[phone]", "email": ...