将文件拖动至此

SQL upload ( 0 ) x-

服务器: localhost »数据库: hmis »表: employee_masters
页面相关设置点击以滚动到页面顶部
按 Ctrl+Enter 键执行查询按 Enter 执行查询
递增排序
递减排序
命令:
调试 SQL
数量
运行顺序
用时
排序条件:
联合查询
不使用联合查询
崩溃 扩展 显示跟踪 隐藏跟踪 记录数: 用时:
书签
刷新
添加
没有书签
添加书签
选项
恢复默认





崩溃 扩展 重新查询 编辑 解析 性能分析 书签 查询失败 数据库: 查询时间:

浏览模式

自定义浏览模式。

文档 仅使用图标、文字或都使用。
文档 仅使用图标、文字或都使用。
文档 Whether a user should be displayed a "show all (rows)" button.
文档 浏览结果集时显示的行数。若结果集总行数超过该值,将会显示 "上一页" 和 "下一页" 的链接。
文档 SMART - 即对 TIME、DATE、DATETIME 和 TIMESTAMP 类型的字段递减排序,其它字段递增。
文档 高亮鼠标指针所在的行。
文档 高亮选中的行。
文档
文档
文档 每 X 单元格重复表头,要禁止此功能请设为 0
文档 浏览非数字字段时最多显示的字数。
文档 这些是编辑、复制和删除链接。
文档 缺少唯一键时是否显示行链接。
文档 默认用主键为表排序。
文档 当浏览表时使用上次的排序方式。
文档 显示选项
正在显示第 0 - 24 行 (共 302 行, 查询花费 0.0062 秒。)
SELECT * FROM `employee_masters`

完整内容 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