Export MySQL to Json

From NSB App Studio
Revision as of 23:36, 3 October 2013 by Kaplanerkan (talk | contribs) (Created page with "<pre> SELECT CONCAT("[", GROUP_CONCAT( CONCAT("{Menue:'",mysql_Table_1,"'"), CONCAT(",Text_D:'",mysql_Table_2),"'}") ,"]") ...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search
SELECT 
     CONCAT("[",
          GROUP_CONCAT(
               CONCAT("{Menue:'",mysql_Table_1,"'"),
               CONCAT(",Text_D:'",mysql_Table_2),"'}")
     ,"]") 
AS json FROM menu;