How to get response from mysql client in json format in bash?

Question

linux

actually the mysql subject
is able to give in html or xml i
want json
advise the script - to give it data through the pipe (apparently xml), the script on stdout gives - ready json?
or are there other options?
upd as far as I understand, in the form in which I described - it cannot be solved by means of mysql itself,
but you can rewrite queries in accordance with dev.mysql.com/doc/refman/5.7/en/json.html
for example select json_array(now()) ; instead of select now();

Answer 1

mysql have introduced json support in latest versions