MYSQL string functions in Tamil - Part1 | important string functions in MySQL

MYSQL string functions in Tamil | important string functions in MySQL

SELECT ascii('A') as result;
SELECT bin(1000) as result;
SELECT BIT_LENGTH('R') as result;
SELECT CHAR(90) as result;
SELECT CHAR_LENGTH('welcome') as result;
SELECT CHARACTER_LENGTH('welcome') as result;
SELECT concat('welcome','to','parallel code') as result;
SELECT concat_ws(' ','welcome','to','parallel code') as result;
SELECT elt(3,'welcome','to','parallel code') as result;
SELECT FIELD('63','4','2','63','46') as result;
SELECT FIND_IN_SET('46','4,2,63,46') as result;
SELECT FORMAT(354345643.47583,0) as result;
SELECT to_base64('Tiger') as decoded, FROM_base64(to_base64('tiger')) as encode;
SELECT hex(1234567) as hexadecimal;
SELECT INSERT('Welcomeparallel code',8,3,' to') as result;



Video link
   • MYSQL string functions in Tamil - Par...  
Email : [email protected]