Syntax Error

Question

UpdateT='UPDATE customer_details SET NO_OF_BIKE_TAKEN={bike_return} + NO_OF_BIKE_TAKEN WHERE ID={id}'

See there is one customer whose id is 4 , and he have 5 bike which are given on rent. So first time came and given 2 bike . Later came and given 3 bike . So I want to add no of bike taken from him i.e 2 and after once again taken from him i.e 3 . So I want to update in such a manner that when ever net time he will come . That time no of bike which he gave get sum with newly returning bike.

Eg id - 4
No of bike given (Given by owner) - 5
No of bike taken (Taken after Rented ) - 2
Later coming to give once again 3
No of bike taken (Taken after Rented ) - 2 + 3 .
So I want newly updated value to be 5

Answer 1

I have trouble understanding what you are attempting, but I will point out that your interpolated string is missing the f in front of the first quote.

UpdateT = f"UPDATE ...

Answer 2

Love you bro . Thankyou very much . It worked 👌👌👏👏☺️☺️