TYPE=VIEW
query=select `gl_ope_v`.`SHCODE` AS `SHCODE`,sum(`gl_ope_v`.`BAL`) AS `bal`,`gl_ope_v`.`hcode` AS `hcode`,sum(`gl_ope_v`.`cr`) AS `cr`,sum(`gl_ope_v`.`dr`) AS `dr` from `co-operativebank-milani`.`gl_ope_v` group by `gl_ope_v`.`SHCODE`
md5=5e8d9e06c15a98813080a6da653b5a50
updatable=0
algorithm=0
definer_user=admin
definer_host=localhost
suid=2
with_check_option=0
timestamp=2026-02-17 13:12:33
create-version=1
source=SELECT `SHCODE`,sum(`BAL`) as bal,`hcode`,sum(cr) as cr,sum(dr) as dr FROM `GL_OPE_v` group by shcode
client_cs_name=utf8mb4
connection_cl_name=utf8mb4_general_ci
view_body_utf8=select `gl_ope_v`.`SHCODE` AS `SHCODE`,sum(`gl_ope_v`.`BAL`) AS `bal`,`gl_ope_v`.`hcode` AS `hcode`,sum(`gl_ope_v`.`cr`) AS `cr`,sum(`gl_ope_v`.`dr`) AS `dr` from `co-operativebank-milani`.`gl_ope_v` group by `gl_ope_v`.`SHCODE`
