How can I update two rows in SQLite with Python?

Question

I'm trying to update two rows in SQLite with Python:

Puntero.execute(
"UPDATE '{T}' set '{F}' = '{C}','{V}' = '{U}' where ID='{I}'"
.format(T = Tabl, F = fecha, V = Vendidos, U = id, C= Cantidad, I=id))

Thanks for helping!

"... where ID='{I}' OR ID='{I_other}'".format(... I=id, I_other=id_other) — wanderlust
– wanderlust, Commented May 18, 2017 at 7:08

Chris Travers · Accepted Answer · 2017-05-18 09:24:14Z

1

First, don't do it that way. You are setting yourself up for SQL injections. Use placeholders instead.

What you want is:

Puntero.execute(
   "UPDATE Tabl set fecha = :C, Vendidos = :U where ID=in(:I1, :I2)", 
      {"U": id, "C":Cantidad, "I1":id, "I2":otherid}
)

answered May 18, 2017 at 9:24

Chris Travers

26.6k6 gold badges70 silver badges191 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Thanks, Chris, now It is necessary to take into account that tablet, is a variable, that takes many values.

IN () can take any number.