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 :
Options
Set default





Collapse Expand Requery Edit Explain Profiling Query failed Database : Queried time :
Browse mode
Customize 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_copy_copy`
Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
Full texts SysPK_Empl old_personId person_id status_update priority AccountNo_Empl Emp_no trans_date Name_Empl FirstName_Empl MiddleName_Empl LastName_Empl SuffixName_Empl PrefixName_Empl nickname Address_Empl empl_contactno email_address BirthDate_Empl weight height gender civilStatus dependent GSIS_Empl SSS_Empl TIN_Empl philhealth_no pagibig_no with_atm bankname_Empl bankaccount_Empl BloodType_Empl EmergencyName_Empl EmergencyAdd_Empl EmergencyTelNo_Empl Position_Empl count Department_Empl shift_code RateBasis RatePerDay_Empls BasicSalary_Empls DateHired_Empl DateEffectivity_Empl DatTerminated_Empl DateRetired Status_Empl Type_Empl office_location payroll_group with_bio with_contract pertrip title_id branch_id RHouse_No RSubd_Village RCity_Mun RZipcode RStreet RBrgy RProvince PHouse_No PSubd_Village PCity_Mun PZipcode PStreet PBrgy PProvince sal_grade_id recruitment_id birthplace government_ID ID_License_Passport Date_Place_Issuance privilege Appoint_Status jo_group_no with_pds level indigenous_group person_disablity solo_parent bp_number designate_dept designate_pos designate_count item_no authorized date_promotion level_csc inactive_date
Edit Edit Copy Copy Delete Delete
DELETE FROM employees_copy_copy WHERE `employees_copy_copy`.`SysPK_Empl` = 1
1 0 814 na NULL 01-10-0005-2019 NULL 2019-11-26 Admin A. Admin Admin A Admin City of Naga,Cebu 1980-01-19 Male Married 3 123-456-789-000 317-987-876 111-222-333 222-333-444 No AB 139 6 1 Monthly 666.66 20000 2019-10-15 2019-10-15 NULL Inactive 3 1 False True NO 1 1 City of Naga 9200 Poblacion Cebu City of Naga Cebu 92 0 No 3 Yes 1st Level - Rank & File No No No NULL 2 139 NULL NULL NULL NULL 2021-03-01
Edit Edit Copy Copy Delete Delete
DELETE FROM employees_copy_copy WHERE `employees_copy_copy`.`SysPK_Empl` = 2
2 0 815 na NULL 01-10-0005-2019 NULL 2019-11-26 Valdemar M. Chiong Valdemar Mendiola Chiong City of Naga,Cebu 9189378671 1960-09-10 1.7 55 Female Married 3 B60S5VMC013 903114-45-4000 120000-03-6345 70147364609 No A+ 33 1 1 Monthly 5255.53 157666 2019-07-01 2019-07-01 NULL Inactive 8 1 False True NO 1 1 City of Naga 9200 Poblacion Cebu City of Naga Cebu 237 0 No 8 Yes 3rd Level - Top Mgt. No No No NULL 1 33 1 0 1900-01-01 5 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM employees_copy_copy WHERE `employees_copy_copy`.`SysPK_Empl` = 3
3 0 86 na NULL 01-10-0001-2019 NULL 2019-11-26 Anna Maria B. Gabilan Anna Maria Bacon Gabilan City of Naga,Cebu 09175468147 [email protected] 1965-08-16 5 67 Female Married 6 65081601733 N/A 136-293-271 12-00003656-6 070118200305 No O+ 35 6 1 Monthly 2626.7 78801 1988-05-16 1988-05-16 NULL Active 3 1 False True NO 1 City of Naga 9200 Poblacion Cebu City of Naga Cebu 192 0 No 3 Yes 1st Level - Rank & File No No No 001-10-0001-2019 6 94 I 1 75065 1900-01-01 7 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM employees_copy_copy WHERE `employees_copy_copy`.`SysPK_Empl` = 6
6 0 633 na NULL 01-10-0002-2019 NULL 2019-11-26 Certeria V. Buenavista Certeria Villarico Buenavista City of Naga,Cebu 9175468409 [email protected] 1957-11-02 63 1.57 Male Married 0 57110202409 606-60-1777 127-199-432 120000-03-6175 1640-0003-2846 No 18 5 1 Monthly 3165.06 94952 1995-07-17 1995-07-17 NULL Active 3 1 1 False True NO 1 1 Door 3, Villarico Apartment Panaghiusa City of Naga 6037 North Poblacion Cebu Door 3, Villarico Apartment Panaghiusa City of Naga 6037 North Poblacion Cebu 204 0 City of Naga PRC 0056007(CPA) Manila No 3 Yes 1st Level - Rank & File No No No 001-10-0002-2019 5 18 1071 94952 1900-01-01 6 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM employees_copy_copy WHERE `employees_copy_copy`.`SysPK_Empl` = 7
7 0 607 na NULL 01-10-0003-2019 NULL 2019-11-26 Ma. Alpha P. Alojado Ma. Alpha Pabalenas Alojado City of Naga,Cebu 1961-07-06 Female Married 0 111-222-333 98765 111-333-222 111-222-444 No 28 10 1 Monthly 3322.6 99678 1986-11-17 1986-11-17 NULL Active 3 1 1 False True NO 1 1 City of Naga 9200 Poblacion Cebu City of Naga Cebu 207 0 No 3 Yes 1st Level - Rank & File No No No 001-10-0003-2019 10 28 8751 99678 1900-01-01 7 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM employees_copy_copy WHERE `employees_copy_copy`.`SysPK_Empl` = 9
9 30798 30798 DUPLICATE NULL 01-10-0005-2019 NULL 2019-11-26 Flordelis L. Ababa Flordelis Lapining Ababa City of Naga,Cebu 1961-09-20 Female Married 3 111-222-333 317-987-876 111-222-333 111-222-233 No 149 I 7 1 Monthly 2852.5 85575 1990-03-01 1990-03-01 NULL Inactive 3 1 False True NO 1 1 City of Naga 9200 Poblacion Cebu City of Naga Cebu 197 0 No 3 Yes 2nd Level - Middle Mgt. No No No 001-10-0005-2019 7 24 I 708 85575 2017-02-16 4 2021-02-24
Edit Edit Copy Copy Delete Delete
DELETE FROM employees_copy_copy WHERE `employees_copy_copy`.`SysPK_Empl` = 10
10 0 746 na NULL 1998-0720-077 NULL 2019-11-26 Grace S. Marquez Grace Sayago Marquez City of Naga,Cebu 09322056720 [email protected] 1969-12-13 1.625 57 Female Married 1 2001541378 061313462-2 185-83-0999 120000-03-6760 0701-156335-11 No 71 13 1 Monthly 2116.96 63509 1998-07-20 1998-07-20 NULL Active 3 1 1 False True NO 1 1 City of Naga 9200 Poblacion Cebu City of Naga Cebu 178 0 GSIS CRN 000-6131-3462-2 No 3 Yes 1st Level - Rank & File No No No 001-10-0006-2019 13 72 0004 0 1900-01-01 2 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM employees_copy_copy WHERE `employees_copy_copy`.`SysPK_Empl` = 12
12 0 80596 MERGE NULL 01-10-0005-2019 NULL 2019-11-26 Vivira P. Ababa Vivira Pansoy Ababa City of Naga,Cebu 1978-10-21 Female Married 3 111-222-333 317-987-876 111-222-333 111-222-333 No 79 I 6 1 Daily 368.18 11045.4 2017-01-03 2017-01-03 NULL Active 4 1 False True NO 1 1 City of Naga 9200 Poblacion Cebu City of Naga Cebu 23 0 No 4 Yes 1st Level - Rank & File No No No NULL 6 5 I NI 11045.4 1900-01-01 1 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM employees_copy_copy WHERE `employees_copy_copy`.`SysPK_Empl` = 13
13 0 819 na NULL 01-10-0002-2019 NULL 2019-11-26 Hannah Debb P. Chua Hannah Debb Plarisan Chua City of Naga,Cebu 1995-12-08 Female Single 0 111-222-333 317-123-467 111-222-333 111-222-333 No 38 6 1 Monthly 435.33 13060 2016-01-18 2016-01-18 NULL Active 3 1 1 False True NO 1 1 City of Naga 9200 Poblacion Cebu City of Naga Cebu 46 0 No 3 No 1st Level - Rank & File No No No NULL 6 38 1091 13060 1900-01-01 1 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM employees_copy_copy WHERE `employees_copy_copy`.`SysPK_Empl` = 15
15 30802 30802 MERGE NULL 01-10-0001-2019 NULL 2019-11-26 Letecia F. Abangan Letecia Felices Abangan City of Naga,Cebu 09223234010 N/A 1985-10-24 1.52 56 Female Married 3 53081402414 N/A 155-453-829-000 120000851103 1640-00063863 No O 123 25 1 Monthly 2852.5 85575 2019-07-01 2019-07-01 NULL Active 8 1 False True NO 1 1 City of Naga 9200 Poblacion Cebu City of Naga Cebu 197 9 No 8 Yes 3rd Level - Top Mgt. No No No NULL 25 123 8 85575 1900-01-01 7 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM employees_copy_copy WHERE `employees_copy_copy`.`SysPK_Empl` = 18
18 0 616 na NULL 1993-0917-051 NULL 2019-11-26 Angelita C. Generale Angelita Camomot Generale City of Naga,Cebu 09267894721 [email protected] 1962-03-06 65 Kilograms 1.57 Female Married 3 62030601845 06-1319152-6 103-731-061 12-000003650-7 1640-0002-8259 No O+ 27 16 1 Monthly 3165.06 94952 1993-09-17 1993-09-17 NULL Active 3 1 1 False True NO 1 1 City of Naga 6037 AGUINALDO STREET WEST POBLACION Cebu City of Naga 6037 AGUINALDO STREET WEST POBLACION Cebu 204 0 CEBU CITY 1993-0917-051 CITY OF NAGA No 3 Yes 1st Level - Rank & File No No No NULL 16 27 1051 0 1900-01-01 1 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM employees_copy_copy WHERE `employees_copy_copy`.`SysPK_Empl` = 19
19 0 615 na NULL 01-11-0005-2019 NULL 2019-11-26 Eva R. Laput Eva Rosales Laput City of Naga,Cebu 09238232636 [email protected] 1972-09-11 62 1.62 Female Married 0 72091100763 06-1366020-6 183-621-720 12-000003674-4 070110225003 No 116 III 16 1 Monthly 1234.2 37026 1994-07-01 1994-07-01 NULL Active 3 1 1 False True NO 1 1 City of Naga 6037 TUYAN Cebu City of Naga 6037 TUYAN Cebu 143 0 NAGA CEBU No 3 Yes 1st Level - Rank & File No No No NULL 16 116 III 1051 0 1900-01-01 4 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM employees_copy_copy WHERE `employees_copy_copy`.`SysPK_Empl` = 20
20 0 107 na NULL EMP-11-0001-2019 NULL 2019-11-26 Harlem N. Alberto Harlem Nerosa Alberto City of Naga,Cebu 253-4619 [email protected] 1973-05-30 60kg 1.5m Male Single 0 282-031-860 12-050825095-4 No O+ 79 25 1 Daily 492.31 10392.31 2007-08-04 2007-08-04 NULL Active 1 1 1 False True NO 1 1 846 City of Naga 6037 San Francisco West Poblacion Cebu 846 City of Naga 6037 San Francisco West Poblacion Cebu 15 5 City of Naga No 1 Yes 1st Level - Rank & File No No No NULL 25 79 1021 0 1900-01-01 1 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM employees_copy_copy WHERE `employees_copy_copy`.`SysPK_Empl` = 21
21 0 373 na NULL EMP-11-0002-2019 NULL 2019-11-26 Marlon A. Alfajardo Marlon Atienza Alfajardo City of Naga,Cebu 5135849 1957-08-20 50kg 1.62m Male Single 0 02003516764 06-05549720 263-342-005 12-000089992-0 076484112307 No A 145 1 1 Monthly 410.3 12309 2008-10-02 2008-10-02 NULL Active 3 1 1 False True NO 1 1 436 City of Naga 6037 National Road East Poblacion Cebu 436 City of Naga 6037 National Road East Poblacion Cebu 38 0 City of Naga No 3 Yes 1st Level - Rank & File No No No NULL 1 145 1011 12309 1900-01-01 1 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM employees_copy_copy WHERE `employees_copy_copy`.`SysPK_Empl` = 23
23 0 374 na NULL EMP-11-0003-2019 NULL 2019-11-26 Minnie C. Abangan Minnie Cabigas Abangan City of Naga,Cebu 09289040546/09065340084 [email protected] 1966-03-02 50 1.56 Female Married 0 CM-3257251 061073275-5 136-293-407 12-000003597-7 1640-0002-9414 No O 47 8 1 Monthly 867.16 26015 1990-03-01 2019-11-19 NULL Active 3 1 1 False True NO 1 1 City of Naga 6037 NAALAD Cebu City of Naga 6037 NAALAD Cebu 114 0 CEBU No 3 Yes 1st Level - Rank & File No No No NULL 8 47 1011-11 0 1900-01-01 7 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM employees_copy_copy WHERE `employees_copy_copy`.`SysPK_Empl` = 24
24 0 546 na NULL EMP-11-0004-2019 NULL 2019-11-26 Jose Ramiro P. Hilado Jose Ramiro Porquez Hilado City of Naga,Cebu 1954-08-24 1.54 95 Male Married 0 109-350-164 No b 124 28 1 Daily 1534.66 46040 2012-01-05 2012-01-05 NULL Inactive 15 1 False True NO 1 1 City of Naga 9200 Poblacion Cebu City of Naga Cebu 157 1 No 15 Yes 1st Level - Rank & File No No No NULL 28 124 0804 46040 2014-10-21 4 2021-02-24
Edit Edit Copy Copy Delete Delete
DELETE FROM employees_copy_copy WHERE `employees_copy_copy`.`SysPK_Empl` = 25
25 0 372 na NULL EMP-11-0004-2019 NULL 2019-11-26 Iris Mariani B. Algabre Iris Mariani Bonghanoy Algabre City of Naga,Cebu 1996-11-13 Female Single 3 111-222-333 317-987-876 111-222-333 111-222-333 No 107 1 1 Daily 915.93 27478 2018-11-19 2018-11-19 NULL Active 15 1 False True NO 1 1 City of Naga 9200 Poblacion Cebu City of Naga Cebu 118 1 No 15 Yes 1st Level - Rank & File No No No NULL 1 107 2 27478 2014-10-21 1 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM employees_copy_copy WHERE `employees_copy_copy`.`SysPK_Empl` = 26
26 0 333 na NULL EMP-11-0004-2019 NULL 2019-11-26 Rodolfo A. Tomada Rodolfo Arquino Tomada City of Naga,Cebu 1947-01-01 Male Married 3 111-222-333 317-987-876 111-222-333 111-222-111 No 126 38 1 Daily 502.73 15082 2018-07-02 2018-07-02 NULL Inactive 15 1 False True NO 1 1 City of Naga 9200 Poblacion Cebu City of Naga Cebu 64 1 No 15 Yes 1st Level - Rank & File No No No NULL 38 126 101117 15082 1900-01-01 1 2021-02-24
Edit Edit Copy Copy Delete Delete
DELETE FROM employees_copy_copy WHERE `employees_copy_copy`.`SysPK_Empl` = 27
27 0 370 na NULL EMP-11-0004-2019 NULL 2019-11-26 Nilo B. Alinsonorin Nilo Base Alinsonorin City of Naga,Cebu N/A N/A 1954-02-19 1.7 70 Male Married 3 54022001208 N/A 228-443-801-000 19-000309666-5 1640-00063876 No AB 126 I 1 1 Daily 502.73 15082 2016-09-21 2016-09-21 NULL Active 15 1 False True NO 1 1 City of Naga 9200 Poblacion Cebu City of Naga Cebu 64 0 No 15 Yes 1st Level - Rank & File No No No NULL 1 126 I 1011-32 15082 1900-01-01 4 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM employees_copy_copy WHERE `employees_copy_copy`.`SysPK_Empl` = 28
28 0 359 na NULL EMP-11-0004-2019 NULL 2019-11-26 Elmer Q. Lapitan Elmer Quiros Lapitan City of Naga,Cebu 09228756217 [email protected] 1951-09-26 1.8 90 Male Married 3 54022001208 N/A 136-259-192 12-000076389-1 164-000043803 No A+ 126 I 1 1 Daily 502.73 15082 2016-09-21 2016-09-21 NULL Active 15 1 False True NO 1 1 City of Naga 9200 Poblacion Cebu City of Naga Cebu 64 0 No 15 Yes 1st Level - Rank & File No No No NULL 1 126 I 1011-33 15082 2018-06-29 4 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM employees_copy_copy WHERE `employees_copy_copy`.`SysPK_Empl` = 29
29 0 0 na NULL EMP-11-0004-2019 NULL 2019-11-26 Rhodelia A. Viajedor Rhodelia Andrin Viajedor City of Naga,Cebu 1969-12-19 Female Married 3 111-222-333 317-987-876 111-222-333 111-222-333 No 61 1 1 Daily 1108.26 33248 2017-06-30 2017-06-30 NULL Inactive 15 1 False True NO 1 1 City of Naga 9200 Poblacion Cebu City of Naga Cebu 134 0 No 15 Yes 1st Level - Rank & File No No No NULL 1 61 1011-7 33248 2018-06-29 4 2021-02-23
Edit Edit Copy Copy Delete Delete
DELETE FROM employees_copy_copy WHERE `employees_copy_copy`.`SysPK_Empl` = 30
30 0 620 na NULL EMP-11-0004-2019 NULL 2019-11-26 Anecito G. Olmillo Anecito Gonesto Olmillo City of Naga,Cebu 1971-08-12 Male Married 3 111-222-333 317-987-876 111-222-333 111-222-333 No 61 56 1 Daily 832.66 24980 2017-03-01 2017-03-01 NULL Active 15 1 False True NO 1 1 City of Naga 9200 Poblacion Cebu City of Naga Cebu 110 0 No 15 Yes 1st Level - Rank & File No No No NULL 56 61 8811 24980 2018-06-29 4 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM employees_copy_copy WHERE `employees_copy_copy`.`SysPK_Empl` = 31
31 0 712 na NULL EMP-11-0004-2019 NULL 2019-11-26 John Richie O. Sayson John Richie Ouano Sayson City of Naga,Cebu 09176548610 [email protected] 1978-08-06 60 1.65 Male Single 0 CRN 006-0047-3423-7 0618772047 219-327-748-000 120000-68-1429 071125019602 No A+ 41 9 1 Monthly 631.13 18934 2005-01-17 2005-01-17 NULL Active 3 1 1 False True NO 1 1 Purok Lower 1 City of Naga 6037 Naalad Cebu Purok Lower 1 City of Naga 6037 Naalad Cebu 87 0 Cebu City 2005-0117-104 City of Naga,Cebu No 3 Yes 1st Level - Rank & File No No No NULL 9 41 1041 0 1900-01-01 1 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM employees_copy_copy WHERE `employees_copy_copy`.`SysPK_Empl` = 32
32 0 512 na NULL EMP-11-0004-2019 NULL 2019-11-26 Bruce Constantine U. Opura Bruce Constantine Umbay Opura City of Naga,Cebu 09156268240 [email protected] 1974-08-26 86 1.67 Male Married 0 LP-74082601132 250-670-365-000 12-000078188-1 1640-0005-7681 No AB+ 47 70 1 Monthly 493.5 14805 2006-06-22 2006-06-22 NULL Active 3 1 1 False True NO 1 1 366 City of Naga 6037 Sayson St. Central Poblacion Cebu 366 City of Naga 6037 Sayson St. Central Poblacion Cebu 62 0 Cebu City Employee ID June 25,2019 No 3 Yes 2nd Level - Middle Mgt. No No No NULL 70 47 0 1900-01-01 1 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM employees_copy_copy WHERE `employees_copy_copy`.`SysPK_Empl` = 33
33 0 367 na NULL EMP-11-0004-2019 NULL 2019-11-26 Ma. Aileen C. Cañete Ma. Aileen Chiong Cañete City of Naga,Cebu 09236161661 [email protected] 1974-02-09 1.5 55 Female Married 3 74020900541 06-1577036-9 202-985-952 12-0000781865 070154142208 No O 38 IV 1 1 Monthly 507.3 15219 1999-03-01 1999-03-01 NULL Inactive 3 1 False True NO 1 1 City of Naga 9200 Poblacion Cebu City of Naga Cebu 65 0 No 3 Yes 1st Level - Rank & File No No No NULL 1 4 II 3 15082 2015-12-08 1 2021-02-23
With selected: With selected:
Query results operations Copy to clipboard Copy to clipboard Export Export Display chart Display chart Create view Create view