TYPE=VIEW
query=select `co-operativebank`.`applicant`.`no` AS `no`,`co-operativebank`.`applicant`.`code` AS `code`,`co-operativebank`.`applicant`.`initial` AS `initial`,`co-operativebank`.`applicant`.`fname` AS `fname`,`co-operativebank`.`applicant`.`mname` AS `mname`,`co-operativebank`.`applicant`.`lname` AS `lname`,`co-operativebank`.`applicant`.`father_name` AS `father_name`,`co-operativebank`.`applicant`.`gender` AS `gender`,`co-operativebank`.`applicant`.`dob` AS `dob`,`co-operativebank`.`applicant`.`address` AS `address`,`co-operativebank`.`applicant`.`city` AS `city`,`co-operativebank`.`applicant`.`state` AS `state`,`co-operativebank`.`applicant`.`pin` AS `pin`,`co-operativebank`.`applicant`.`mobile` AS `mobile`,`co-operativebank`.`applicant`.`pan` AS `pan`,`co-operativebank`.`applicant`.`adhar` AS `adhar`,`co-operativebank`.`applicant`.`voter` AS `voter`,`co-operativebank`.`applicant`.`occupation` AS `occupation`,`co-operativebank`.`applicant`.`income` AS `income`,`co-operativebank`.`applicant`.`verify` AS `verify`,`co-operativebank`.`applicant`.`Acc_No` AS `Acc_No` from `co-operativebank`.`applicant`
md5=a0127e7b9e2b148c072abc62378d1e29
updatable=1
algorithm=0
definer_user=root
definer_host=localhost
suid=1
with_check_option=0
timestamp=2016-04-20 04:10:16
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`
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `co-operativebank`.`applicant`.`no` AS `no`,`co-operativebank`.`applicant`.`code` AS `code`,`co-operativebank`.`applicant`.`initial` AS `initial`,`co-operativebank`.`applicant`.`fname` AS `fname`,`co-operativebank`.`applicant`.`mname` AS `mname`,`co-operativebank`.`applicant`.`lname` AS `lname`,`co-operativebank`.`applicant`.`father_name` AS `father_name`,`co-operativebank`.`applicant`.`gender` AS `gender`,`co-operativebank`.`applicant`.`dob` AS `dob`,`co-operativebank`.`applicant`.`address` AS `address`,`co-operativebank`.`applicant`.`city` AS `city`,`co-operativebank`.`applicant`.`state` AS `state`,`co-operativebank`.`applicant`.`pin` AS `pin`,`co-operativebank`.`applicant`.`mobile` AS `mobile`,`co-operativebank`.`applicant`.`pan` AS `pan`,`co-operativebank`.`applicant`.`adhar` AS `adhar`,`co-operativebank`.`applicant`.`voter` AS `voter`,`co-operativebank`.`applicant`.`occupation` AS `occupation`,`co-operativebank`.`applicant`.`income` AS `income`,`co-operativebank`.`applicant`.`verify` AS `verify`,`co-operativebank`.`applicant`.`Acc_No` AS `Acc_No` from `co-operativebank`.`applicant`
