TYPE=VIEW
query=select `co-operativebank-mitrachak`.`applicant`.`no` AS `no`,`co-operativebank-mitrachak`.`applicant`.`code` AS `code`,`co-operativebank-mitrachak`.`applicant`.`initial` AS `initial`,`co-operativebank-mitrachak`.`applicant`.`fname` AS `fname`,`co-operativebank-mitrachak`.`applicant`.`mname` AS `mname`,`co-operativebank-mitrachak`.`applicant`.`lname` AS `lname`,`co-operativebank-mitrachak`.`applicant`.`father_name` AS `father_name`,`co-operativebank-mitrachak`.`applicant`.`gender` AS `gender`,`co-operativebank-mitrachak`.`applicant`.`dob` AS `dob`,`co-operativebank-mitrachak`.`applicant`.`address` AS `address`,`co-operativebank-mitrachak`.`applicant`.`city` AS `city`,`co-operativebank-mitrachak`.`applicant`.`state` AS `state`,`co-operativebank-mitrachak`.`applicant`.`pin` AS `pin`,`co-operativebank-mitrachak`.`applicant`.`mobile` AS `mobile`,`co-operativebank-mitrachak`.`applicant`.`pan` AS `pan`,`co-operativebank-mitrachak`.`applicant`.`adhar` AS `adhar`,`co-operativebank-mitrachak`.`applicant`.`voter` AS `voter`,`co-operativebank-mitrachak`.`applicant`.`occupation` AS `occupation`,`co-operativebank-mitrachak`.`applicant`.`income` AS `income`,`co-operativebank-mitrachak`.`applicant`.`verify` AS `verify`,`co-operativebank-mitrachak`.`applicant`.`Acc_No` AS `Acc_No` from `co-operativebank-mitrachak`.`applicant` group by `co-operativebank-mitrachak`.`applicant`.`Acc_No`
md5=929e2024f05843d311102fd9a37305a6
updatable=0
algorithm=0
definer_user=root
definer_host=localhost
suid=2
with_check_option=0
timestamp=2024-04-01 05:49:41
create-version=1
source=select `applicant`.`no` AS `no`,`applicant`.`code` AS `code`,`applicant`.`initial` AS `initial`,`applicant`.`fname` AS `fname`,`applicant`.`mname` AS `mname`,`applicant`.`lname` AS `lname`,`applicant`.`father_name` AS `father_name`,`applicant`.`gender` AS `gender`,`applicant`.`dob` AS `dob`,`applicant`.`address` AS `address`,`applicant`.`city` AS `city`,`applicant`.`state` AS `state`,`applicant`.`pin` AS `pin`,`applicant`.`mobile` AS `mobile`,`applicant`.`pan` AS `pan`,`applicant`.`adhar` AS `adhar`,`applicant`.`voter` AS `voter`,`applicant`.`occupation` AS `occupation`,`applicant`.`income` AS `income`,`applicant`.`verify` AS `verify`,`applicant`.`Acc_No` AS `Acc_No` from `applicant` group by acc_no
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `co-operativebank-mitrachak`.`applicant`.`no` AS `no`,`co-operativebank-mitrachak`.`applicant`.`code` AS `code`,`co-operativebank-mitrachak`.`applicant`.`initial` AS `initial`,`co-operativebank-mitrachak`.`applicant`.`fname` AS `fname`,`co-operativebank-mitrachak`.`applicant`.`mname` AS `mname`,`co-operativebank-mitrachak`.`applicant`.`lname` AS `lname`,`co-operativebank-mitrachak`.`applicant`.`father_name` AS `father_name`,`co-operativebank-mitrachak`.`applicant`.`gender` AS `gender`,`co-operativebank-mitrachak`.`applicant`.`dob` AS `dob`,`co-operativebank-mitrachak`.`applicant`.`address` AS `address`,`co-operativebank-mitrachak`.`applicant`.`city` AS `city`,`co-operativebank-mitrachak`.`applicant`.`state` AS `state`,`co-operativebank-mitrachak`.`applicant`.`pin` AS `pin`,`co-operativebank-mitrachak`.`applicant`.`mobile` AS `mobile`,`co-operativebank-mitrachak`.`applicant`.`pan` AS `pan`,`co-operativebank-mitrachak`.`applicant`.`adhar` AS `adhar`,`co-operativebank-mitrachak`.`applicant`.`voter` AS `voter`,`co-operativebank-mitrachak`.`applicant`.`occupation` AS `occupation`,`co-operativebank-mitrachak`.`applicant`.`income` AS `income`,`co-operativebank-mitrachak`.`applicant`.`verify` AS `verify`,`co-operativebank-mitrachak`.`applicant`.`Acc_No` AS `Acc_No` from `co-operativebank-mitrachak`.`applicant` group by `co-operativebank-mitrachak`.`applicant`.`Acc_No`
