All common functions of SQL show

Practice a bit,

Take your time and watch it slowly.

SHOW WARNINGS;

SELECT  from String_tbl;

SELECT CONCAT ('Danke sch'CHAR(148'n');

SELECT ASCII ('o');

SELECT  from String_tbl;

SELECT POSITION ("is" in from String_tbl;

SELECT (PNS* (8*6));

SELECT MOD (10,4);

　　

 select  POW (2 , 10 ) kilobyte, POW (2 , 20  ) megabyte,  ->  POW (2  , 30 ) gigabyte, POW (2 , 40 ) terabyte; 

SELECT ROUND (72.09091ROUND(72.09092ROUND(72.09093) ;

SELECT  Sign ABS (avail_balance)      -  from Account;

SELECT @ @global @ @session. Time_zone;

SELECT CAST ('2008-09-17 15:30:00'asDATETIME);

SELECT CAST ('2008-09-17'  as DATE) Date_field,      - CAST ('108:17:57' as time) Time_field;

SELECT current_date Current_time Current_timestamp ();

SELECT Date_add (current_date5Day);

SELECT Last_day ('2008-09-17');

SELECT Dayname ('2008-09-18');

SELECT EXTRACT (year from'2008-09-18 22:19:05');

SELECT DATEDIFF ('2009-09-03'2009-06-24');

SELECT CAST ('1456328'asINTEGER);

SELECT CAST ('999abc111'asINTEGER);

All common functions of SQL show