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 `accempprofile`
[ Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
Full texts id EMPNO NAME POS DEPT CLASS SSS TIN PHIC HDMF TALLOWANCE CALLOWANCE MALLOWANCE CGIFT SVLEAVE PIC BRANCH ACCNO STATUS DHIRED
Edit Edit Copy Copy Delete Delete
DELETE FROM accempprofile WHERE `accempprofile`.`id` = 4
4 17220 TAGAO, MA. ANGELICA B. ASSISTANT CHIEF ACCOUNTANT ADMIN FULL TIME 012-633-0955 492-265-260 06-250528489-0 1212-0861-6216 0 0 0 0 0 0 Cabuyao 200026675811 February 13, 2018
Edit Edit Copy Copy Delete Delete
DELETE FROM accempprofile WHERE `accempprofile`.`id` = 6
6 17243 CADEVIDA, CHRISTIANEX J. I.T STAFF ADMIN FULL TIME 34-4345798-7 334-111-824 08-051567474-1 1211-7528-3478 0 0 0 0 0 CADEVIDA, CHRISTIANEX J.2919.png Cabuyao 200022810447 Active May 04, 2016
Edit Edit Copy Copy Delete Delete
DELETE FROM accempprofile WHERE `accempprofile`.`id` = 7
7 17158 ACIO, ROMMEL B. FACULTY FACULTY SENIOR FULL TIME 04-2191618-4 344-101-103 08-026125480-1 1211-7174-0890 0 0 0 0 0 0 Cabuyao 200022750808 February 13, 2018
Edit Edit Copy Copy Delete Delete
DELETE FROM accempprofile WHERE `accempprofile`.`id` = 8
8 17165 AMPO, SARAH JANE J. FACULTY FACULTY SENIOR FULL TIME 34-5927500-1 338-014-745 08-026280826-6 1212-1369-3048 0 0 0 0 0 0 Cabuyao 200025399578 February 13, 2018
Edit Edit Copy Copy Delete Delete
DELETE FROM accempprofile WHERE `accempprofile`.`id` = 9
9 17173 ANAYA, J ONARD S. FACULTY FACULTY SENIOR FULL TIME 04-1213519-4 456-231-823 08-050778177-6 1210-0669-9750 0 0 0 0 0 0 Cabuyao 200022807209 February 13, 2018
Edit Edit Copy Copy Delete Delete
DELETE FROM accempprofile WHERE `accempprofile`.`id` = 10
10 17153 ANTONIO, JOVELYN D. FACULTY FACULTY SENIOR FULL TIME 34-5888939-1 322-591-508 08-026111850-9 1211-6939-7178 0 0 0 0 0 0 Cabuyao 200025452363 February 13, 2018
Edit Edit Copy Copy Delete Delete
DELETE FROM accempprofile WHERE `accempprofile`.`id` = 11
11 17112 APOSTOL, DOMINIC B CASHIER ADMIN FULL TIME 34-2208336-9 478-911-933 08-051567555-1 1211-1184-2538 0 0 0 0 0 0 Binan 200022873511 Active February 13, 2018
Edit Edit Copy Copy Delete Delete
DELETE FROM accempprofile WHERE `accempprofile`.`id` = 12
12 17229 ARMOLLAS, MARGIL D. FACULTY COLLEGE PART TIME 0 0 0 0 0 0 Cabuyao 200022865788 February 13, 2018
Edit Edit Copy Copy Delete Delete
DELETE FROM accempprofile WHERE `accempprofile`.`id` = 13
13 17170 BALCENA, MARITES C. UTILITIES AND MAINTENANCE AIDE ADMIN FULL TIME 03-8269455-8 432-792-705 08-200829403-4 1211-1428-2586 0 0 0 0 0 0 Cabuyao 200022807225 February 13, 2018
Edit Edit Copy Copy Delete Delete
DELETE FROM accempprofile WHERE `accempprofile`.`id` = 14
14 17227 BALETA, JONE A. SECURITY OFFICER ADMIN FULL TIME 05-0913835-0 431-873-484 10-201465010-2 1211-8885-6140 0 0 0 0 0 0 Sta Rosa 200028657357 February 13, 2018
Edit Edit Copy Copy Delete Delete
DELETE FROM accempprofile WHERE `accempprofile`.`id` = 15
15 17143 BARIS, DION MOSES B. FACULTY FACULTY SENIOR FULL TIME 04-2883702-0 338-015-119 08-026280259-4 1211-9785-7648 0 0 0 0 0 0 Cabuyao 200025451693 Active February 13, 2018
Edit Edit Copy Copy Delete Delete
DELETE FROM accempprofile WHERE `accempprofile`.`id` = 16
16 17162 BARROGA, ESPERANZA B. UTILITIES AND MAINTENANCE AIDE ADMIN FULL TIME 03-8143456-0 371-037-564 08-201102554-0 1211-7575-2290 0 0 0 0 0 0 Cabuyao 200022807233 February 13, 2018
Edit Edit Copy Copy Delete Delete
DELETE FROM accempprofile WHERE `accempprofile`.`id` = 17
17 17141 BARUNDIA, RODEL D. FACULTY FACULTY COLLEGE PART TIME 198-762-241 0 0 0 0 0 0 Cabuyao 200022873465 Active February 13, 2018
Edit Edit Copy Copy Delete Delete
DELETE FROM accempprofile WHERE `accempprofile`.`id` = 18
18 17164 BAYANI, MA. CARMEN B. ADMIN FULL TIME 04-0909296-5 901-974-007 19-090201495-4 1210-3316-6270 0 0 0 0 0 0 Binan 200022807241 February 13, 2018
Edit Edit Copy Copy Delete Delete
DELETE FROM accempprofile WHERE `accempprofile`.`id` = 19
19 17132 BELGA, RONALYN B. FACULTY FACULTY SENIOR FULL TIME 04-2376516-8 310-670-247 08-051042968-4 1211-7274-4851 0 0 0 0 0 0 Cabuyao 200022805017 February 13, 2018
Edit Edit Copy Copy Delete Delete
DELETE FROM accempprofile WHERE `accempprofile`.`id` = 20
20 17163 BUCAYAN, FERLYN A. FACULTY FACULTY SENIOR FULL TIME 04-3794919-0 489-643-014 08-051560913-3 1211-8835-3902 0 0 0 0 0 0 Cabuyao 200022807257 February 13, 2018
Edit Edit Copy Copy Delete Delete
DELETE FROM accempprofile WHERE `accempprofile`.`id` = 21
21 17129 BURAGA, JOEREY A. ADMIN FULL TIME 34-6971802-4 338-056-072 08-0515766719 1211-9305-6072 0 0 0 0 0 0 Binan 200025453696 February 13, 2018
Edit Edit Copy Copy Delete Delete
DELETE FROM accempprofile WHERE `accempprofile`.`id` = 22
22 17101 BURAGA, EDWIN C. SCHOOL ADMINISTRATOR ADMIN FULL TIME 33-0910710-6 174-849-057 02-050181566-8 1211-1176-0790 0 0 0 0 0 0 Cabuyao 200022807268 February 13, 2018
Edit Edit Copy Copy Delete Delete
DELETE FROM accempprofile WHERE `accempprofile`.`id` = 23
23 17171 BURAGA, RENALYN A. ADMIN FULL TIME 01-246-7887-1 334-111-758 06-025257906-3 1211-5207-4639 0 0 0 0 0 0 Binan 200022807276 February 13, 2018
Edit Edit Copy Copy Delete Delete
DELETE FROM accempprofile WHERE `accempprofile`.`id` = 24
24 17226 CALATRAVA, ANGELITO A. FACULTY FACULTY COLLEGE PART TIME 471-844-257 0 0 0 0 0 0 Cabuyao 200028522451 February 13, 2018
Edit Edit Copy Copy Delete Delete
DELETE FROM accempprofile WHERE `accempprofile`.`id` = 25
25 17200 CALIMPUSAN, MARILOU A. GUIDANCE COUNCILOR ADMIN FULL TIME 04-1736433-9 461-684-311 08-051068456-0 1211-0692-7652 0 0 0 0 0 0 Cabuyao 200022810463 February 13, 2018
Edit Edit Copy Copy Delete Delete
DELETE FROM accempprofile WHERE `accempprofile`.`id` = 26
26 17150 CARAMAY, MA. JONALYN C. FACULTY FACULTY SENIOR FULL TIME 04-3823890-7 501-132-752 08-051553330-7 1211-9792-8096 0 0 0 0 0 0 Binan 200025451642 February 13, 2018
Edit Edit Copy Copy Delete Delete
DELETE FROM accempprofile WHERE `accempprofile`.`id` = 27
27 17211 CASILA, EDWIN T. FACULTY FACULTY COLLEGE PART TIME 0 0 0 0 0 0 Cabuyao 200022865837 February 13, 2018
Edit Edit Copy Copy Delete Delete
DELETE FROM accempprofile WHERE `accempprofile`.`id` = 28
28 17240 COLLADO, NORALLE G. FACULTY FACULTY COLLEGE PART TIME 132-817-807 0 0 0 0 0 0 Cabuyao NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM accempprofile WHERE `accempprofile`.`id` = 29
29 17176 CUARE, ARIES LAWRENCE T. FACULTY FACULTY COLLEGE PART TIME 312-264-653 0 0 0 0 0 0 Cabuyao 200022865136 February 13, 2018
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