So now it's time to talk about the update reverse. So, yes, I'm talking about the UPDATE statement. So the UPDATE statement is used to modify the existing record in the table. Course. As you know, we have six records from students. As you know, this is these are the records.

Now I want to update this record how I'm saying I want to add the address in this field, six ID. Now how can you do that? First of all, you need the update, keyword update. Then they will learn and things to read and then to update the student table. Now I'm seeing set value equals to why I'm writing This comment, because two quotation sorry, because it's a string where you I'm going to add the string value. That's why, if you have a integer value, then you can add it like this.

Okay, now what I'm saying x y Zed my by using set and saying set address. That is I'm saying I'm going to update the record students. And now I'm going to set the value which value this value in this column. Right. If you execute this query, it will update the all the records because you are not specifying that which address you are going to update. So that's why Before going this or before updating any table, you have to use the where clause, which is unique ID.

Now I'm saying update record where s ID equals to six. As you as you know, this is the sixth ID, I'm saying, oh please update set the value x y Zed Mumbai, where the ID is six. Now, execute your query Ctrl Enter. And now show you how to select the static from students Ctrl Enter. As you can see, you have just updated the record moving so now by this, I am saying I'm going to update the record without the class what happens if you use the UPDATE statement without WHERE clause financing UPDATE students am saying set As address equals two, in this time I'm saying London only London without weight loss now execute your query Ctrl y and using Ctrl, enter because this is a data grid and you can you have two options basically, right click execute your query or press the record button and hit enter.

If you're working on Oracle and some other databases, you may have some other interfaces or some other class acuity. Now, I'm saying select static from student show me all the records hit the enter. So now as you can see, you have updated the London to all your records as you can see, now this is the difference so you have to specify Which a row you are going to upgrade and which column you are going for suppose even if you want to update two columns, how can you do that? I'm saying update the students. And now I'm saying set S address equals to four. Suppose I'm saying York, New York.

And now I'm saying karma and city equals to make sure equals to New York. Okay, now Control Enter, execute your query. Caller saying, hello. Now I'm saying that and sorry. You have to Use the comma okay now I don't enter now into static form students enter so now you can see it's showing you the records but without you have just executed theory without WHERE clause. So now I'm saying UPDATE students set as city sorry set city equals two parcels.

London and karma am saying that address equals to UK that means the United Kingdom and now I'm saying where ID equals two One. So now I'm saying I'm going to update to call up. So as you know, these are the columns and these are the values up and return and I'm going to update the record which has one ID now, I'm talking about this one. So now Ctrl Enter. Okay I have just executed. So now I am saying select the Steadicam students have all entered so now they can see you have just upgraded to record.

In this way you can perform the UPDATE statement. So I think this is enough for the next session we are going to cover some other topics. So thank you for watching.