一、 日期相关函数
select current_date();
select current_date;
select current_time;
当前时间戳：select current_timestamp;
select date_add (current_timestamp(), interval 1 year);
select date_add (current_timestamp(), interval 1 month);
select date_sub (current_timestamp(), interval 1 year);
select date_sub (current_timestamp(), interval 1 month);
select datediff(current_timestamp(), date_add (current_timestamp(), interval 1 month );
select timediff('12:30:30', '18:30:30');
select now();
select year(now());
select month(now());
屏幕快照 2017-11-07 下午3.52.10.png
二、流程控制函数
IF (expr1,expr2,expr3);
select if (1 > 0, 'hello','see you');
IFNULL (expr1,expr2);
select ifnull (null, 3 + 2);
SELECT CASE WHEN expr1 then expr2 else expr3 end;
select case when 10> 0;
屏幕快照 2017-11-07 下午4.52.14.png
三、其他函数
USER();
DATABASE();
MD5(str) ;
PASSWORD(str );
