TYPE=VIEW
query=select `v`.`member_id` AS `member_id`,`v`.`acc_no` AS `acc_no`,`v`.`name` AS `name`,`v`.`address` AS `address`,`v`.`city` AS `city`,`v`.`state` AS `state`,`v`.`pin` AS `pin`,`v`.`relation` AS `relation`,`v`.`dob` AS `dob`,`v`.`id` AS `id`,`v`.`sv_acc` AS `sv_acc`,`v`.`aadharcard_no` AS `aadharcard_no` from `co-operativebank-144`.`nominee` `v` where ((`v`.`sv_acc` = \'\') and (not(exists(select 1 from `co-operativebank-144`.`deposit_acc` `d` where (`v`.`acc_no` = `d`.`acc_no`)))))
md5=99bd8f72b6c2ce1aa5673c5adab209ca
updatable=1
algorithm=0
definer_user=root
definer_host=localhost
suid=1
with_check_option=0
timestamp=2023-02-08 10:58:45
create-version=1
source=select  `v`.`member_id`  AS  `member_id` ,\n `v`.`acc_no`  AS  `acc_no` ,\n `v`.`name`  AS  `name` ,\n `v`.`address`  AS  `address` ,\n `v`.`city`  AS  `city` ,\n `v`.`state`  AS  `state` ,\n `v`.`pin`  AS  `pin` ,\n `v`.`relation`  AS  `relation` ,\n `v`.`dob`  AS  `dob` ,\n `v`.`id`  AS  `id` ,\n `v`.`sv_acc`  AS  `sv_acc` ,\n `v`.`aadharcard_no`  AS  `aadharcard_no`  from  `co-operativebank-144`.`nominee`  `v`  where ( (  `v`.`sv_acc`  =  \'\' ) and (  not (  exists (  select 1  from  `co-operativebank-144`.`deposit_acc`  `d`  where (  `v`.`acc_no`  =  `d`.`acc_no`  ) ) ) ) )
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `v`.`member_id` AS `member_id`,`v`.`acc_no` AS `acc_no`,`v`.`name` AS `name`,`v`.`address` AS `address`,`v`.`city` AS `city`,`v`.`state` AS `state`,`v`.`pin` AS `pin`,`v`.`relation` AS `relation`,`v`.`dob` AS `dob`,`v`.`id` AS `id`,`v`.`sv_acc` AS `sv_acc`,`v`.`aadharcard_no` AS `aadharcard_no` from `co-operativebank-144`.`nominee` `v` where ((`v`.`sv_acc` = \'\') and (not(exists(select 1 from `co-operativebank-144`.`deposit_acc` `d` where (`v`.`acc_no` = `d`.`acc_no`)))))
