Ph.D. Scholar Details.

Login
Username	:
Password	:
Note: Excel file with fields `rollno`, `name`, `reg_date`, `submit_date`, `dob`, `pwd`, `guide`, `dept`, `mobile`; copy dob field into notepad and replace hypen with no space; use annamala_std db; import excel as default table eg. TABLE 142; insert into phd_scholar(`rollno`, `name`, `reg_date`, `submit_date`, `dob`, `pwd`, `guide`, `dept`, `mobile`) SELECT `rollno`, `name`, `reg_date`, `submit_date`, `dob`, `pwd`, `guide`, `dept`, `mobile` FROM `TABLE 141`; delete from user; insert into user(`username`, `name`, `dob`, `pwd`, `guide`, `dept`, `mobile`) SELECT `rollno`, `name`, `dob`, `pwd`, `guide`, `dept`, `mobile` FROM `TABLE 141`; UPDATE `user` set `md5_pw`=md5(pwd);