Export MySQL to Json
SET SESSION group_concat_max_len = 100000000; SELECT CONCAT("[", GROUP_CONCAT( CONCAT("{ \"Menue\": \" ", Menue , " \" "), CONCAT(", \"Text_D\": \" ", Text_D), " \"}") ,"]") AS json FROM menu ;
Datas.json
[ {"Menue":"1", "TextD":"Sake"}, {"Menue":"2", "TextD":"Maguro"}, {"Menue":"3", "TextD":"Mutsu"}, {"Menue":"4", "TextD":"Izumidai"}, {"Menue":"5", "TextD":"Amaebi"}, {"Menue":"6", "TextD":"Ebi"}, {"Menue":"7", "TextD":"Kanikama"}, {"Menue":"8", "TextD":"Avocado"}, {"Menue":"9", "TextD":"Tamago"} ]