Export MySQL to Json: Difference between revisions
Jump to navigation
Jump to search
Kaplanerkan (talk | contribs) (Created page with "<pre> SELECT CONCAT("[", GROUP_CONCAT( CONCAT("{Menue:'",mysql_Table_1,"'"), CONCAT(",Text_D:'",mysql_Table_2),"'}") ,"]") ...") |
Kaplanerkan (talk | contribs) No edit summary |
||
| Line 1: | Line 1: | ||
<pre> | <pre> | ||
SELECT | |||
SET SESSION group_concat_max_len = 100000000; | |||
SELECT | |||
CONCAT("[", | |||
GROUP_CONCAT( | |||
AS json FROM menu; | CONCAT("{ \"Menue\": \" ", Menue , " \" "), | ||
CONCAT(", \"Text_D\": \" ", Text_D), " \"}") | |||
,"]") | |||
AS json FROM menu ; | |||
</pre> | </pre> | ||
Revision as of 13:30, 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 ;