Export MySQL to Json: Difference between revisions

From NSB App Studio
Jump to navigation Jump to search
No edit summary
No edit summary
Line 12: Line 12:


</pre>
</pre>
== Parse the Result ==

Revision as of 13:31, 4 October 2013


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