First,im a kinda noob with mysql,i know some basics,not more.
Thats the reason for my following question:
I have a giant .txt file with many user datas in,but now i need all these datas in a sql database.
The database contains a table called "Plots" with the following rows: idx ; idz ; owner ; topX ; topZ
So the format of the datas in the txt file is that:
max: {x: 127.0, y: 200.0, z: 208.0}
user: [maximini97]
I marked with colors wich data has to be in what row.
The row idx and idz just has to be continued in that style: -1;-2 etc
I have about 2000 datas to put in,and doing this by hand would be a fulltime job.
So i need a sql command or a script for this.
I would be very happy when someone can help me with this
Greetings
Bone