mercredi 15 avril 2015

Python 3.4.2 How to insert data into a specific row in a sqlite database?

I have a table containing the name, score 1, score 2, and score 3 of a player. There are multiple data entries and I would like to know how to add the player's score to their correct row, i.e.:



Name, Score 1, Score 2, Score 3
John, 12, ____, ____


How would I specify what row to insert the player's score 2 into when using



.execute('''INSERT INTO ScoresTable (name, score 1, score 2, score 3)''')


Do I use the row index but how would I implement that into the code?


Aucun commentaire:

Enregistrer un commentaire