mysql awk

 mysql -uroot boss_monitor --execute="select monitor_node_id,cache_info_id_list from monitor_sub_task where monitor_task_id=66;" |awk '{print "update monitor_sub_task set cache_info_id_list=!"$2"! where monitor_task_id=82 and monitor_node_id="$1";\r"}' |sed -e "s/\!/\'/g"

 

mysql -uroot mydns -e "select a.id from $i a where (a.zone,a.host,a.type,a.data,a.ttl) in (select zone,host,type,data,ttl from $i group by zone,host,type,data,ttl having count(id)>1) and id not in (select min(id) from $i group by zone,host,type,data,ttl having count(id) > 1);"|grep -v id|awk -F '|' '{print $1}'|awk  '{print "delete from !'$i'! where id=!"$1"!;"}'| sed 's|!||g' >> sql/update.sql

 

 

 

mysql -u root mydns -e "select id from rg_any where host like 'origin.image-beinggirl-com-cn';" |awk -v var="'" -v var2="\"" '{if(NR>2){cmd="/usr/bin/mysql -u root mydns -e "var2"select * from rg_any where id ="var""$1""var""var2;system(cmd)}}'

 

转载于:https://my.oschina.net/YcOk14itqTKB/blog/3765