All language subtitles for 5. CONCATENATION

Next we will look at an operator this operator will actually be joining several strings and the function is
1

Is known as concatenation
2

So when you want to join two or more strings
3

You will be using this operator
4

So this operator
5

uses
6

the symbol of a double pipe
7

so pipe symbol is below your backspace key above your enter key
8

And you'll need to press the shift key and then press this key to get the pipe symbol
9

Mention one string
10

Put two pipes
11

Mention another string, both the strings will be concatenated in other words both of these strings will be joined
12

So for example if you want to
13

Concatenate the different parts of addresses that you have in your customer table
14

Into one single column which contains all the parts of the addresses
15

So for example for a particular customer I want in another column
16

the city state and the country to which that customer belongs
17

to do that
18

I'll select the customer name
19

and in the second column I will concatenate City
20

With state
21

With the country
22

To add this special character of comma in between
23

I'll use
24

Single quotes
25

and I'll mention this comma
26

Alongside this comma is two spaces so that our data looks good
27

This whole column is named as address
28

And this belongs to the customer table
29

Let us go and write this query
30

I want to select customer name
31

And
32

I'll concatenate
33

City
34

Comma
35

Space comma space
36

With state
37

Concatenate
38

Space comma space country
39

And this will be named as address
40

From the customer table
41

Run this
42

You can see
43

For the first customer
44

The address is Henderson Kentucky
45

United States. So it is city state and the country
46

So this is how
47

You can concatenate different strings
48

Two or more columns
49

A particular string to a particular column
50

All these things can be done using the concatenate function and the operator for this is ||