STRING ,DATE ,TIME,MATHEMATICAL AND NUMERICAL FUCTION IN MYSQL

(1)

 (a)

mysql> select char_length('I MCA');

mysql> select character_length('A SECTION');

(b)

mysql> select concat('I MCA A','A SECTION');

(c)

mysql> select concat_ws('=','I MCA','A SECTION');

(d)

mysql> select format(123456.1278912,2);

(e)

mysql> select lcase('I MCA');

 (f)

mysql> select locate('SEC','A SECTION');

mysql> select position('SEC'IN'A SECTION');

 (g)

mysql> select repeat('II MCA',3);

 (h)

mysql> select replace('II MCA','MCA','MBA');

(i)Reverse a String

mysql> select reverse('A SECTION');

 (j)

mysql> select substring('A SECTION',3);

 (2) (a)

mysql> select curdate();

(b

mysql> select curtime();

(c)

mysql> select datediff('2008-8-2','2008-7-6');

 (d)

mysql> select date_add('2008-7-6',interval 25 day);

(e)

mysql> select dayname('2008-08-01');

 (f)

mysql> select dayofmonth('2008-06-04');

 (g)

mysql> select dayofweek('2008-06-08');

 (h)

mysql> select dayofyear('2008-01-22');

 (I)

mysql> select hour('18:46:15');

 (j)

mysql> select minute('18:46:15');

 (k

mysql> select monthname('2008-01-22');

 (l)

mysql> select now();

 (3)      (a)

mysql> select abs(-60);

mysql> select sin(60),cos(60),tan(60);

mysql> select acos(60),atan(60),asin(60);

mysql> select ceil(6.78),degrees(pi()),exp(-1);

mysql> select floor(6.69),format(6789012.987654,2);

mysql> select log(5),log(2,290),log(10,610);

mysql> select mod(123,10),degrees(pi()),pow(5,2);

mysql> select radians(60),rand(60),round(60.98);

mysql> select sign(-160),sqrt(269),tan(60);

mysql> select truncate(4.981,1),truncate(451.156,-1);

 (4)      (a)

mysql> select 0=1,5<4.5,4.9<=4.9,5>2,2>=2,8 between 8 and 12,greatest('S','O','A');