Import json to database while only using heidisql

[expired user #9657]'s profile image [expired user #9657] posted 8 years ago in General Permalink

Hello Forum,

I need to insert a pregenerated JSON into my DB.

While im not that good with DB's I can only use the heidisql to do so.

but i have no idea how can someone help me, i searched the Interwebs but found nothing that worked.

Thanks in advance

Hunteroooox

[expired user #9657]'s profile image [expired user #9657] posted 8 years ago Permalink

json looks something like:

{

"elements":[
    {
    "angle":90,
    "x":80,
    "y":50,
    "width":100,
    "heigth":150,
    "type":"rectangle",
    "settings":{
            "backgroundColor": "#FFFFFF",
            "position":"top-right"
        }
    },
    {
    "angle":90,
    "x":80,
    "y":50,
    "width":100,
    "heigth":150,
    "type":"rectangle",
    "settings":{
            "backgroundColor": "#FFFFFF",
            "position":"center"
        }
    }
]

}

[expired user #9657]'s profile image [expired user #9657] posted 8 years ago Permalink

Got it!!!!!! i used a different method to get the data in the database

delos's profile image delos posted 7 years ago Permalink

What method did you use to get the data in the database?

Please login to leave a reply, or register at first.