能查的：
不能查的：
表结构：
– tq_finance_test.loan_give_apply_bill definition
CREATE TABLE loan_give_apply_bill (
id bigint(20) NOT NULL,
create_time datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT ‘创建时间’,
update_time datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT ‘更新时间’,
loan_out_subject_id bigint(20) NOT NULL COMMENT ‘贷出方主体id’,
loan_out_subject_name varchar(64) NOT NULL COMMENT ‘贷出方主体名称’,
loan_in_subject_id bigint(20) NOT NULL COMMENT ‘贷入方主体id’,
loan_in_subject_name varchar(64) NOT NULL COMMENT ‘贷入方主体名称’,
loan_amount bigint(20) NOT NULL DEFAULT ‘0’ COMMENT ‘贷款金额’,
loan_date date NOT NULL DEFAULT (CURRENT_DATE) COMMENT ‘贷款日期’,
expire_date date NOT NULL DEFAULT (CURRENT_DATE) COMMENT ‘到期日期’,
bill_status varchar(12) NOT NULL COMMENT ‘申请单状态’,
has_give tinyint(4) NOT NULL DEFAULT ‘0’ COMMENT ‘是否已放款’,
creator_id bigint(20) NOT NULL COMMENT ‘创建人id’,
creator_name varchar(12) NOT NULL COMMENT ‘创建人名称’,
oa_no varchar(32) NOT NULL COMMENT ‘oa流水号’,
bank_account varchar(32) NOT NULL COMMENT ‘银行账号’,
refund_way varchar(12) NOT NULL COMMENT ‘还款方式’,
loan_rate bigint(20) NOT NULL COMMENT ‘贷款利率’,
expect_give_date date NOT NULL COMMENT ‘预计放款日期’,
apply_reason varchar(512) NOT NULL COMMENT ‘申请理由’,
attach_url text NOT NULL COMMENT ‘附件’,
item text NOT NULL COMMENT ‘子项’,
approve_date date NOT NULL DEFAULT (CURRENT_DATE),
approve_remark varchar(125) NOT NULL DEFAULT ‘’ COMMENT ‘审批意见，失败的时候有’,
approve_user varchar(24) NOT NULL DEFAULT ‘’ COMMENT ‘审批人’,
register_give_user_id bigint(20) NOT NULL DEFAULT ‘0’ COMMENT ‘登记放款人id’,
register_give_user_name varchar(24) NOT NULL DEFAULT ‘’ COMMENT ‘登记放款人名称’,
register_give_remark varchar(125) NOT NULL DEFAULT ‘’ COMMENT ‘登记放款人备注’,
register_give_attach text NOT NULL COMMENT ‘登记放款人附件’,
refund_amount bigint(20) NOT NULL DEFAULT ‘0’ COMMENT ‘已还款金额’,
refund_clear_date date NOT NULL DEFAULT (CURRENT_DATE) COMMENT ‘贷款还清日期’,
refund_clear tinyint(4) NOT NULL DEFAULT ‘0’ COMMENT ‘贷款是否还清’,
use_allot text NOT NULL COMMENT ‘贷后信息，使用分配’,
use_allot_attach text NOT NULL COMMENT ‘贷后信息，使用分配附件’,
PRIMARY KEY (id) /*T![clustered_index] CLUSTERED */
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT=‘贷款发放申请单’;
另外，我可以提供远程连接你们可以自行查看问题
没有其他作业在清数据或者改数据吧？按其他条件能查出来0803这一条么？
