Skip to main content

Return to Question

added 4 characters in body
Source Link
sticky bit
sticky bit
  • 37.7k
  • 12
  • 34
  • 46

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'")

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?

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?

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?

Source Link
Herwini
Herwini
  • 457
  • 6
  • 31

How to update an entire sql column using python?

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?