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 `notifications`
Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
Full texts ID ParentID levels FRM_NAME PROCESSID SENDERID RECEIVERID MESSAGE TS SETTLED ACTUALID SENDTOACTUALID UserFullName
Edit Edit Copy Copy Delete Delete
DELETE FROM notifications WHERE `notifications`.`ID` = 9731
9731 0 0 Project Registration 1 0 0 Sample 2021-01-11 10:01:58 NO 0 0 VIVIRA P. ABABA
Edit Edit Copy Copy Delete Delete
DELETE FROM notifications WHERE `notifications`.`ID` = 9732
9732 0 0 Project Registration 183 0 0 Declined 2021-03-08 11:06:45 NO 0 0 Admin A. Admin
Edit Edit Copy Copy Delete Delete
DELETE FROM notifications WHERE `notifications`.`ID` = 9733
9733 0 0 Project Proposal 211 0 0 to charge under GF-capital outlay 2022-03-28 16:30:15 NO 0 0 Glenda L. Bartolabac
Edit Edit Copy Copy Delete Delete
DELETE FROM notifications WHERE `notifications`.`ID` = 9734
9734 0 0 Project Proposal 1078 0 0 include the Budget Officer in the approval list 2022-11-29 13:52:21 NO 0 0 Karla Mae T. Lara
Edit Edit Copy Copy Delete Delete
DELETE FROM notifications WHERE `notifications`.`ID` = 9735
9735 0 0 Project Proposal 1053 0 0 please check line items 2022-11-29 14:36:59 NO 0 0 Karla Mae T. Lara
Edit Edit Copy Copy Delete Delete
DELETE FROM notifications WHERE `notifications`.`ID` = 9736
9736 0 0 Project Proposal 1047 0 0 double entry please cancel/delete 2022-11-29 14:41:10 NO 0 0 Karla Mae T. Lara
Edit Edit Copy Copy Delete Delete
DELETE FROM notifications WHERE `notifications`.`ID` = 9737
9737 0 0 Project Proposal 1075 0 0 please indicate date of activity 2022-11-29 15:05:24 NO 0 0 ODON R. SAYAGO
Edit Edit Copy Copy Delete Delete
DELETE FROM notifications WHERE `notifications`.`ID` = 9738
9738 0 0 Project Proposal 1083 0 0 please indicate date of activity 2022-11-29 15:25:12 NO 0 0 ODON R. SAYAGO
Edit Edit Copy Copy Delete Delete
DELETE FROM notifications WHERE `notifications`.`ID` = 9739
9739 0 0 Purchase Request 921 0 0 duplicate PR number 2022-11-29 15:41:41 NO 0 0 Karla Mae T. Lara
Edit Edit Copy Copy Delete Delete
DELETE FROM notifications WHERE `notifications`.`ID` = 9740
9740 0 0 Project Proposal 1105 0 0 check transaction number 2022-12-01 14:47:31 NO 0 0 Karla Mae T. Lara
Edit Edit Copy Copy Delete Delete
DELETE FROM notifications WHERE `notifications`.`ID` = 9741
9741 0 0 Project Proposal 1095 0 0 change to Infra. Asset 2022-12-01 15:58:24 NO 0 0 Maria Cirifel C. Manubag
Edit Edit Copy Copy Delete Delete
DELETE FROM notifications WHERE `notifications`.`ID` = 9742
9742 0 0 Project Proposal 1116 0 0 revise articles and description 2022-12-02 10:38:00 NO 0 0 Karla Mae T. Lara
Edit Edit Copy Copy Delete Delete
DELETE FROM notifications WHERE `notifications`.`ID` = 9743
9743 0 0 Project Proposal 1117 0 0 combine with the other tarpaulin request 2022-12-02 10:39:20 NO 0 0 Karla Mae T. Lara
Edit Edit Copy Copy Delete Delete
DELETE FROM notifications WHERE `notifications`.`ID` = 9744
9744 0 0 Project Proposal 1118 0 0 no data 2022-12-02 11:38:29 NO 0 0 Karla Mae T. Lara
Edit Edit Copy Copy Delete Delete
DELETE FROM notifications WHERE `notifications`.`ID` = 9745
9745 0 0 Purchase Request 1036 0 0 duplicate 2022-12-05 16:33:30 NO 0 0 Karla Mae T. Lara
Edit Edit Copy Copy Delete Delete
DELETE FROM notifications WHERE `notifications`.`ID` = 9746
9746 0 0 Purchase Request 975 0 0 indicate purpose and delivery term 2022-12-09 10:53:21 NO 0 0 ODON R. SAYAGO
Edit Edit Copy Copy Delete Delete
DELETE FROM notifications WHERE `notifications`.`ID` = 9747
9747 0 0 Purchase Request 1155 0 0 check item description (mirriage) 2022-12-09 10:55:46 NO 0 0 Karla Mae T. Lara
Edit Edit Copy Copy Delete Delete
DELETE FROM notifications WHERE `notifications`.`ID` = 9748
9748 0 0 Purchase Request 1098 0 0 duplicate 2022-12-09 11:32:16 NO 0 0 Karla Mae T. Lara
Edit Edit Copy Copy Delete Delete
DELETE FROM notifications WHERE `notifications`.`ID` = 9749
9749 0 0 Purchase Request 1108 0 0 no amount posted 2022-12-09 16:55:34 NO 0 0 Karla Mae T. Lara
Edit Edit Copy Copy Delete Delete
DELETE FROM notifications WHERE `notifications`.`ID` = 9750
9750 0 0 Project Proposal 1231 0 0 return 2022-12-13 09:52:22 NO 0 0 Admin A. Admin
Edit Edit Copy Copy Delete Delete
DELETE FROM notifications WHERE `notifications`.`ID` = 9751
9751 0 0 Purchase Request 1056 0 0 Review PR # 2022-12-13 13:12:48 NO 0 0 Glenda L. Bartolabac
Edit Edit Copy Copy Delete Delete
DELETE FROM notifications WHERE `notifications`.`ID` = 9752
9752 0 0 Purchase Request 1055 0 0 Return 2022-12-13 13:23:10 NO 0 0 Kelvin Ray  L. Ababa
Edit Edit Copy Copy Delete Delete
DELETE FROM notifications WHERE `notifications`.`ID` = 9753
9753 0 0 Purchase Request 1057 0 0 Return
2022-12-13 13:23:32 NO 0 0 Kelvin Ray  L. Ababa
Edit Edit Copy Copy Delete Delete
DELETE FROM notifications WHERE `notifications`.`ID` = 9754
9754 0 0 Project Proposal 1230 0 0 check amount (zero) 2022-12-13 13:53:41 NO 0 0 Karla Mae T. Lara
Edit Edit Copy Copy Delete Delete
DELETE FROM notifications WHERE `notifications`.`ID` = 9755
9755 0 0 Purchase Request 988 0 0 check amount 2022-12-13 13:59:17 NO 0 0 Karla Mae T. Lara
With selected: With selected:
Query results operations Copy to clipboard Copy to clipboard Export Export Display chart Display chart Create view Create view