SELECT	`revenue_level`,`total_loan_cnt`,`days_of_loan`,`if_car_flag`,`if_house_flag`,`localization` FROM cus_indiv LIMIT 1;
SELECT	`revenue_level`,`total_loan_cnt`,`days_of_loan`,`if_car_flag`,`if_house_flag`,`localization`,`finally_int` ,`json_address` FROM lmt_cus_indiv LIMIT 1;
SELECT	`cert_type`,`cert_no`,`float_rate`,ext_app_no FROM lmt_crdt_app LIMIT 1;
SELECT	`consume_time`,`ret_code`,`ret_msg`,`is_success`,`glob_seq_num` FROM biz_open_tran_log LIMIT 1;
SELECT	`cont_content`,cont_no FROM ctr_loan_cont LIMIT 1;
SELECT	ext_app_no,cont_no FROM pay_credit_app LIMIT 1;
SELECT	ext_app_no FROM pay_credit_app LIMIT 1;
SELECT	ext_app_no FROM lmt_crdt_apply_report LIMIT 1;
SELECT	com_name FROM cus_ind_work LIMIT 1;
SELECT	ext_app_no,`tran_no` FROM biz_tran_record  LIMIT 1;
SELECT	ext_app_no FROM pay_payout_app  LIMIT 1;
SELECT	biz_key FROM bam_file_store  LIMIT 1;
SELECT	status FROM fac_loan_repay_plan  LIMIT 1;
SELECT	bef_status FROM pls_repay_plan_detail  LIMIT 1;

select * from biz_dxm_request_info limit 1;
select * from biz_account_bdcollate limit 1;
select * from rec_bdfile_loan_tmp limit 1;
select * from rec_bdfile_repay_plan_tmp limit 1;
select * from rec_bdfile_open_tmp limit 1;
select * from rec_bdfile_repay_tmp limit 1;
select * from rec_bdfile_repay_item_tmp limit 1;
select * from rec_bdfile_reduce_tmp limit 1;
select * from rec_bdfile_loan_rate_tmp limit 1;
select * from rec_bdfile_ledger_tmp limit 1;
select * from rec_bdfile_flow_tmp limit 1;
select * from rec_bdfile_transfertxt_tmp limit 1;
select * from rec_bdfile_transfermoney_tmp limit 1;
select * from rec_bdfile_loan_his limit 1;
select * from rec_bdfile_repay_plan_his limit 1;
select * from rec_bdfile_open_his limit 1;
select * from rec_bdfile_repay_his limit 1;
select * from rec_bdfile_repay_item_his limit 1;
select * from rec_bdfile_reduce_his limit 1;
select * from rec_bdfile_loan_rate_his limit 1;
select * from rec_bdfile_ledger_his limit 1;
select * from rec_bdfile_flow_his limit 1;
select * from rec_bdfile_transfertxt_his limit 1;
select * from rec_bdfile_transfermoney_his limit 1;
select * from lmt_dxm_ext_used_lmt limit 1;
select * from lmt_dxm_ext_used_lmt_his limit 1;
select * from lmt_dxm_ext_used_biz_rel limit 1;
select * from biz_accounting_config limit 1;
select * from biz_accounting_record limit 1;
select * from biz_accounting_detail limit 1;
select * from lmt_recovery_notice limit 1;
select * from biz_dxm_benefit_detail limit 1;
select * from biz_dxm_benefit_config limit 1;
select * from biz_dxm_benefit_record limit 1;

