Drop files here

SQL upload ( 0 ) x -

Page-related settings Click on the bar to scroll to top of page
Press Ctrl+Enter to execute query Press 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
Customise browse mode.
Browse mode
Documentation Use only icons, only text or both. Restore default value
Documentation Use only icons, only text or both. Restore default value
Documentation Whether a user should be displayed a "show all (rows)" button. Restore default value
Documentation Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown. Restore default value
Documentation SMART - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise. Restore default value
Documentation Highlight row pointed by the mouse cursor. Restore default value
Documentation Highlight selected rows. Restore default value
Documentation Restore default value
Documentation Restore default value
Documentation Repeat the headers every X cells, 0 deactivates this feature. Restore default value
Documentation Maximum number of characters shown in any non-numeric column on browse view. Restore default value
Documentation These are Edit, Copy and Delete links. Restore default value
Documentation Whether to show row links even in the absence of a unique key. Restore default value
Documentation Default sort order for tables with a primary key. Restore default value
Documentation When browsing tables, the sorting of each table is remembered. Restore default value
Documentation For display Options Restore default value
SELECT * FROM `employees`
[ Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
Full texts id employee_code salutation first_name last_name middle_name extension_name nickname gender birth_date nationality marital_status personal_email work_email mobile_number telephone_number address_street city province zip_code country emergency_contact_name emergency_contact_relation emergency_contact_phone sss_number philhealth_number pagibig_number tin_number drivers_license passport_number department_id position department_id_2 position_2 employment_status status date_hired date_regularized created_at updated_at profile_picture sss_file philhealth_file pagibig_file tin_file branch holiday_exempted picture_2x2_file coe_tor_file birth_cert_file nbi_clearance_file police_clearance_file cutoff_schedule payroll_schedule cutoff_1 cutoff_2 payroll_1 payroll_2 salary_type basic_salary hourly_rate fixed_rate
Edit Edit Copy Copy Delete Delete
DELETE FROM employees WHERE `employees`.`id` = 5
5 110014 Mr. JONH RAY BABALA NULL NULL Male 2001-12-19 FILIPINO Single BABALAJONHRAY@GMAIL.COM BABALAJONHRAY@GMAIL.COM 09913095516 386 PUROK 4 STO. TOMAS BIÑAN, LAGUNA SANTA ROSA LAGUNA 4026 PHILIPPINES 001000 11111111111111111111111111111 1111111111111111111 11111111111111111111 NULL NULL 4 IT OFFICER 2 FACULTY-SHS-COLLEGE Full Time Inactive 2026-01-30 NULL 2026-01-30 16:54:11 2026-01-31 11:41:30 PROFILE_PICTURE_1769823566_463.png SSS_1769763251_838.png PHILHEALTH_1769763251_327.pdf Yes NULL NULL NULL NULL NULL NULL Monthly NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM employees WHERE `employees`.`id` = 7
7 9595 Mr. JONH RAY BABALA APOLINAR NULL NULL Male 2001-12-19 FILIPINO Single babalajonhray@gmail.com babalajonhray@gmail.com 09090860981 PHASE 4 BLOCK 8 LOT 30 SANTA ROSA LAGUNA 4026 PHILIPPINES 001000 11111111111111111111111111111 1111111111111111111 11111111111111111111 NULL NULL 2 FACULTY: FULL-TIME 1 HR OFFICER Regular Inactive 2026-01-31 NULL 2026-01-31 08:39:34 2026-01-31 08:59:24 PROFILE_PICTURE_1769820052_305.jpg SSS_1769819974_523.jpg CABUYAO Yes PICTURE_2X2_1769819974_633.png COE_TOR_1769819974_340.jpg BIRTH_CERT_1769819974_613.jpg NBI_CLEARANCE_1769819974_825.jpg POLICE_CLEARANCE_1769819974_746.png NULL NULL NULL NULL NULL NULL Monthly NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM employees WHERE `employees`.`id` = 8
8 222 Ms. TEST TEST TEST NULL NULL Male 2001-12-19 FILIPINO Single BABALAJONHRAY@GMAIL.COM BABALAJONHRAY@GMAIL.COM 09913095516 TEST TEST TEST 1111 PHILIPPINES 001000 11111111111111111111111111111 1111111111111111111 11111111111111111111 NULL NULL 4 DEVELOPER NULL Contractual Resigned 2026-01-31 NULL 2026-01-31 08:49:19 2026-01-31 08:52:11 PROFILE_PICTURE_1769820559_804.png CABUYAO Yes NULL NULL NULL NULL NULL NULL Monthly NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM employees WHERE `employees`.`id` = 13
13 9596 Ms. TEST TEST TEST NULL NULL Male 2001-12-19 FILIPINO Single babalajonhray19@gmail.com babalajonhray19@gmail.com 09999999999 TEST TEST LAGUNA 4026 PHILIPPINES 959565 959565 959565 959565 NULL NULL 2 FACULTY-COLLEGE NULL Fixed Term Active 2026-01-31 NULL 2026-01-31 09:37:58 2026-06-16 13:38:50 PROFILE_PICTURE_1769823997_216.jpg SSS_1769823478_659.jpg Yes PICTURE_2X2_1769823478_731.png COE_TOR_1769824041_227.jpg NULL NULL 15 30 25 10 Fixed 10000.00 NULL 10000.00
Edit Edit Copy Copy Delete Delete
DELETE FROM employees WHERE `employees`.`id` = 14
14 9696 Mr. TEST TEST NULL NULL Male 2026-01-31 FILIPINO Single papphar@gmail.com papphar@gmail.com 09999999999 TEST TEST TEST 4026 PHILIPPINES 321321 321321321 321321 21321 NULL NULL 4 IT OFFICER 3 CHIEF SECURITY OFFICER Regular Inactive 2026-01-31 NULL 2026-01-31 10:21:30 2026-01-31 10:21:46 PROFILE_PICTURE_1769826090_635.jpg SSS_1769826090_220.jpg PHILHEALTH_1769826090_404.pdf No PICTURE_2X2_1769826090_116.jpg NULL NULL NULL NULL NULL NULL Monthly NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM employees WHERE `employees`.`id` = 15
15 12345 Mr. JONH RAY BABALA APOLINAR NULL NULL Male 2001-12-19 FILIPINO Single papphar19@gmail.com papphar19@gmail.com 09999999999 TEST TEST TEST 4026 PHILIPPINES TEST TEST 09222222222 34-9585400-4 0825 4378 5179 121273194501 384401580 NULL NULL 6 ADMINISTRATIVE OFFICER NULL Regular Active 2025-07-09 NULL 2026-06-16 10:16:27 2026-06-20 10:18:00 PROFILE_PICTURE_1781684579_244.png BAY Yes NULL NULL 10 25 15 30 Monthly 38000.00 NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM employees WHERE `employees`.`id` = 16
16 123456 Mr. TEST1 TEST1 TEST NULL NULL Male 2001-12-19 FILIPINO Single papphar19@gmail.com papphar19@gmail.com 09999999999 TEST TEST TES 4026 PHILIPPINES NULL NULL 2 FACULTY-COLLEGE NULL Part Time Active 2026-06-16 NULL 2026-06-16 10:59:17 2026-06-16 11:12:46 No NULL NULL 15 30 25 10 Hourly NULL 120.00 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM employees WHERE `employees`.`id` = 17
17 EMP-001 NULL JUAN DELA CRUZ P NULL NULL Male 0000-00-00 FILIPINO Single juan@example.com juan@example.com 9123456789 NULL 123 MAIN ST MANILA METRO MANILA 1000 PHILIPPINES NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL Probationary Inactive 2026-06-17 NULL 2026-06-17 16:23:58 2026-06-17 16:24:07 NULL NULL NULL NULL NULL NULL No NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL Monthly NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM employees WHERE `employees`.`id` = 18
18 EMP-002 NULL JUAN DELA CRUZ P NULL NULL Male 0000-00-00 FILIPINO Single juan@example.com juan@example.com 9123456790 NULL 124 MAIN ST MANILA METRO MANILA 1001 PHILIPPINES NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL Probationary Inactive 2026-06-17 NULL 2026-06-17 16:23:58 2026-06-17 16:24:10 NULL NULL NULL NULL NULL NULL No NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL Monthly NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM employees WHERE `employees`.`id` = 19
19 EMP-003 NULL JUAN DELA CRUZ P NULL NULL Male 0000-00-00 FILIPINO Single juan@example.com juan@example.com 9123456791 NULL 125 MAIN ST MANILA METRO MANILA 1002 PHILIPPINES NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL Probationary Inactive 2026-06-17 NULL 2026-06-17 16:23:58 2026-06-17 16:24:12 NULL NULL NULL NULL NULL NULL No NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL Monthly NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM employees WHERE `employees`.`id` = 20
20 EMP-004 NULL JUAN DELA CRUZ P NULL NULL Male 0000-00-00 FILIPINO Single juan@example.com juan@example.com 9123456792 NULL 126 MAIN ST MANILA METRO MANILA 1003 PHILIPPINES NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL Probationary Inactive 2026-06-17 NULL 2026-06-17 16:23:58 2026-06-17 16:24:14 NULL NULL NULL NULL NULL NULL No NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL Monthly NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM employees WHERE `employees`.`id` = 21
21 EMP-005 NULL JUAN DELA CRUZ P NULL NULL Male 0000-00-00 FILIPINO Single juan@example.com juan@example.com 9123456793 NULL 127 MAIN ST MANILA METRO MANILA 1004 PHILIPPINES NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL Probationary Inactive 2026-06-17 NULL 2026-06-17 16:23:58 2026-06-17 16:24:15 NULL NULL NULL NULL NULL NULL No NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL Monthly NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM employees WHERE `employees`.`id` = 22
22 EMP-006 NULL JUAN DELA CRUZ P NULL NULL Male 0000-00-00 FILIPINO Single juan@example.com juan@example.com 9123456794 NULL 128 MAIN ST MANILA METRO MANILA 1005 PHILIPPINES NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL Probationary Inactive 2026-06-17 NULL 2026-06-17 16:23:58 2026-06-17 16:24:17 NULL NULL NULL NULL NULL NULL No NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL Monthly NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM employees WHERE `employees`.`id` = 23
23 EMP-007 NULL JUAN DELA CRUZ P NULL NULL Male 0000-00-00 FILIPINO Single juan@example.com juan@example.com 9123456795 NULL 129 MAIN ST MANILA METRO MANILA 1006 PHILIPPINES NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL Probationary Inactive 2026-06-17 NULL 2026-06-17 16:23:58 2026-06-17 16:24:18 NULL NULL NULL NULL NULL NULL No NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL Monthly NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM employees WHERE `employees`.`id` = 24
24 EMP-008 NULL JUAN DELA CRUZ P NULL NULL Male 0000-00-00 FILIPINO Single juan@example.com juan@example.com 9123456796 NULL 130 MAIN ST MANILA METRO MANILA 1007 PHILIPPINES NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL Probationary Inactive 2026-06-17 NULL 2026-06-17 16:23:58 2026-06-17 16:24:20 NULL NULL NULL NULL NULL NULL No NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL Monthly NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM employees WHERE `employees`.`id` = 25
25 EMP-009 NULL JUAN DELA CRUZ P NULL NULL Male 0000-00-00 FILIPINO Single juan@example.com juan@example.com 9123456797 NULL 131 MAIN ST MANILA METRO MANILA 1008 PHILIPPINES NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL Probationary Inactive 2026-06-17 NULL 2026-06-17 16:23:58 2026-06-17 16:24:21 NULL NULL NULL NULL NULL NULL No NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL Monthly NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM employees WHERE `employees`.`id` = 26
26 EMP-010 NULL JUAN DELA CRUZ P NULL NULL Male 0000-00-00 FILIPINO Single juan@example.com juan@example.com 9123456798 NULL 132 MAIN ST MANILA METRO MANILA 1009 PHILIPPINES NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL Probationary Inactive 2026-06-17 NULL 2026-06-17 16:23:58 2026-06-17 16:24:23 NULL NULL NULL NULL NULL NULL No NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL Monthly NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM employees WHERE `employees`.`id` = 81
81 EMP-100 Mr. JUAN DELA CRUZ P NULL NULL Male 1990-01-01 FILIPINO Single juan@example.com juan.work@example.com 9123456789 281234567 123 MAIN ST MANILA METRO MANILA 1000 PHILIPPINES MARIA DELA CRUZ MOTHER 9987654321 12-3456789-0 12-345678901-2 1234-5678-9012 123-456-789-000 NULL NULL 6 IT OFFICER NULL Probationary Active 2026-06-17 NULL 2026-06-17 16:50:42 2026-06-17 16:50:42 NULL NULL NULL NULL NULL CABUYAO No NULL NULL NULL NULL NULL NULL NULL 10 25 15 30 Monthly 25000.00 NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM employees WHERE `employees`.`id` = 82
82 EMP-101 Mr. JUAN DELA CRUZ P NULL NULL Male 1990-02-01 FILIPINO Single juan@example.com juan.work@example.com 9123456789 281234567 124 MAIN ST MANILA METRO MANILA 1001 PHILIPPINES MARIA DELA CRUZ MOTHER 9987654322 12-3456789-1 12-345678901-3 1234-5678-9013 123-456-789-001 NULL NULL 6 IT OFFICER NULL Probationary Active 2026-06-17 NULL 2026-06-17 16:50:42 2026-06-17 16:50:42 NULL NULL NULL NULL NULL BIÑAN No NULL NULL NULL NULL NULL NULL NULL 10 25 15 30 Monthly 25000.00 NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM employees WHERE `employees`.`id` = 83
83 EMP-102 Mr. JUAN DELA CRUZ P NULL NULL Male 1990-03-01 FILIPINO Single juan@example.com juan.work@example.com 9123456789 281234567 125 MAIN ST MANILA METRO MANILA 1002 PHILIPPINES MARIA DELA CRUZ MOTHER 9987654323 12-3456789-2 12-345678901-4 1234-5678-9014 123-456-789-002 NULL NULL 6 IT OFFICER NULL Probationary Active 2026-06-17 NULL 2026-06-17 16:50:42 2026-06-17 16:50:42 NULL NULL NULL NULL NULL BIÑAN No NULL NULL NULL NULL NULL NULL NULL 10 25 15 30 Monthly 25000.00 NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM employees WHERE `employees`.`id` = 84
84 EMP-103 Mr. JUAN DELA CRUZ P NULL NULL Male 1990-04-01 FILIPINO Single juan@example.com juan.work@example.com 9123456789 281234567 126 MAIN ST MANILA METRO MANILA 1003 PHILIPPINES MARIA DELA CRUZ MOTHER 9987654324 12-3456789-3 12-345678901-5 1234-5678-9015 123-456-789-003 NULL NULL 6 IT OFFICER NULL Probationary Active 2026-06-17 NULL 2026-06-17 16:50:42 2026-06-17 16:50:42 NULL NULL NULL NULL NULL SILANG No NULL NULL NULL NULL NULL NULL NULL 10 25 15 30 Monthly 25000.00 NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM employees WHERE `employees`.`id` = 85
85 EMP-104 Mr. JUAN DELA CRUZ P NULL NULL Male 1990-05-01 FILIPINO Single juan@example.com juan.work@example.com 9123456789 281234567 127 MAIN ST MANILA METRO MANILA 1004 PHILIPPINES MARIA DELA CRUZ MOTHER 9987654325 12-3456789-4 12-345678901-6 1234-5678-9016 123-456-789-004 NULL NULL 6 IT OFFICER NULL Probationary Active 2026-06-17 NULL 2026-06-17 16:50:42 2026-06-17 16:50:42 NULL NULL NULL NULL NULL BAY No NULL NULL NULL NULL NULL NULL NULL 10 25 15 30 Monthly 25000.00 NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM employees WHERE `employees`.`id` = 86
86 EMP-105 Mr. JUAN DELA CRUZ P NULL NULL Male 1990-06-01 FILIPINO Single juan@example.com juan.work@example.com 9123456789 281234567 128 MAIN ST MANILA METRO MANILA 1005 PHILIPPINES MARIA DELA CRUZ MOTHER 9987654326 12-3456789-5 12-345678901-7 1234-5678-9017 123-456-789-005 NULL NULL 6 IT OFFICER NULL Probationary Active 2026-06-17 NULL 2026-06-17 16:50:42 2026-06-17 16:50:42 NULL NULL NULL NULL NULL SANTA ROSA No NULL NULL NULL NULL NULL NULL NULL 10 25 15 30 Monthly 25000.00 NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM employees WHERE `employees`.`id` = 87
87 EMP-106 Mr. JUAN DELA CRUZ P NULL NULL Male 1990-07-01 FILIPINO Single juan@example.com juan.work@example.com 9123456789 281234567 129 MAIN ST MANILA METRO MANILA 1006 PHILIPPINES MARIA DELA CRUZ MOTHER 9987654327 12-3456789-6 12-345678901-8 1234-5678-9018 123-456-789-006 NULL NULL 6 IT OFFICER NULL Probationary Active 2026-06-17 NULL 2026-06-17 16:50:42 2026-06-17 16:50:42 NULL NULL NULL NULL NULL CABUYAO No NULL NULL NULL NULL NULL NULL NULL 10 25 15 30 Monthly 25000.00 NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM employees WHERE `employees`.`id` = 88
88 EMP-107 Mr. JUAN DELA CRUZ P NULL NULL Male 1990-08-01 FILIPINO Single juan@example.com juan.work@example.com 9123456789 281234567 130 MAIN ST MANILA METRO MANILA 1007 PHILIPPINES MARIA DELA CRUZ MOTHER 9987654328 12-3456789-7 12-345678901-9 1234-5678-9019 123-456-789-007 NULL NULL 6 IT OFFICER NULL Probationary Active 2026-06-17 NULL 2026-06-17 16:50:42 2026-06-17 16:50:42 NULL NULL NULL NULL NULL CALAMBA No NULL NULL NULL NULL NULL NULL NULL 10 25 15 30 Monthly 25000.00 NULL NULL
With selected: With selected:
Query results operations Copy to clipboard Copy to clipboard Export Export Display chart Display chart Create view Create view
Bookmark this SQL query Bookmark this SQL query