Quote:I don't see any value in putting this information in a database. A database needs to be carefully designed to be useful. If you could put this information into a database, what kind of queries would you want to perform? Use the queries to define what tables and columns you'll need in your database, then write the code to load the file into database tables. Don't create the tables first then try to figure out how to write a query.
from this txt file i need only the percentages
Verona - Napoli partita column
10.42% p1 column
27.08% px column
62.5% p2 column
37.5% p1X column
89.58% pX2 column
72.92% p12 column
so i need to create and send
inserts like
sql = "INSERT INTO sbostats (partita,p1,pX,p2,p1x,px2,p12) VALUES (%s, %s,%s, %s,%s, %s, %s)"
val = ( "Verona - Napoli", "10.42%", "27.08%","62.5%", "37.5%", "89.58%", "72.92%")
one for each 7 lines (match) of the txt file
then i will make some joins/query and view on other tables of my database.