TYPE=VIEW
query=select `a`.`acc_no` AS `acc_no`,`a`.`bal` AS `bal`,`a`.`head` AS `head`,`j`.`mobile` AS `mobile` from (`co-operativebank-198`.`acc_bal` `a` join `co-operativebank-198`.`j_a` `j`) where (`a`.`acc_no` = `j`.`Acc_No`)
md5=37678841ce0d977e3d936c76df43bba5
updatable=0
algorithm=0
definer_user=root
definer_host=localhost
suid=1
with_check_option=0
timestamp=2022-07-28 05:49:24
create-version=1
source=select  `a`.`acc_no`  AS  `acc_no` ,\n `a`.`bal`  AS  `bal` ,\n `a`.`head`  AS  `head` ,\n `j`.`mobile`  AS  `mobile`  from (  `co-operativebank-198`.`acc_bal`  `a`  join  `co-operativebank-198`.`j_a`  `j`  ) where (  `a`.`acc_no`  =  `j`.`Acc_No`  )
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `a`.`acc_no` AS `acc_no`,`a`.`bal` AS `bal`,`a`.`head` AS `head`,`j`.`mobile` AS `mobile` from (`co-operativebank-198`.`acc_bal` `a` join `co-operativebank-198`.`j_a` `j`) where (`a`.`acc_no` = `j`.`Acc_No`)
