TYPE=VIEW
query=select `d`.`acc_no` AS `acc_no`,sum(`d`.`amt`) AS `amt`,`d`.`fd_sv_acc_no` AS `fd_sv_acc_no` from `co-operativebank-henria`.`deposit_acc` `d` where ((`d`.`acc_type` = \'fd\') and (`d`.`status` = \'Active\')) group by `d`.`fd_sv_acc_no`
md5=a8371cb395327269729d47be8c06b1fc
updatable=0
algorithm=0
definer_user=root
definer_host=localhost
suid=1
with_check_option=0
timestamp=2021-07-15 17:05:45
create-version=1
source=select  `d`.`acc_no`  AS  `acc_no` ,\nsum(  `d`.`amt`  )  AS  `amt` ,\n `d`.`fd_sv_acc_no`  AS  `fd_sv_acc_no`  from  `co-operativebank-henria`.`deposit_acc`  `d`  where ( (  `d`.`acc_type`  =  \'fd\' ) and (  `d`.`status`  =  \'Active\' ) ) group  by  `d`.`fd_sv_acc_no`
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `d`.`acc_no` AS `acc_no`,sum(`d`.`amt`) AS `amt`,`d`.`fd_sv_acc_no` AS `fd_sv_acc_no` from `co-operativebank-henria`.`deposit_acc` `d` where ((`d`.`acc_type` = \'fd\') and (`d`.`status` = \'Active\')) group by `d`.`fd_sv_acc_no`
