Mysql - Create json date from table

create_json_data_from_table.sql

SELECT
	CONCAT(',\',"', c.COLUMN_NAME, '":\',', '\'"\', IFNULL(','REPLACE(TRIM(',c.COLUMN_NAME, '),\'"\',\'\\\\"\'),      \'null\'),', '\'"\'')
FROM information_schema.COLUMNS c
WHERE c.TABLE_NAME = 'xxxxx';

SELECT
	CONCAT('{'	

         /* PASTE RESULT HERE AND FIX SOME MINOR COMMA STUFF */

	'}')	 
FROM xxxx a;

because the mysql bash result adds an extra \ i use sed to replace it to get a valid json
cat sql|mysql -N your_database|sed 's/\\"/\"/g' > result.json