見(jiàn)賢思小齊，知足常樂(lè)呵

-- 查看全部進(jìn)程
show processlist;  
-- 查詢(xún)進(jìn)行中的進(jìn)程
select *from information_schema.processlist where command not in('Sleep','Killed'); 
-- 查詢(xún)某個(gè)庫(kù)的進(jìn)程
select *from information_schema.processlist where db='dw';
-- 殺掉某進(jìn)程, 從上述進(jìn)程中獲取某任務(wù)的首字段即為進(jìn)程id
kill ***;

select 
concat(
char(10),'drop procedure if exists ',ROUTINE_NAME,';',char(10),
'create procedure ',ROUTINE_NAME,'()',char(10),
ROUTINE_DEFINITION,';',char(10)
)
from information_schema.ROUTINES
where routine_schema = 'dw'               --  目標(biāo)庫(kù) 
and routine_name in('dw_test');           --  目標(biāo)存儲(chǔ)過(guò)程名稱(chēng)

select  
concat(
char(10),'drop procedure if exists ',ROUTINE_NAME,';',char(10),
'create procedure ',ROUTINE_NAME,'(',
 convert(( select param_list from mysql.proc n where  n.db = 'dw'    --  目標(biāo)庫(kù)
and  n.name = m.ROUTINE_NAME),char)
,')',char(10),
ROUTINE_DEFINITION,';',char(10)
)
from information_schema.ROUTINES m
where routine_schema = 'dw'                         -- 目標(biāo)庫(kù)
and routine_name in('dw_test');                     -- 目標(biāo)存儲(chǔ)過(guò)程名稱(chēng)

table_sqls=`mysql -h**** -u**** -p**** -P*** -D*** -e"show create table test_table"|awk -F'\t' '{print $2}'`
echo "drop table if exists $line;"$table_sqls";">>$target_sql
echo $target_sql