lundi 28 septembre 2015

python 3 sqlite change cell value via input

Hello i was looking for a way to change a cell value in a sqlite DB via input. Lets say you have this DB here.

ID Name Position

1 Test1 Outside

2 Test2 Inside

So i want the program to do to following, when it receives one of the ID as a input, like 1, then i want it to change the string under "Position" from outside to innside, but only for the row where Test1 is, and if it receives 2 as a input change Inside to outside but again only for Test2.

I appreciate all the help i can get, and i am open to alternative ways, but i would prefere using a sqlite databse and Python3.

Thank You.

Aucun commentaire:

Enregistrer un commentaire