Export MySQL to Json
SELECT
CONCAT("[",
GROUP_CONCAT(
CONCAT("{Menue:'",mysql_Table_1,"'"),
CONCAT(",Text_D:'",mysql_Table_2),"'}")
,"]")
AS json FROM menu;
SELECT
CONCAT("[",
GROUP_CONCAT(
CONCAT("{Menue:'",mysql_Table_1,"'"),
CONCAT(",Text_D:'",mysql_Table_2),"'}")
,"]")
AS json FROM menu;