30 lines
3.3 KiB
MySQL
30 lines
3.3 KiB
MySQL
|
SELECT `img_no`,`ip_addr` FROM lmt_crdt_app LIMIT 1;
|
||
|
|
SELECT `ip_addr` FROM pay_credit_app LIMIT 1;
|
||
|
|
SELECT `ip_addr` FROM pls_repay_result LIMIT 1;
|
||
|
|
SELECT `banlance_req_data`,`banlance_resp_data` FROM PAY_PAYOUT_EXP LIMIT 1;
|
||
|
|
SELECT `curr_repayed_new_ont`,`repayed_total_new_ont` FROM rec_ln_acct_repayment_mmdd_add LIMIT 1;
|
||
|
|
|
||
|
|
SELECT case when count(id) = 1 then '成功' else '失败' end as isInsert ,count(1) FROM sys_select WHERE id =20605121920190382080;
|
||
|
|
SELECT case when count(id) = 1 then '成功' else '失败' end as isInsert ,count(1) FROM sys_select WHERE id =20617767169484128256;
|
||
|
|
SELECT case when count(id) = 1 then '成功' else '失败' end as isInsert ,count(1) FROM sys_option WHERE id = 20601878931649331200;
|
||
|
|
SELECT case when count(id) = 1 then '成功' else '失败' end as isInsert ,count(1) FROM sys_option WHERE id = 20605122089719955456;
|
||
|
|
SELECT case when count(id) = 1 then '成功' else '失败' end as isInsert ,count(1) FROM sys_option WHERE id = 20608251604038057984;
|
||
|
|
SELECT case when count(id) = 1 then '成功' else '失败' end as isInsert ,count(1) FROM sys_option WHERE id = 20617767410069405696;
|
||
|
|
SELECT case when count(id) = 1 then '成功' else '失败' end as isInsert ,count(1) FROM sys_option WHERE id = 20617767445360279552;
|
||
|
|
SELECT case when count(id) = 1 then '成功' else '失败' end as isInsert ,count(1) FROM sys_option WHERE id = 20617767478403006464;
|
||
|
|
SELECT case when count(id) = 1 then '成功' else '失败' end as isInsert ,count(1) FROM biz_cont_tmpl WHERE id = 601881080055726081;
|
||
|
|
SELECT case when count(id) = 1 then '成功' else '失败' end as isInsert ,count(1) FROM biz_cont_signer_config WHERE id = 601881287543754752;
|
||
|
|
SELECT case when count(id) = 4 then '成功' else '失败' end as isInsert ,count(1) FROM prd_tree WHERE id IN ( 607226528266190848,607226666179100672,607226750308450304,607226793316843520);
|
||
|
|
SELECT case when count(id) = 1 then '成功' else '失败' end as isInsert ,count(1) FROM prd_agr_tmpl_ref WHERE id = 605120770548432896;
|
||
|
|
SELECT case when count(id) = 1 then '成功' else '失败' end as isInsert ,count(1) FROM bam_file_type WHERE id = 602632044404539392;
|
||
|
|
SELECT case when count(id) = 1 then '成功' else '失败' end as isInsert ,count(1) FROM bam_file_grp_detail WHERE id = 605134236164292608;
|
||
|
|
SELECT case when count(id) = 1 then '成功' else '失败' end as isInsert ,count(1) FROM biz_tran_config WHERE id = 555760399664807936;
|
||
|
|
SELECT case when count(id) = 1 then '成功' else '失败' end as isInsert ,count(1) FROM biz_tran_config WHERE id = 554044044053839872;
|
||
|
|
SELECT case when count(id) = 1 then '成功' else '失败' end as isInsert ,count(1) FROM biz_tran_config WHERE id = 611715876357406720;
|
||
|
|
SELECT case when count(id) = 1 then '成功' else '失败' end as isInsert ,count(1) FROM biz_coop_sftp_config WHERE id = 6;
|
||
|
|
SELECT case when count(id) = 0 then '成功' else '失败' end as isInsert ,count(1) FROM prd_tree WHERE id = 572445918519885824;
|
||
|
|
SELECT case when count(id) = 0 then '成功' else '失败' end as isInsert ,count(1) FROM prd_tree WHERE id = 572446008655478784;
|
||
|
|
SELECT case when is_empty = '0' then '成功' else '失败' end as isInsert ,count(1) FROM prd_tree WHERE id = 572372918386819072;
|
||
|
|
SELECT case when is_empty = '0' then '成功' else '失败' end as isInsert ,count(1) FROM prd_tree WHERE id = 572373225942548480;
|
||
|
|
|