All language subtitles for 12. UPDATE

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