Drop files here

SQL upload ( 0 ) x-

Server: localhost »Database: hmis »Table: employee_masters
Page-related settingsClick on the bar to scroll to top of page
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse Expand Show trace Hide trace Count: Time taken:
Bookmarks
Refresh
Add
No bookmarks
Add bookmark
xxxxxxxxxx
 
Options
Set default





Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database: Queried time:

Browse mode

Customize browse mode.

Documentation Use only icons, only text or both.
Documentation Use only icons, only text or both.
Documentation Whether a user should be displayed a "show all (rows)" button.
Documentation Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown.
Documentation SMART - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise.
Documentation Highlight row pointed by the mouse cursor.
Documentation Highlight selected rows.
Documentation
Documentation
Documentation Repeat the headers every X cells, 0 deactivates this feature.
Documentation Maximum number of characters shown in any non-numeric column on browse view.
Documentation These are Edit, Copy and Delete links.
Documentation Whether to show row links even in the absence of a unique key.
Documentation Default sort order for tables with a primary key.
Documentation When browsing tables, the sorting of each table is remembered.
Documentation For display Options
Showing rows 0 - 24 (302 total, Query took 0.0218 seconds.)
SELECT * FROM `employee_masters`
SELECT * FROM `employee_masters`

Full texts id empid current_date emp_name dob qualification marital_status a_year a_month a_day gender doj blood_group dol father_sp pf relegion location staff_type department_master_id dept_code dept_desc status desigcode designation_id description house_no street a_location district town state country pin email ph1 ph2 ph3 mob fax pager created_date created_by modified_date modified_by auth min_discount max_discount dis_request req_dis_min req_dis_max cash nippon_emp_id posted_voucher_dis_apr_1 For voucher_discount_approvals form's MD appoval posted_voucher_dis_apr_2 For voucher_discount_approvals form's MD's junior'… locationname biomatric_id
1 000001 08-06-2017 06:16:41 Admin 0000-00-00 Single Male 2014-01-06 A+ 0000-00-00 E 3 IT03 Information Technolo A NULLNULLNULLNULL2014-01-06 12:59:30 1 2017-06-08 00:46:46 1 yes 10.00 100.00 yes 10.00 20.00 no NULLno no AEH
8 000002 06-12-2019 02:42:16 Ramesh Chandra Maurya 1973-06-12 DCH Married 46 7 3 Male 2007-10-28 O+ 0000-00-00 Late Radhey Shyam Maurya Hindu AEH E 3 IT03 Information Technology A ITM09 9 IT Manager Muntaj nagar Mumtaj nagar sohawal Ayodhya 70 4 21 224001 rcmauryahw@gmail.com 9415917910 2017-06-08 07:16:06 NULL2019-12-05 21:12:29 218 yes NULLNULLyes NULLNULLno 2 no no AEH 0
9 000003 10-06-2017 04:24:44 Dr Ashutosh Rastogi 1970-06-08 DO Married 48 1 15 Male 2016-12-02 B+ 2017-12-01 NA Hindu AEH D 4 OPTL04 Opthalmology I SS13 13 Senior Surgeon Na 70 4 21 224001 1111111111 2017-06-08 07:17:56 NULL2017-06-09 22:55:29 1 no NULLNULLno NULLNULLno 3 no no AEH
10 000004 29-10-2019 09:47:04 Dr Vipin Kumar Singh 1984-09-12 Married 35 1 17 Male 2017-06-08 A+ 0000-00-00 NA Hindu AEH D 4 OPTL04 Opthalmology I SS13 4 Senior Surgeon Swargdwar Ram Ki Paidi Nayagha Ayodhya 70 4 21 224123 234207 9415111272 2017-06-08 07:18:12 NULL2019-10-29 04:17:10 2 no NULLNULLno NULLNULLno 4 no no AEH 472
11 000005 26-07-2017 01:31:57 Pawan Kumar Sah 1953-06-08 Married 66 8 11 Male 2009-10-01 AB 0000-00-00 NA Hindu AEH E 19 ADM19 Administration Department A CON51 51 Co-Ordinator swargdwar nayaghat ayodhya 70 0 0 224001 9415111272 2017-06-08 07:18:35 NULL2017-07-25 20:02:12 1 yes NULLNULLno NULLNULLno 5 no no AEH 0
12 000006 07-12-2018 05:00:35 Rabindra Pratap Singh 1951-06-08 Married 67 1 20 Male 2017-06-08 A+ 0000-00-00 NA Hindu AEH E 19 ADM19 Administration Department I MNG50 18 Manager 3/24 Adarsha Nagar C colcota colcota 31 46 17 21 700031 8957791505 2017-06-08 07:21:57 NULL2018-12-06 23:30:39 1 no NULLNULLno NULLNULLno 6 no no AEH
13 000007 21-03-2023 09:53:00 Babul Roy 1951-03-10 Married 68 10 20 Male 2010-03-06 B+ 0000-00-00 Late M. L. Roy Hindu AEH E 12 HK12 House Keeping I HKI35 12 House Keeping Incharge Vill - Kadipur Post - Barun Bazar 70 4 21 224127 9919501305 2017-06-08 07:22:35 NULL2023-03-21 04:23:12 218 no NULLNULLno NULLNULLno 7 no no AEH 132
14 000008 02-10-2020 12:16:13 Kuldeep Dubey 1989-03-07 ITI Married 30 11 5 Male 2009-12-12 A+ 0000-00-00 Kailash Nath Dubey Hindu AEH E 8 FD08 Finance Department A AM24 8 Account Manager LIG 10 kaulesh kunj Ayodhya 70 4 21 224123 kuldeepdubey47@gmail.com 8423543925 2017-06-08 07:22:56 NULL2020-10-02 06:46:28 218 yes NULLNULLno NULLNULLno 8 no no AEH 2
15 000009 12-02-2019 02:26:38 Sunil Srivastava 1971-09-26 CA Work Married 49 3 4 Male 2009-10-24 O+ 0000-00-00 Jugal Kishor Srivastava Hindu AEH E 8 FD08 Finance Department A SA23 23 Senior Accountant Nagarbagh Mandi Ayodhya 70 4 21 224123 1111111111 2017-06-08 07:23:18 NULL2019-02-11 21:00:58 2 no NULLNULLno NULLNULLno 9 no no AEH 3
16 000010 NULLVikash Kaushal 1992-06-08 Married 26 1 9 Male 2017-06-08 B 0000-00-00 NA Hindu AEH E 8 FD08 Finance Department I JA22 22 Junior Accountant Swargdwar Ram Ki Paidi Nayagha Ayodhya NULL70 4 21 224123 NULLNULL7408277543 NULLNULL2017-06-08 07:24:34 NULL0000-00-00 00:00:00 NULLno NULLNULLno NULLNULLno 10 no no AEH 328
17 000011 12-12-2018 10:31:13 Sachin Pandey 1992-10-31 ccc Married 27 2 7 Male 2014-12-19 B+ 0000-00-00 Umesh Prasad Pandey Hindu AEH E 1 RD01 Front Desk I FM03 3 FRONT DESK MANAGER Vill - Beladeeh Post - Tamakhash faizabad 70 4 21 272164 sachinpandey1992@gmail.com 7523008103 2017-06-08 07:26:18 NULL2018-12-12 05:02:53 2 no 0.00 100.00 yes 0.00 100.00 yes 11 no no AEH
18 000012 23-07-2019 12:16:20 Vishal Pandey 1995-07-18 DCA Married 25 3 12 Male 2016-11-17 B 0000-00-00 Uma Shankar Pandey Hindu AHB E 8 FD08 Finance Department A JA22 22 Junior Accountant H.N. 25/04/51 Lavkush Nagar Ramghat Ayodhya 70 4 21 224123 visalpandey123@gmail.com 7355506068 2017-06-08 07:27:08 NULL2019-07-23 06:46:28 2 no 0.00 100.00 yes 0.00 100.00 yes 12 no no AHB 4
19 000013 30-08-2019 09:30:55 Shraddha Mishra 1993-06-25 CCCA Married 26 7 14 Female 2016-10-01 AB 0000-00-00 V. B. Mishra Hindu AEH E 1 RD01 Front Desk A SE02 2 SENIOR EXECUTIVE faizabad 0 shradhamishra@gmail.com 2017-06-08 07:27:52 NULL2019-08-30 04:01:01 2 no 0.00 100.00 yes 0.00 100.00 yes 13 no no AEH 12
20 000020 2017-06-09 10:45:24 Amit Mishra 1988-10-19 Single 31 3 19 Male 2010-05-01 A+ 0000-00-00 NA Hindu APH E 10 PH10 Pharmacy A JPH27 27 Junior Pharmacist Katari Mandir Nayaghat Ayodhya NULL70 4 21 224123 NULLNULL1111111111 NULLNULL2017-06-08 18:30:00 NULL0000-00-00 00:00:00 NULLno NULLNULLno NULLNULLno 14 no no APH 69
21 000021 2017-06-09 10:49:31 Kunwar Tiwari 1963-01-01 Married 57 1 12 Male 2010-03-17 A+ 0000-00-00 NA Hindu APH E 20 OPT20 Optical A OPT52 52 OPTICAL Nawabganj NULL70 4 21 224123 NULLNULL11111111111 NULLNULL2017-06-08 18:30:00 NULL0000-00-00 00:00:00 NULLno NULLNULLno NULLNULLno 15 no no APH 72
22 000022 14-06-2017 05:48:31 Dinesh Prajapati 1990-08-17 Married 27 5 4 Male 2010-10-13 B 0000-00-00 na Hindu APH E 20 OPT20 Optical I OPT52 52 OPTICAL Vill- Paliya Gova Post - Masaudha Motinagar 70 4 21 224127 1111111111 2017-06-08 18:30:00 NULL2017-06-14 00:18:43 1 no NULLNULLno NULLNULLno 16 no no APH 196
23 000023 20-07-2017 12:37:58 Deepak Sharma 1986-09-19 Married 33 4 20 Male 2011-06-21 A+ 0000-00-00 na Hindu APH E 20 OPT20 Optical A OPT52 52 OPTICAL Nawabganj na 70 4 21 224123 1111111111 2017-06-08 18:30:00 NULL2017-07-20 07:08:14 1 no NULLNULLno NULLNULLno 17 no no APH 71
24 000024 2017-06-09 11:10:58 Roop Shri Shukla 1990-06-10 Married 29 8 0 Male 2011-09-05 A+ 0000-00-00 Na Hindu APH E 20 OPT20 Optical A OPT52 52 OPTICAL na NULL70 4 21 224123 NULLNULL1111111111 NULLNULL2017-06-08 18:30:00 NULL0000-00-00 00:00:00 NULLno NULLNULLno NULLNULLno 18 no no APH 73
25 000025 2017-06-09 11:12:39 KULDEEP TIWARI 1981-04-25 Married 38 9 18 Male 2011-09-02 A+ 0000-00-00 na Hindu APH E 10 PH10 Pharmacy A PHI29 29 Pharmacist Incharge ayodhay NULL70 4 21 224123 NULLNULL1111111111 NULLNULL2017-06-08 18:30:00 NULL0000-00-00 00:00:00 NULLno NULLNULLno NULLNULLno 19 no no APH 68
26 000026 2017-06-09 11:14:28 Arjun Shonkar 2000-02-01 Married 19 1 15 Male 2013-12-06 B+ 0000-00-00 na Hindu APH E 20 OPT20 Optical I OPT52 52 OPTICAL 10, Kashi ram colony Ramghat Ayodhya NULL70 4 21 224123 NULLNULL1111111111 NULLNULL2017-06-08 18:30:00 NULL0000-00-00 00:00:00 NULLno NULLNULLno NULLNULLno 20 no no APH 403
27 000027 14-06-2017 04:36:11 Krishna Kumar Gupta 1987-09-02 Married 32 5 7 Male 2012-04-01 B+ 0000-00-00 Na Hindu APH E 20 OPT20 Optical A OPT52 52 OPTICAL ayodhya 70 4 21 224123 1111111111 2017-06-08 18:30:00 NULL2017-06-13 23:06:32 1 no NULLNULLno NULLNULLno 21 no no APH 74
28 000028 2017-06-09 11:23:45 SATYENDRA KUMAR 1995-08-10 Married 23 0 14 Male 2015-10-01 A+ 0000-00-00 Ramnaresh chaursiya Hindu APH E 10 PH10 Pharmacy I JPH27 27 Junior Pharmacist Tulsi Nagar Ayodhya NULL70 4 21 224123 satyendrak904@gmail.com NULLNULL1111111111 NULLNULL2017-06-08 18:30:00 NULL0000-00-00 00:00:00 NULLno NULLNULLno NULLNULLno 22 no no APH 458
29 000029 2017-06-09 11:25:17 Pradeep Chandra 1996-07-03 Married 22 0 13 Male 2016-09-07 B 0000-00-00 na Hindu APH E 10 PH10 Pharmacy I JPH27 27 Junior Pharmacist Tedhi Bazar Ayodhya NULL70 4 21 224123 NULLNULL1111111111 NULLNULL2017-06-08 18:30:00 NULL0000-00-00 00:00:00 NULLno NULLNULLno NULLNULLno 23 no no APH 20001
30 000030 01-08-2019 10:59:20 Janardan Achari 1970-06-09 Married 49 8 5 Male 2005-11-15 A+ 0000-00-00 na Hindu AEH E 9 STR09 Store A STI26 26 Store Incharge ayodhya Ayodhya 70 4 21 224123 1111111111 2017-06-08 18:30:00 NULL2019-08-01 05:29:34 2 no NULLNULLno NULLNULLno 24 no no AEH 6
31 000031 2017-06-09 12:00:03 Shiv Karan Ojha 1960-02-01 Married 60 0 12 Male 2012-08-01 A+ 0000-00-00 na Hindu AEH E 9 STR09 Store A STE25 25 Store Excecutive na NULL70 4 21 224001 NULLNULL1111111111 NULLNULL2017-06-08 18:30:00 NULL0000-00-00 00:00:00 NULLno NULLNULLno NULLNULLno 25 no no AEH 8