Shulou(Shulou.com)06/02 Report--

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

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.