clock  Mon - Sun 8.00 AM - 8.00 PM
mail  edu@teknowize.com
fb
instagram
play store
pinterest

More

SQL Functions

Imperial Advance Hero Image

SQL Functions

SQL CONCAT( ) FUNCTION

 The concat( ) function add two or more expression together. 

For add two or more expressions from column 

 

Syntax -

 Select Concat (expression1 , expression2 , expression3 , …………);

sql concat function

 

Syntax - 

select concat ( column_name1, ' ', column_name2, ' ' , ……….. ) from table_name as fullname; 

sql concat function

 

SQL REVERSE ( ) FUNCTION

 The reverse function uses to write anything reversely. 

 

Syntax -

select reverse ( ‘write any string’ );

or 

select reverse ( ‘write any string’ ) as reverse ;

sql reverse function

SQL CHARACTER LENGTH FUNCTION 

This is used to count the length of words, numbers etc. 

 

Syntax -

select char_length (‘ any character’);

sql character length function

SQL UPPER CASE FUNCTION 

This is used to write lower words to the upper word.

 

Syntax -

select upper (' any character ');

sql upper case function

SQL LOWER CASE FUNCTION 

This is used to write lower words to upper word. 

 

Syntax -

select lower (' any charecter ');

sql lower case function

MySql