命令如下:
mysql -h cp01-dba-dbbk-036.cp01 -P 5511 -udonghan -pdonghan -Doped_noah_virgo -N -e" set names utf8; select distinct job_instance.create_user_name , token.create_user_name from job_instance, token where job_instance.create_time > '2016-03-17 00:00:00' and job_instance.create_user_name like 'Token_%' and job_instance.create_user_name = concat('Token_', token.id); " > virgo_static_token_name