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;