SELECT case when count(id) = 10 then '成功' else '失败' end as isInsert ,count(1) FROM biz_tran_config  WHERE id IN ( 600712063760728064, 600712367566749696, 600712664942903296, 600712774561038336, 600712850326945792, 600712917129625600, 601786897747935232, 600769981558292480, 609813082360774656, 607145376406831104 );
SELECT case when count(id) = 1 then '成功' else '失败' end as isInsert,count(1) FROM biz_cont_tmpl_app  WHERE id = 606560514046164992 ;
SELECT case when count(id) = 1 then '成功' else '失败' end as isInsert,count(1) FROM biz_cont_tmpl  WHERE id = 606560514046164993 ;
SELECT case when count(id) = 1 then '成功' else '失败' end as isInsert,count(1) FROM biz_cont_signer_config WHERE id =  606560845677203456;
SELECT case when count(id) = 1 then '成功' else '失败' end as isInsert,count(1) FROM prd_agr_tmpl_ref WHERE id =  609051007220973568;
SELECT case when count(id) = 3 then '成功' else '失败' end as isInsert ,count(1) FROM sys_select  WHERE id IN ( 20606801761113473024, 20606626246939377664, 20606556186694647808);
SELECT case when count(id) = 13 then '成功' else '失败' end as isInsert ,count(1) FROM sys_option  WHERE id IN ( 20606556279250354176,20606802016336871424,20606562939482144768,20606563034940309504,20606563924346667008,20606563603562102784,20606563728904683520,20606563829513453568,20606564133894094848,20607618876766683136,20607618585824591872,20607618801697030144,20606626320704602112);
SELECT case when count(id) = 2 then '成功' else '失败' end as isInsert ,count(1) FROM bam_file_group WHERE id IN ( 606561981637328896,606562352581574656);
SELECT case when count(id) = 4 then '成功' else '失败' end as isInsert ,count(1) FROM bam_file_grp_detail WHERE id IN ( 606561981645717504,606561981662494720,606561981675077632, 606561981687660544,606562352594157568);
SELECT case when count(id) = 1 then '成功' else '失败' end as isInsert ,count(1) FROM biz_coop_config WHERE id =596707058078711808 ;
SELECT case when count(id) = 1 then '成功' else '失败' end as isInsert ,count(1) FROM biz_coop_prd_config WHERE id =567745039841624065 ;
SELECT case when count(id) = 2 then '成功' else '失败' end as isInsert ,count(1) FROM biz_coop_sftp_config WHERE id IN (3,5) ;
SELECT case when count(id) = 7 then '成功' else '失败' end as isInsert ,count(1) FROM biz_return_code_map  WHERE id IN (31,32,33,35,34,36,37) ;
SELECT  case when count(id) = 1 then '成功' else '失败' end as isInsert ,count(1) FROM sys_option   WHERE `option_txt` = 'ZXCXSQZLGR' and id = 20563677719066312704;
SELECT  case when count(id) = 1 then '成功' else '失败' end as isInsert ,count(1) FROM sys_option   WHERE `option_txt` = 'ZXCXSQZLGR01' and id = 20563679633468293120;
SELECT  case when count(id) = 1 then '成功' else '失败' end as isInsert ,count(1) FROM sys_option   WHERE `option_txt` = 'ZXCXSQZLGR01' and id = 20577859915561828352;
SELECT  case when count(id) = 1 then '成功' else '失败' end as isInsert ,count(1) FROM sys_option   WHERE `option_txt` = 'ZXCXSQZLGR01' and id = 20577859968972095488;
SELECT  case when count(id) = 1 then '成功' else '失败' end as isInsert ,count(1) FROM sys_option   WHERE `option_txt` = 'ZXCXSQZLGR05' and id = 20563679105631911936;
SELECT  case when count(id) = 1 then '成功' else '失败' end as isInsert ,count(1) FROM sys_option   WHERE `option_txt` = 'ZXCXSQZLGR05' and id = 20563679256396169216;
SELECT  case when count(id) = 1 then '成功' else '失败' end as isInsert ,count(1) FROM sys_option   WHERE `option_txt` = 'ZXCXSQZLGR04' and id = 20563679369168420864;
SELECT  case when count(id) = 1 then '成功' else '失败' end as isInsert ,count(1) FROM sys_option   WHERE `option_txt` = 'ZXCXSQZLGR04' and id = 20576780695729340416;
SELECT case when count(id) = 129 then '成功' else '失败' end as isInsert ,count(1) FROM biz_accounting_config;
