So in this video lecture we go ahead and look at how to update our tables.
So and right here I have this guy called Peter Jude.
And it's Timo is a pretty dude.
And this guy is I know I can be able to add anything or I can be able to rename this Peter.
First of all, let me go ahead and rename Peter.
And uh, and I'm going to say then when I say updates, table updates and then the server name is students
and they I'll go ahead and say set email.
So set email equal to I'm going to say this is a Peter man at uh.
Yahoo.
Now that com.
So I'm going to set us email to be Peter man@yahoo.com.
Um, well.
I can say first name or email or anything because you've learned about it.
We are close.
So we are.
First name is equal to Peter.
I'm professor McDonald.
And and if I go ahead and hit on enter update one.
And then if I should go back and uh select a string and hit enter, you can see that uh, okay.
I actually did not select to view this table.
I was just going to view the columns.
So to view the students their work I'll go ahead and say uh, select uh all from students where Omicron
N and this is Peter Mount at Yahoo Mail.com.
You see that?
And over here, if I had not run this.
And let's go ahead and check it out.
And now this takes the time.
It takes the time to actually update because I'm recording.
and that is why it is affecting my pgadmin.
And it should have.
Always or already updated immediately.
Okay, but you can see from the show that I have put a man at Yahoo!
Mail.com and no longer RT Jude at gmail.com.
All right, I hope that is cool.
So I'll go ahead and say select from strength.
And I'll go ahead and execute this query or any one of them.
Go ahead and execute this query.
And you can see I have a pizza man at Yahoo!
Mail.com.
And hope that is cool.
So I just updated that now and uh, it actually went down instead of being up.
But that isn't the problem.
It was always going to know how to do this in ascending and descending other as time comes on.
All right.
So as time goes on, we are also going to learn about how to arrange this in ascending or descending
order.
And that is not a problem.
Now I can also go ahead and uh, add in each because we don't have each or I'll go ahead and add this
one that I know.
Or let's go ahead and use Used Pgadmin to update this because I've done that using the show.
So let's see.
Uh, update.
Students and I'll go ahead and, uh, say it.
I'm going to set the email or the age to okay.
I'm going to set age equal to 24.
All right.
So set it equal to 24.
And uh, where then I can actually select maybe Sarah where students ID.
Students underscore ID is equal to five or 4 or 2.
Let me say four.
And then press semicolon at the end.
And let's go ahead and run.
This going to go over to this place and select that and check it out.
So backslash d and um or go ahead and select uh all from.
Students The Empress Omicron at the end of days and hit enter.
And you can see that Sarah age is now 24 because I just updated that.
So go ahead and update every other one of them one by one so that it can be able to master it.
So Sarah is now updated and Peter email was updated.
I can rename their names.
I can change their names from Henry to any name, Rocky to any name, Judith to any name, Rocky to
any name, and Barack and so on and so forth.
All right.
So this is a way we can be able to update a table in PostgreSQL.
All right.
Let me go ahead and check this one more time.
So I'll just go ahead and use the SQL shell because it's very easy.
And this is what most developers actually use.
So that is about updates.
And you go ahead in the next lecture to check out something very interesting again.
So continue with the lecture if you have any question on this just the question and answer section.
Else we move over to the next lecture and get hold of what is happening there.
So see you then and bye.