TYPE=VIEW
query=select `gl_opex`.`SHCODE` AS `SHCODE`,sum(`gl_opex`.`BAL`) AS `bal`,`gl_opex`.`hcode` AS `hcode` from `co-operativebank-244`.`gl_opex` group by `gl_opex`.`SHCODE`
md5=9e7344aa3973befd4cf0a9e48837cf07
updatable=0
algorithm=0
definer_user=root
definer_host=localhost
suid=1
with_check_option=0
timestamp=2025-11-19 04:30:08
create-version=1
source=select  `gl_opex`.`SHCODE`  AS  `SHCODE` ,\nsum(  `gl_opex`.`BAL`  )  AS  `bal` ,\n `gl_opex`.`hcode`  AS  `hcode`  from  `co-operativebank-244`.`gl_opex`  group  by  `gl_opex`.`SHCODE`
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `gl_opex`.`SHCODE` AS `SHCODE`,sum(`gl_opex`.`BAL`) AS `bal`,`gl_opex`.`hcode` AS `hcode` from `co-operativebank-244`.`gl_opex` group by `gl_opex`.`SHCODE`
