TYPE=TRIGGERS
triggers='CREATE DEFINER=`root`@`localhost` TRIGGER `share_quickname_del` BEFORE DELETE ON `shares`
\n FOR EACH ROW DELETE hv.* FROM `quick_name` hv,shares v WHERE v.code=hv.acc_no and v.code=old.code' 'CREATE DEFINER=`root`@`localhost` TRIGGER `share_quick_name` AFTER INSERT ON `shares` FOR EACH ROW INSERT INTO `quick_name`(`acc_no`, `name`,sbacc,lfno)
\nselect `d`.`code` AS `code`,concat(`a`.`fname`,\' \',`a`.`mname`,\' \',`a`.`lname`) AS `name`,d.acc_no,d.lf_no from (`shares` `d` join `applicant` `a`) where (`d`.`acc_no` = `a`.`Acc_No`) and d.no=new.no group by `a`.`Acc_No`'
sql_modes=1073741824 1073741824
definers='root@localhost' 'root@localhost'
client_cs_names='utf8' 'utf8'
connection_cl_names='utf8_general_ci' 'utf8_general_ci'
db_cl_names='latin1_swedish_ci' 'latin1_swedish_ci'
