TYPE=VIEW
query=select concat(`a`.`initial`,\' \',`a`.`fname`,\' \',`a`.`mname`,\' \',`a`.`lname`) AS `name`,`a`.`mobile` AS `mobile`,`a`.`email` AS `email`,`a`.`address` AS `address`,`a`.`adhar` AS `adhar`,`a`.`pan` AS `pan` from (`co-operativebank-243`.`applicant` `a` join `co-operativebank-243`.`deposit_acc` `d`) where ((`d`.`acc_no` = `a`.`Acc_No`) and (`d`.`acc_type` = \'sv\') and (`a`.`mobile` <> \'\')) group by `a`.`Acc_No`
md5=f758aa86c3b1bbf6ed0fc04d0d76ed50
updatable=0
algorithm=0
definer_user=root
definer_host=localhost
suid=1
with_check_option=0
timestamp=2025-09-15 05:27:56
create-version=1
source=select concat(  `a`.`initial` ,  \' \',  `a`.`fname` ,  \' \',  `a`.`mname` ,  \' \',  `a`.`lname`  )  AS  `name` ,\n `a`.`mobile`  AS  `mobile` ,\n `a`.`email`  AS  `email` ,\n `a`.`address`  AS  `address` ,\n `a`.`adhar`  AS  `adhar` ,\n `a`.`pan`  AS  `pan`  from (  `co-operativebank-243`.`applicant`  `a`  join  `co-operativebank-243`.`deposit_acc`  `d`  ) where ( (  `d`.`acc_no`  =  `a`.`Acc_No`  ) and (  `d`.`acc_type`  =  \'sv\' ) and (  `a`.`mobile`  <>  \'\' ) ) group  by  `a`.`Acc_No`
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select concat(`a`.`initial`,\' \',`a`.`fname`,\' \',`a`.`mname`,\' \',`a`.`lname`) AS `name`,`a`.`mobile` AS `mobile`,`a`.`email` AS `email`,`a`.`address` AS `address`,`a`.`adhar` AS `adhar`,`a`.`pan` AS `pan` from (`co-operativebank-243`.`applicant` `a` join `co-operativebank-243`.`deposit_acc` `d`) where ((`d`.`acc_no` = `a`.`Acc_No`) and (`d`.`acc_type` = \'sv\') and (`a`.`mobile` <> \'\')) group by `a`.`Acc_No`
