Export MySQL to Json

From NSB App Studio
Revision as of 13:32, 4 October 2013 by Kaplanerkan (talk | contribs)
Jump to navigation Jump to search 

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"}
]


Parse the Result

Retrieved from "https://wiki.appstudio.dev/index.php?title=Export_MySQL_to_Json&oldid=4048"