Original subtitles

0 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 ||