MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE Employee ( id INT, name VARCHAR(25), state VARCHAR(25) )
INSERT INTO Employee VALUES
(1,'SwapnaS','Bangalore'),
(2,'Divya','Hyderabad'),
(3,'Akshaya','Delhi'),
(4,'Rajini',NULL)
SELECT JSON_PRETTY(
                    JSON_OBJECT(
                                'id',id , 
                                'name',name,
                                'state',state
                    )
                  ) AS value
  FROM Employee


value


{
  "id": 1,
  "name": "SwapnaS",
  "state": "Bangalore"
}

{
  "id": 2,
  "name": "Divya",
  "state": "Hyderabad"
}

{
  "id": 3,
  "name": "Akshaya",
  "state": "Delhi"
}

{
  "id": 4,
  "name": "Rajini",
  "state": null
}