sql 语法

递归查询（findSubJob）
子job的consollot_unid = 父job的unid，从strunid开始
select unid ,consollot_unid,level from job where voidby is null start with unid in (strunid) connect by prior unid = consollot_unid


/*2016-06-29 add by lu for openapi*/
set @vspId=16052614280160002;
INSERT into iov.openapi_dev_key_ext(recd_id,dev_key,vsp_id,create_time,update_time,note) VALUE ('1','0533c64ef50a59f6db175985f7a1395a',@vspId,NOW(),NOW(),'init');

===========mysql 查看索引分区============
EXPLAIN PARTITIONS select * from * where a=XX


=========================================
show variables like '%timeout%';