With the following command to the field names in JSON go, via sed to replace the identifiers including colon with an empty string. Here for players.json file: sed -i ‘s/”id”:\|”name”:\|”alliance_id”:\|”points”:\|”rank”:\|”towns”://g’ players.json SQL syntax to load the data into a mySQL database LOAD DATA INFILE ‘players2.json’ INTO TABLE players FIELDS TERMINATED BY ‘,’ OPTIONALLY ENCLOSED BY [...]
Posts Tagged ‘grepolis worlddata’
Grepolis World Data and mySQL
February 17th, 2010 
mdshare
Posted in Grepolis 
Tags: browser game, browsergames, Grepolis, grepolis mysql, grepolis script, grepolis world data, grepolis worlddata, innogames 
No Comments »
