TYPE=VIEW
query=select `gl_opex`.`SHCODE` AS `SHCODE`,sum(`gl_opex`.`BAL`) AS `bal`,`gl_opex`.`hcode` AS `hcode` from `co-operativebank-bajbajia`.`gl_opex` group by `gl_opex`.`SHCODE`
md5=6272838e3d10b79372ac32014676894e
updatable=0
algorithm=0
definer_user=root
definer_host=localhost
suid=2
with_check_option=0
timestamp=2022-11-22 12:47:55
create-version=1
source=SELECT `SHCODE`,sum(`BAL`) as bal,`hcode` FROM `gl_opex` group by 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-bajbajia`.`gl_opex` group by `gl_opex`.`SHCODE`
