Hello, in this python programming video, we are going to look at the update operation which will allow us to update information in our database. So we got this, these rows here, and what we're going to do is update the row with a name of for Han and update the age to 32. I've increased my by four years. So I'm going to do is need to do SQL query. And this will just be update. Now you specify the table you want to update something.

Now you specify you know what column you're modifying for age and what you said to me too, so you could have enough to center it and then put the variable after you can, you know, do all that stuff. Again, just keeping it simple. Where I'm probably made probably less percentage more like it's been tied, but you know, and now the point where we want to do it if we don't you'll just know date everything and you know you might want that but for now we're just gonna have it where name equals So save that now I'm just going to do a Troy so now we need to do DB rollback. So if some problem occurs to the modifying the database is rolling back to its last known state, so we don't have any problems. So we get your cursor dot key Wow, and DB dot dope like so.

So save that, you know be ready to go. So, I show you by reloading it that the ADSL 26 rifle to run the module successfully run it is have a look. He is now 30. So that is it for the update operation. If you have any questions, feel free to feel free to reach out and I look forward to seeing you in the next video.