Original subtitles

0 In this video we will learn how to update 1

The records in our table 2

To update records 3

Update query is used in SQL 4

This is the syntax of update query 5

It starts with update 6

Then we mention the table name 7

Then is the keywords set 8

After this we mention 9

The column 10

And its value which is to be set 11

We can specify multiple columns 12

Then we can give where condition 13

so we saw where condition to specify different conditions 14

We can use where if you want to update particular records 15

If you want to update the whole table we may not use the where condition 16

Let us look at some of the examples of update query 17

let us say 18

We want to update the age 19

And the last name of the customer whose customer ID is 2 20

So we go to the database and we look at the table 21

let us see the customer with customer ID 2 22

Customer table where cust ID 2 23

So this customer is 24

23 years old 25

And the last name of this customer is missing 26

If you want to add the last name and 27

Change the age to 17 years 28

This is how we do it we write update 29

Table name 30

then we write set 31

Specify the column name which is last name 32

then we give it the value of Pe 33

Then 34

We specify age column 35

And give it a value of 17 where 36

customer ID is 2 37

Let us run this 38

1 39

Value updated. let us go and check 40

You can see last name of the customer is updated to Pe 41

And age is now 17 42

Now if you want to update email ids 43

Of customers 44

Whose first name is Gee or 45

Small cased gee 46

You can see in our table 47

If you search 48

Customers with name gee 49

Let us get all the customer names from customer table 50

Let us run this to look at our data 51

Table first 52

You can see that there are four customers with first name gee 53

And one of them 54

As the name gee in small case 55

For all these four customers we want to update the email id to gee 56

@ xyz.com 57

So how to do that 58

We will write the update query 59

Update customer table 60

Set 61

Email id to gee 62

@ xyz.com where 63

First name 64

is Equal to 65

Gee 66

in camel case and then Gee in small case 67

You can notice that we are using or operator 68

to give two conditions at the same time 69

let us run this 70

and let us run the select query again 71

you can see 72

for the customers 73

The last four customers with name gee 74

All four have the same email id which is gee @ 75

Xyz.com 76

This was not the email ID when this table was created earlier 77

That's how we update the rows of a datatable 78

Next you will learn how to delete 79

Rows or records from a Table