How to update an entire sql column using python?

Question

I want to update an entire column in a sql database. With the following command I can update a both the age and height of the person bob:

cursur.execute("UPDATE students SET age=10, height= 1.6 WHERE name='bob'")

But is there a way to fill in vectors for age, height and name, so that multiple values are updated simultaneously?

Rajan · Accepted Answer · 2021-02-22 11:19:22Z

1

you can use a function:

def updateData(age, height, name):
    myQuery = "UPDATE students SET age=" + age + "  height=" + height +" WHERE name=" + name
    cursur.execute(myQuery)

you can use a for loop if you want to loop through array or any data.

answered Feb 22, 2021 at 11:19

Rajan

7671 gold badge10 silver badges22 bronze badges

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

1 Comment

Herwini Over a year ago

Thanks. I actually wondered If it could with out a for loop.

Collectives™ on Stack Overflow

How to update an entire sql column using python?

1 Answer 1

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Related