Export MySQL to Json

SET SESSION group_concat_max_len = 100000000;  // IMPORTANT

SELECT
  CONCAT("[",
   GROUP_CONCAT(
       CONCAT("{ \"Menue\":  \" ",  Menue  , " \" "),
       CONCAT(", \"Text_D\": \" ",  Text_D), " \"}")
       ,"]")
AS json FROM menu ;

Privat SQL only for me

SET SESSION group_concat_max_len = 100000000;
SELECT
	CONCAT("[",
	GROUP_CONCAT(
	CONCAT("{\"Menue\":\"",Menue,"\""),
	CONCAT(",\"Text_D\":\"",Text_D,"\""),
	CONCAT(",\"Beschreibung_D\":\"",Beschreibung_D,"\""),
	CONCAT(",\"Sort\":\"",Sort,"\""),
	CONCAT(",\"Gruppe\":\"",Gruppe,"\""),
	CONCAT(",\"Preis3\":\"",Preis3,"\""),
	CONCAT(",\"WarenGruppe\":\"",WarenGruppe,"\""),
	CONCAT(",\"Extra\":\"",Extra,"\""),
	CONCAT(",\"WGruppenText\":\"",waren_gruppen.Text,"\""),
	CONCAT(",\"Sabu_Sabu\":\"",Sabu_Sabu,"\""),
	CONCAT(",\"Ipad_Zeitzone\":\"",Ipad_Zeitzone,"\""),
	CONCAT(",\"ShabuShabu_AH\":\"",ShabuShabu_AH,"\""),
	CONCAT(",\"ShabuShabu_ALK\":\"",ShabuShabu_ALK,"\""),
	CONCAT(",\"ShabuShabu_ALK_Preis\":\"",ShabuShabu_ALK_Preis,"\""),
	CONCAT(",\"Text_D\":\"",Text_D),"\"}")
,"]")
AS json FROM menu  INNER JOIN waren_gruppen ON menu.WarenGruppe = waren_gruppen.Firma ; ;

Datas.json saved as Array

[
{"Menue":"1", "TextD":"Sake"},
{"Menue":"2", "TextD":"Maguro"},
{"Menue":"3", "TextD":"Mutsu"},
{"Menue":"4", "TextD":"Izumidai"},
{"Menue":"5", "TextD":"Amaebi"},
{"Menue":"6", "TextD":"Ebi"},
{"Menue":"7", "TextD":"Kanikama"},
{"Menue":"8", "TextD":"Avocado"},
{"Menue":"9", "TextD":"Tamago"}
]

Parse the Result

Function Button1_onclick()
$.getJSON("datas.json", gotResult)
End Function




Function gotResult(data)
  Dim speisen=[]
    // For i=0 To i < data.length
    For i=0 To 10
            speisen[i]=[String(data[i].Menue),String(data[i].TextD)]
    Next
    
End Function



'JavaScript
'  var speisen=[];
'  $.getJSON("datas.json", function(data) {
'    var i=0;
'    for (i=0; i<10; i++){
'      speisen[i]=[String(data[i].Menue),String(data[i].TextD)];
'    }
'  });
'End JavaScript



' ANOTHER METHODS

'JavaScript
'$.getJSON( "datas.json", function(data) {
' var items = [];
'  $.each( data, function( key, val ) {
'    items.push( "<li id='" + key + "'>" + val + "</li>" );
'  });
' 
'  $( "<ul/>", {
'    "class": "my-new-list",
'    html: items.join( "" )
'  }).appendTo( "body" );
'});
' 
'
'End JavaScript