Export MySQL to Json

From NSB App Studio
Revision as of 13:31, 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 ;

Parse the Result