msyql常用函数

set @i = 0;
select @i := @i+1 as row from gsrm7_custom_test_inter.itf_job ij;

select @i;
-- mysql最大连接数；
select @@max_connections;
--  查询数据库日志信息
show variables like 'log_%';
-- 查询慢查询sql
show variables like '%slow_query%';

select lpad(cd.orgname,30,'-') from gsrm7_custom_test_ec.cms_doc cd;
select rpad(cd.orgname,30,'-') from gsrm7_custom_test_ec.cms_doc cd;
select now(),curdate(),current_time,current_date,current_user from dual;
select lower('QWEQWE'),upper('qweasd') FROM dual;
select strcmp('qwe','qweaaqwqqwqwqwqwqwqewwqrewqrew'),length('qwe'),char_length('qwe') FROM dual;

select find_in_set('abc','123,456,qwe,abc') from dual;
select field('abc','123','456','qwe','abc') from dual;

select locate('abc','123,456,qwe,abc') from dual;
select position('abc' in '123,456,qwe,abc') from dual;

select instr('123,abc,456,qwe,abc','abc') from dual;