Export MySQL to Json: Difference between revisions
Jump to navigation
Jump to search
Kaplanerkan (talk | contribs) No edit summary |
Kaplanerkan (talk | contribs) 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 ;