Json operation of mysql8
Insert into myTable (details,'$ yearbook details) values (5 Magi 2019 cast ('{"": [{"u": 1, "t": 123}]}'as json) SELECT id FROM myTable where id=4 and json_contains_path (details- >'$[*]', 'one','$ [*] .'); update myTable set details=JSON_ARRAY_APPEND (details,'$ [1] .', cast ('{"u": 2, "t": 999}'as json)) where id=5
