Mysql 函数

show warnings;

select abs(-5),abs(5);

select pi();

select sqrt(9);

select mod(12,7);

select ceil(30.25),floor(30.25);

select rand(),rand(),rand(10),rand(10);

select char_length('abcd'),length('abcd');

show status;
show engines;
show databases;
show tables;
show COLUMNS from t_logs;
desc t_logs;
show grants;
show errors;
show warnings;
select version(),connection_id();
show processlist;
show full processlist;
select database(),schema();
select user(),system_user(),current_user();
select charset(version()),collation(version());
select LAST_INSERT_ID();
select md5('123456');
select encode('123456','11'),length(encode('123456','11'));
select decode(encode('123456','11'),'11');
select format('12.2356',2),format('12.2356',8),format('12.2356',0);