数据库相关

show PROCESSLIST;        
show global status like 'Max_used_connections';     
//超时时间查询
show variables like '%timeout%';  
SELECT * FROM language_pack ORDER BY id desc, purpose ;
SELECT purpose FROM language_pack where purpose LIKE "测试%"
SELECT purpose FROM language_pack where purpose like "测_"
SELECT purpose FROM language_pack where purpose REGEXP "韩"
SELECT purpose FROM language_pack where purpose REGEXP "测|试"
SELECT * FROM typicalprojectinfo where project_name_zh REGEXP "[[:alnum:]]"
SELECT CONCAT(project_name_en,'{',project_name_zh,'}') FROM typicalprojectinfo
SELECT CONCAT(project_name_en,'{',project_name_zh,'}') as mix_name FROM typicalprojectinfo
SELECT dept_no,COUNT(*) FROM dept_emp GROUP BY dept_no WITH ROLLUP;