56 lines
3.5 KiB
SQL
56 lines
3.5 KiB
SQL
SELECT `three_ele_auth_sign`,`three_ele_auth_fail_reason`,`ocr_reco_sign`,`ocr_reco_fail_reason` FROM lmt_crdt_app LIMIT 1;
|
|
|
|
SELECT case when count(*) = 63 then '成功' else '失败' end as isInsert,count(1) FROM cfg_ip;
|
|
|
|
|
|
|
|
SELECT case when count(id) = 1 then '成功' else '失败' end as isInsert,count(1) FROM biz_coop_sftp_config WHERE id = 9 ;
|
|
SELECT case when count(id) = 1 then '成功' else '失败' end as isInsert,count(1) FROM bam_file_group WHERE id = 628164642547433472 ;
|
|
SELECT case when count(id) = 1 then '成功' else '失败' end as isInsert,count(1) FROM bam_file_grp_detail WHERE id IN (628165320317599744,628165320325988352,628165320338571264,628165320351154176,628165320359542784,628165320376320000);
|
|
SELECT case when count(id) = 1 then '成功' else '失败' end as isInsert,count(1) FROM biz_tran_config WHERE id IN (627899772220473344,627901023465242624);
|
|
SELECT case when count(id) = 1 then '成功' else '失败' end as isInsert,count(1) FROM sys_option WHERE id = 20630408757272117248;
|
|
SELECT case when count(id) = 1 then '成功' else '失败' end as isInsert,count(1) FROM sys_option WHERE id IN (20630409175532306432,20630409408450396160,20630409584573415424,20630410047301615616,20630410427523661824,20630410595945938944);
|
|
SELECT case when count(id) = 1 then '成功' else '失败' end as isInsert,count(1) FROM sys_option WHERE id = 20630415264059490304;
|
|
SELECT case when count(id) = 1 then '成功' else '失败' end as isInsert,count(1) FROM biz_coop_config WHERE id = 628269218256650240;
|
|
|
|
|
|
|
|
|
|
-- 自动代偿信息表新增字段：代偿类型
|
|
SELECT `compensatory_method` FROM `rec_loan`.`rec_ln_acct_automatic_compensation` LIMIT 1;
|
|
|
|
-- 贷款还款历史表新增字段：登记日期
|
|
SELECT `create_date` FROM `rec_loan`.`rec_ln_acct_repayment_mmdd_add` LIMIT 1;
|
|
-- 贷款还款历史表新增字段：登记时间戳
|
|
SELECT `create_time` FROM `rec_loan`.`rec_ln_acct_repayment_mmdd_add` LIMIT 1;
|
|
|
|
-- 贷款还款计划表新增字段：登记日期
|
|
SELECT `create_date` FROM `rec_loan`.`rec_ln_acct_repay_plan_add` LIMIT 1;
|
|
-- 贷款还款计划表新增字段：登记时间戳
|
|
SELECT `create_time` FROM `rec_loan`.`rec_ln_acct_repay_plan_add` LIMIT 1;
|
|
|
|
|
|
|
|
|
|
-- 影像平台根节点映射
|
|
SELECT case when count(id) = 1 then '成功' else '失败' end as isInsert,count(1) FROM `rec_loan`.`sys_option` WHERE id = '20632535682379677696' ;
|
|
|
|
-- 影像平台子节点映射
|
|
SELECT case when count(id) = 1 then '成功' else '失败' end as isInsert,count(1) FROM `rec_loan`.`sys_option` WHERE id = '20632536829622484992' ;
|
|
|
|
-- 影像平台上传配置
|
|
SELECT case when count(id) = 1 then '成功' else '失败' end as isInsert,count(1) FROM `rec_loan`.`sys_option` WHERE id = '20632537364559822848' ;
|
|
|
|
-- 影像配置
|
|
SELECT case when count(id) = 1 then '成功' else '失败' end as isInsert,count(1) FROM `rec_loan`.`bam_file_group` WHERE id = '632533329295441920' ;
|
|
|
|
SELECT case when count(id) = 1 then '成功' else '失败' end as isInsert,count(1) FROM `rec_loan`.`bam_file_grp_detail` WHERE id = '632533543163002880' ;
|
|
|
|
|
|
-- 组件配置
|
|
|
|
SELECT case when count(id) = 1 then '成功' else '失败' end as isInsert,count(1) FROM `rec_loan`.`biz_tran_config` WHERE id = '629280659965214720' ;
|
|
|
|
SELECT case when count(id) = 1 then '成功' else '失败' end as isInsert,count(1) FROM `rec_loan`.`biz_tran_config` WHERE id = '628656396199526400' ;
|
|
|
|
SELECT case when count(id) = 1 then '成功' else '失败' end as isInsert,count(1) FROM `rec_loan`.`biz_tran_config` WHERE id = '628655883370364928' ; |