(Oct-13-2023, 11:35 AM)deanhystad Wrote: I still see no value here. How can you look up those percentages in the database? Try writing the query that would retrieve them.
will be something like this:
"SELECT * from calcio inner join sbostats on sbostats.partita = calcio.partita";
but for now i have to insert data from txt to the database so something like:
INSERT INTO sbostats (partita,p1,pX,p2,p1x,px2,p12) VALUES ( "Verona - Napoli", "10.42%", "27.08%","62.5%", "37.5%", "89.58%", "72.92%")
i can also add that columns in the table calcio via insert update with where clause.. but my problem is to build the insert query from txt to database