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
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 `tbl_logs`
[ Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
Full texts ID role fName activity dateTime
Edit Edit Copy Copy Delete Delete
DELETE FROM tbl_logs WHERE `tbl_logs`.`ID` = 14895
14895 Admin ARNNIEL, PACRIS Log in 2024-04-25 16:06:54
Edit Edit Copy Copy Delete Delete
DELETE FROM tbl_logs WHERE `tbl_logs`.`ID` = 14896
14896 Admin ARNNIEL, PACRIS Log out 2024-04-25 16:07:12
Edit Edit Copy Copy Delete Delete
DELETE FROM tbl_logs WHERE `tbl_logs`.`ID` = 14897
14897 SHS Admin ALBEROS, EVALINE Log in 2024-04-25 16:24:51
Edit Edit Copy Copy Delete Delete
DELETE FROM tbl_logs WHERE `tbl_logs`.`ID` = 14898
14898 SHS Admin ALBEROS, EVALINE Log out 2024-04-25 16:25:14
Edit Edit Copy Copy Delete Delete
DELETE FROM tbl_logs WHERE `tbl_logs`.`ID` = 14899
14899 Cashier TAGLE, HENRY Log in 2024-04-25 16:28:34
Edit Edit Copy Copy Delete Delete
DELETE FROM tbl_logs WHERE `tbl_logs`.`ID` = 14900
14900 Cashier TAGLE, HENRY Log in 2024-04-25 16:36:09
Edit Edit Copy Copy Delete Delete
DELETE FROM tbl_logs WHERE `tbl_logs`.`ID` = 14901
14901 Cashier TAGLE, HENRY Log out 2024-04-25 16:36:11
Edit Edit Copy Copy Delete Delete
DELETE FROM tbl_logs WHERE `tbl_logs`.`ID` = 14902
14902 Admin ARNNIEL, PACRIS Log in 2024-04-25 16:36:21
Edit Edit Copy Copy Delete Delete
DELETE FROM tbl_logs WHERE `tbl_logs`.`ID` = 14903
14903 Admin ARNNIEL, PACRIS Log out 2024-04-25 16:36:46
Edit Edit Copy Copy Delete Delete
DELETE FROM tbl_logs WHERE `tbl_logs`.`ID` = 14904
14904 Cashier TAGLE, HENRY Log in 2024-04-26 10:01:21
Edit Edit Copy Copy Delete Delete
DELETE FROM tbl_logs WHERE `tbl_logs`.`ID` = 14905
14905 Cashier TAGLE, HENRY Insert Fee 2024-04-26 10:02:42
Edit Edit Copy Copy Delete Delete
DELETE FROM tbl_logs WHERE `tbl_logs`.`ID` = 14906
14906 Cashier TAGLE, HENRY Log out 2024-04-26 10:03:15
Edit Edit Copy Copy Delete Delete
DELETE FROM tbl_logs WHERE `tbl_logs`.`ID` = 14907
14907 Cashier TAGLE, HENRY Log in 2024-04-26 12:43:12
Edit Edit Copy Copy Delete Delete
DELETE FROM tbl_logs WHERE `tbl_logs`.`ID` = 14908
14908 Cashier TAGLE, HENRY Log out 2024-04-26 12:43:55
Edit Edit Copy Copy Delete Delete
DELETE FROM tbl_logs WHERE `tbl_logs`.`ID` = 14909
14909 Admin ARNNIEL, PACRIS Log in 2024-04-26 12:44:01
Edit Edit Copy Copy Delete Delete
DELETE FROM tbl_logs WHERE `tbl_logs`.`ID` = 14910
14910 Admin ARNNIEL, PACRIS Log out 2024-04-26 12:44:06
Edit Edit Copy Copy Delete Delete
DELETE FROM tbl_logs WHERE `tbl_logs`.`ID` = 14911
14911 Cashier TAGLE, HENRY Log in 2024-04-26 12:46:30
Edit Edit Copy Copy Delete Delete
DELETE FROM tbl_logs WHERE `tbl_logs`.`ID` = 14912
14912 Cashier TAGLE, HENRY Log out 2024-04-26 12:46:46
Edit Edit Copy Copy Delete Delete
DELETE FROM tbl_logs WHERE `tbl_logs`.`ID` = 14913
14913 Cashier TAGLE, HENRY Log in 2024-04-26 15:24:54
Edit Edit Copy Copy Delete Delete
DELETE FROM tbl_logs WHERE `tbl_logs`.`ID` = 14914
14914 Cashier TAGLE, HENRY Insert Fee 2024-04-26 15:25:40
Edit Edit Copy Copy Delete Delete
DELETE FROM tbl_logs WHERE `tbl_logs`.`ID` = 14915
14915 Cashier TAGLE, HENRY Log out 2024-04-26 15:26:13
Edit Edit Copy Copy Delete Delete
DELETE FROM tbl_logs WHERE `tbl_logs`.`ID` = 14916
14916 Admin ARNNIEL, PACRIS Log in 2024-04-29 08:52:19
Edit Edit Copy Copy Delete Delete
DELETE FROM tbl_logs WHERE `tbl_logs`.`ID` = 14917
14917 Admin ARNNIEL, PACRIS Log out 2024-04-29 08:52:29
Edit Edit Copy Copy Delete Delete
DELETE FROM tbl_logs WHERE `tbl_logs`.`ID` = 14918
14918 Admin ARNNIEL, PACRIS Log in 2024-05-14 18:05:42
Edit Edit Copy Copy Delete Delete
DELETE FROM tbl_logs WHERE `tbl_logs`.`ID` = 14919
14919 Admin ARNNIEL, PACRIS Log out 2024-05-14 18:06:13
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