Drop files here

SQL upload ( 0 ) x-

Server: localhost »Database: herp »Table: empmaster
Page-related settingsClick on the bar to scroll to top of page
Press Ctrl+Enter to execute queryPress Enter to execute query
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
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 (253 total, Query took 0.0062 seconds.) [id: 306... - 282...]
SELECT * FROM `empmaster` ORDER BY `id`  DESC 

Full texts id Descending Ascending 1 mst_www_userid emp_site employment_type employee_type emp_code emp_name fh_name nationality religion dob doj dol department emp_shift emp_weekly_off designation marital_status marriage wh_name sons daughters sex grade personalEmail offEmail PFno ESIno leave_eff_date bachelor other_bachelor master other_master basic_perc basic_salary allow_tot deduct_tot gross_sal gross net_sal eff_sal_date pf_calculation adv_amount adv_date over_time overtime_salary image document2 document3 document bank_account bank_name ESI_account PF_accountno payment_mode created_by created_date CompanyId blocked bloodgroup course1 course2 course3 pf_Reimbursement_per pf_Reimbursement medical_Reimbursement_per medical_Reimbursement tenth_standard tenthplus2_standard pending_wo multi_site_att otapplicable ottype auth status loan_ledger advance_ledger staff_type biomatric_id
306 NULLAHB E 34 000311 Aviral Singh Bhanu Pratap Singh indian hindu 1992-03-29 2024-07-11 0000-00-00 18 44 7 50 Married 0000-00-00 N/A 0 0 Male 1 2024-07-17 B.Sc NULL4000.00 0.00 0.00 0.00 0.00 0.00 0.00 0000-00-00 0.00 0000-00-00 0 0.00 NULLNULLNULLNULLCheque 115 2024-07-17 3 0 A+ MBA 0.00 0.00 0.00 0.00 true true 0 0 N yes A NULLNULLR 0
305 NULLAHB E 34 000310 Ravi Shankar Sharma Ram Kumar Sharma indian hindu 1991-10-02 2024-04-01 0000-00-00 9 44 7 26 Married 2024-04-10 N/A 0 0 Male 1 2024-04-10 B.Tech/B.E NULL4000.00 0.00 0.00 0.00 0.00 0.00 0.00 0000-00-00 0.00 0000-00-00 0 0.00 NULLNULLNULLNULLCheque 115 2024-04-10 3 0 A+ 0.00 0.00 0.00 0.00 true true 0 0 N yes A NULLNULLR 0
304 NULLAEH E 34 000309 Durgesh Chandra Srivastava krishna mohan indian hindu 1984-07-15 2024-04-02 0000-00-00 7 NULL7 21 Married 2024-04-10 N/A 0 0 Male 1 2024-04-10 B.A NULL4000.00 0.00 0.00 0.00 0.00 0.00 0.00 0000-00-00 0.00 0000-00-00 0 0.00 NULLNULLNULLNULLCheque 115 2024-04-10 3 0 A+ PGDCA 0.00 0.00 0.00 0.00 true true 0 0 yes A NULLNULLR 176
303 NULLAHB D 34 000308 Dr. Shitiz Saxena Dr. Rajeev Saxena indian hindu 1990-10-02 2024-03-13 0000-00-00 4 44 7 10 Married 0000-00-00 N/A 0 0 Male 1 2024-03-14 MBBS NULLMS 4000.00 0.00 0.00 0.00 0.00 0.00 0.00 0000-00-00 0.00 0000-00-00 0 0.00 NULLNULLNULLNULLCheque 115 2024-03-14 3 0 A+ 0.00 0.00 0.00 0.00 true true 0 0 N yes A NULLNULLR 0
302 NULLAHB D 34 000307 Dr. Rahul Kumar Shree Dhruv Narayan Mahto indian hindu 1993-04-07 2024-01-06 0000-00-00 4 44 7 10 Married 0000-00-00 N/A 0 0 Male 1 2024-01-09 MBBS NULLMS 4000.00 0.00 0.00 0.00 0.00 0.00 0.00 0000-00-00 0.00 0000-00-00 0 0.00 NULLNULLNULLNULLCheque 115 2024-01-09 3 0 A+ 0.00 0.00 0.00 0.00 true true 0 0 N yes A NULLNULLR 0
301 NULLAEH D 34 000306 Dr. Lokesh Mehla shree Raj Kumar mehla indian hindu 1995-12-14 2024-01-09 0000-00-00 4 NULL7 10 Married 0000-00-00 0 0 Male 1 2024-01-09 MBBS NULLMS 4000.00 0.00 0.00 0.00 0.00 0.00 0.00 0000-00-00 0.00 0000-00-00 0 0.00 NULLNULLNULLNULLCheque 115 2024-01-09 3 0 A+ 0.00 0.00 0.00 0.00 true true 0 0 yes A NULLNULLR 0
300 NULLAEH E 34 000305 Awadhesh Kumar Harakhu Chaurasiya indian hindu 2003-06-05 2023-12-13 0000-00-00 2 34 7 4 Married 0000-00-00 N/A 0 0 Male 1 2023-12-21 Diploma NULL4000.00 0.00 0.00 0.00 0.00 0.00 0.00 0000-00-00 0.00 0000-00-00 0 0.00 NULLNULLNULLNULLCheque 115 2023-12-21 3 0 A+ optm 0.00 0.00 0.00 0.00 true true 0 0 N yes A NULLNULLR 169
299 NULLAEH E 34 000304 Anju Maurya Saryu Prasad indian hindu 2003-12-11 2023-12-13 0000-00-00 2 34 7 4 Married 0000-00-00 N/A 0 0 Female 1 2023-12-21 Diploma NULL4000.00 0.00 0.00 0.00 0.00 0.00 0.00 0000-00-00 0.00 0000-00-00 0 0.00 NULLNULLNULLNULLCheque 115 2023-12-21 3 0 A optm 0.00 0.00 0.00 0.00 true true 0 0 N yes A NULLNULLR 168
298 NULLAEH D 34 000303 Dr. Suraj Singh Ram Naresh Singh indian hindu 2023-10-24 2023-10-24 0000-00-00 4 34 7 10 Married 0000-00-00 N/A 0 0 Male 1 2023-10-24 MBBS NULLMS 4000.00 0.00 0.00 0.00 0.00 0.00 0.00 0000-00-00 0.00 0000-00-00 0 0.00 NULLNULLNULLNULLCheque 115 2023-10-24 3 0 B 0.00 0.00 0.00 0.00 true true 0 0 N yes A NULLNULLR 0
297 NULLAEH E 34 000302 Gauri Kamlesh Das Shastri indian hindu 2023-09-22 2023-09-22 0000-00-00 1 34 7 1 Married 0000-00-00 N/A 0 0 Female 1 2023-09-22 B.A NULLM.A 4000.00 0.00 0.00 0.00 0.00 0.00 0.00 0000-00-00 0.00 0000-00-00 0 0.00 NULLNULLNULLNULLCheque 115 2023-09-22 3 0 B 0.00 0.00 0.00 0.00 true true 0 0 N yes A NULLNULLR 0
296 NULLAEH D 34 000301 Dr.Sajan Dev Kesar Shashi Kant Kesar indian hindu 2023-09-21 2023-09-22 0000-00-00 4 NULL7 12 Married 2023-09-21 N/A 0 0 Male 1 2023-09-21 MBBS NULLMS 4000.00 0.00 0.00 0.00 0.00 0.00 0.00 0000-00-00 0.00 0000-00-00 0 0.00 NULLNULLNULLNULLCheque 115 2023-09-21 3 0 A+ 0.00 0.00 0.00 0.00 true true 0 0 yes A NULLNULLR 0
295 NULLAHB D 34 000300 Dr. Jyoti Singh Surendra Kumar Singh indian hindu 2023-09-18 2023-09-18 0000-00-00 4 44 7 10 Married 0000-00-00 N/A 0 0 Female 1 2023-09-18 MBBS NULLMS 4000.00 0.00 0.00 0.00 0.00 0.00 0.00 0000-00-00 0.00 0000-00-00 0 0.00 NULLNULLNULLNULLCheque 115 2023-09-18 3 0 A+ DNB, 0.00 0.00 0.00 0.00 true true 0 0 N yes A NULLNULLR 0
294 NULLAEH E 34 000299 Shravan Kumar fool chand Chaudhary indian hindu 2023-09-16 2023-09-16 0000-00-00 6 NULL7 17 Married 0000-00-00 0 0 Male 1 2023-09-16 B.Sc NULL4000.00 0.00 0.00 0.00 0.00 0.00 0.00 0000-00-00 0.00 0000-00-00 0 0.00 NULLNULLNULLNULLCheque 115 2023-09-16 3 0 A+ Ot tech 0.00 0.00 0.00 0.00 true true 0 0 yes A NULLNULLR 0
293 NULLAEH E 34 000298 Umesh Kumar Ratnesh kumar pandey indian hindu 2023-08-26 2023-08-26 0000-00-00 25 NULL7 66 Married 2023-08-26 N/A 0 0 Male 1 2023-08-26 B.A NULLM.A 4000.00 0.00 0.00 0.00 0.00 0.00 0.00 0000-00-00 0.00 0000-00-00 0 0.00 NULLNULLNULLNULLCheque 115 2023-08-26 3 0 B 0.00 0.00 0.00 0.00 true true 0 0 yes A NULLNULLR 0
292 NULLAHB E 34 000297 Ashish Kumar Bhagwan Deen indian hindu 2023-08-26 2023-08-26 0000-00-00 18 44 7 51 Married 2023-08-26 N/A 0 0 Male 1 2023-08-26 B.Tech/B.E NULL4000.00 0.00 0.00 0.00 0.00 0.00 0.00 0000-00-00 0.00 0000-00-00 0 0.00 NULLNULLNULLNULLCheque 115 2023-08-26 3 0 A+ MBA 0.00 0.00 0.00 0.00 true true 0 0 N yes A NULLNULLR 0
291 NULLAHB E 34 000296 Awdhesh Ram Pandey Dinesh Chandra Pandey indian hindu 1992-01-01 2023-08-11 0000-00-00 2 44 7 4 Married 0000-00-00 N/A 0 0 Male 1 2023-08-11 Diploma NULL4000.00 0.00 0.00 0.00 0.00 0.00 0.00 0000-00-00 0.00 0000-00-00 0 0.00 NULLNULLNULLNULLCheque 115 2023-08-11 3 0 A+ optm 0.00 0.00 0.00 0.00 true true 0 0 N yes A NULLNULLR 0
290 NULLAHB E 34 000295 Amarnath gupta Ram shankar gupta indian hindu 2023-08-11 2023-08-11 0000-00-00 2 44 7 4 Married 0000-00-00 N/A 0 0 Male 1 2023-08-11 Diploma NULL4000.00 0.00 0.00 0.00 0.00 0.00 0.00 0000-00-00 0.00 0000-00-00 0 0.00 NULLNULLNULLNULLCheque 115 2023-08-11 3 0 A optm 0.00 0.00 0.00 0.00 true true 0 0 N yes A NULLNULLR 0
289 NULLAEH D 34 000294 Dr. Amar Kumar Sri Ganga Ram Pandit indian hindu 1992-02-25 2023-07-12 0000-00-00 4 34 7 12 Married 0000-00-00 N/A 0 0 Male 1 2023-07-12 MBBS NULLMS 4000.00 0.00 0.00 0.00 0.00 0.00 0.00 0000-00-00 0.00 0000-00-00 0 0.00 NULLNULLNULLNULLCheque 115 2023-07-12 3 0 A+ 0.00 0.00 0.00 0.00 true true 0 0 N yes A NULLNULLR 0
288 NULLAHB E 34 000293 Vikash Yadav virendra pratap yadav indian hindu 2023-07-08 2023-07-08 0000-00-00 1 44 7 3 Married 0000-00-00 N/A 0 0 Male 1 2023-07-08 B.A NULL4000.00 0.00 0.00 0.00 0.00 0.00 0.00 0000-00-00 0.00 0000-00-00 0 0.00 NULLNULLNULLNULLCheque 115 2023-07-08 3 0 A+ 0.00 0.00 0.00 0.00 true true 0 0 N yes A NULLNULLR 0
287 NULLAEH E 34 000292 Pooja Maurya Chhotelal Maurya indian hindu 1999-12-21 2023-07-06 0000-00-00 1 NULL7 1 Married 0000-00-00 0 0 Female 1 2023-07-06 B.Sc NULL4000.00 0.00 0.00 0.00 0.00 0.00 0.00 0000-00-00 0.00 0000-00-00 0 0.00 NULLNULLNULLNULLCheque 115 2023-07-06 3 0 A D pharma 0.00 0.00 0.00 0.00 true true 0 0 yes A NULLNULLR 155
286 NULLAEH D 34 000291 Dr. Punam Tiwari RAM SHANKAR TIWARI indian hindu 1983-03-25 2023-06-01 0000-00-00 4 NULL7 12 Married 2023-06-01 N/A 0 0 Female 1 2023-06-01 MBBS NULLMS 4000.00 0.00 0.00 0.00 0.00 0.00 0.00 0000-00-00 0.00 0000-00-00 0 0.00 NULLNULLNULLNULLCheque 115 2023-06-01 3 0 A 0.00 0.00 0.00 0.00 true true 0 0 yes A NULLNULLR 0
285 NULLAEH E 34 000290 ravi sharma shambhu nath sharma indian hindu 1998-08-10 2023-02-24 0000-00-00 1 NULL7 1 Married 0000-00-00 0 0 Male 1 2023-03-14 NULL4000.00 0.00 0.00 0.00 0.00 0.00 0.00 0000-00-00 0.00 0000-00-00 0 0.00 NULLNULLNULLNULLCheque 115 2023-03-14 3 0 A+ ADCA 0.00 0.00 0.00 0.00 true true 0 0 yes A NULLNULLR 0
284 NULLAEH D 34 000289 Dr. Farhat Siddiqui Mohd Anzarul Hasan indian muslim 1988-04-01 2023-03-09 0000-00-00 4 34 7 10 Married 0000-00-00 N/A 0 0 Female 1 2023-03-09 MBBS NULLMS 4000.00 0.00 0.00 0.00 0.00 0.00 0.00 0000-00-00 0.00 0000-00-00 0 0.00 NULLNULLNULLNULLCheque 115 2023-03-09 3 0 A 0.00 0.00 0.00 0.00 true true 0 0 N yes A NULLNULLR 0
283 NULLAEH E 34 000288 Mohammad raza Insaf Ali indian muslim 2002-01-01 2023-02-28 0000-00-00 2 34 7 4 Married 0000-00-00 N/A 0 0 Male 1 2023-02-28 NULL4000.00 0.00 0.00 0.00 0.00 0.00 0.00 0000-00-00 0.00 0000-00-00 0 0.00 NULLNULLNULLNULLCheque 115 2023-02-28 3 0 A optam 0.00 0.00 0.00 0.00 true true 0 0 N no A NULLNULLR 0
282 NULLAEH E 34 000287 Abhishek tiwari shree v.d tiwri indian hindu 1990-07-18 2023-02-01 0000-00-00 30 34 7 74 Married 2015-02-14 N/A 0 0 Male 1 2023-02-06 B.Sc NULL4000.00 0.00 0.00 0.00 0.00 0.00 0.00 0000-00-00 0.00 0000-00-00 0 0.00 NULLNULLNULLNULLCheque 115 2023-02-06 3 0 O+ MHA 0.00 0.00 0.00 0.00 true 0 0 N yes A NULLNULLR 0