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 `SysAuthSecurity`
[ Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
Full texts id idUserAccess triesLeft lastTry indateExpire indateCreated indateModified idLogAccess isDeleted
Edit Edit Copy Copy Delete Delete
DELETE FROM SysAuthSecurity WHERE `SysAuthSecurity`.`id` = 1
1 2 10 1790152057 1790238457 1651138149 1790152057 2026090000000035555 0
Edit Edit Copy Copy Delete Delete
DELETE FROM SysAuthSecurity WHERE `SysAuthSecurity`.`id` = 2
2 3 10 1652863563 1652949963 1651217734 1652863563 2022050000000011940 0
Edit Edit Copy Copy Delete Delete
DELETE FROM SysAuthSecurity WHERE `SysAuthSecurity`.`id` = 3
3 7 10 1651470931 1651557331 1651470817 1651470931 2022050000000000044 0
Edit Edit Copy Copy Delete Delete
DELETE FROM SysAuthSecurity WHERE `SysAuthSecurity`.`id` = 4
4 8 10 1652434409 1652520809 1652074305 1652434410 2022050000000010009 0
Edit Edit Copy Copy Delete Delete
DELETE FROM SysAuthSecurity WHERE `SysAuthSecurity`.`id` = 5
5 5 10 1652526077 1652612477 1652097592 1652526078 2022050000000010687 0
Edit Edit Copy Copy Delete Delete
DELETE FROM SysAuthSecurity WHERE `SysAuthSecurity`.`id` = 6
6 9 10 1652166610 1652253010 1652166611 1652166611 2022050000000006550 0
Edit Edit Copy Copy Delete Delete
DELETE FROM SysAuthSecurity WHERE `SysAuthSecurity`.`id` = 7
7 4 10 1652168768 1652255168 1652168768 1652168768 2022050000000006651 0
Edit Edit Copy Copy Delete Delete
DELETE FROM SysAuthSecurity WHERE `SysAuthSecurity`.`id` = 8
8 11 10 1652172700 1652259100 1652171948 1652172700 2022050000000006711 0
Edit Edit Copy Copy Delete Delete
DELETE FROM SysAuthSecurity WHERE `SysAuthSecurity`.`id` = 9
9 10 10 1652172569 1652258969 1652172570 1652172570 2022050000000006702 0
Edit Edit Copy Copy Delete Delete
DELETE FROM SysAuthSecurity WHERE `SysAuthSecurity`.`id` = 10
10 1 0 1789481639 1789568039 1652178812 1789481639 2026090000000024752 0
Edit Edit Copy Copy Delete Delete
DELETE FROM SysAuthSecurity WHERE `SysAuthSecurity`.`id` = 11
11 240 10 1652353270 1652439670 1652353270 1652353270 2022050000000008443 0
Edit Edit Copy Copy Delete Delete
DELETE FROM SysAuthSecurity WHERE `SysAuthSecurity`.`id` = 12
12 241 10 1652353318 1652439718 1652353319 1652353319 2022050000000008462 0
Edit Edit Copy Copy Delete Delete
DELETE FROM SysAuthSecurity WHERE `SysAuthSecurity`.`id` = 13
13 16 10 1652359232 1652445632 1652359232 1652359232 2022050000000009356 0
Edit Edit Copy Copy Delete Delete
DELETE FROM SysAuthSecurity WHERE `SysAuthSecurity`.`id` = 14
14 293 10 1652360636 1652447036 1652360636 1652360636 2022050000000009433 0
Edit Edit Copy Copy Delete Delete
DELETE FROM SysAuthSecurity WHERE `SysAuthSecurity`.`id` = 15
15 294 10 1652360770 1652447170 1652360771 1652360771 2022050000000009458 0
Edit Edit Copy Copy Delete Delete
DELETE FROM SysAuthSecurity WHERE `SysAuthSecurity`.`id` = 16
16 115 10 1665734331 1665820731 1655903603 1665734331 2022100000000000638 0
Edit Edit Copy Copy Delete Delete
DELETE FROM SysAuthSecurity WHERE `SysAuthSecurity`.`id` = 17
17 117 10 1786095699 1786182099 1655903769 1786095699 2026080000000000376 0
Edit Edit Copy Copy Delete Delete
DELETE FROM SysAuthSecurity WHERE `SysAuthSecurity`.`id` = 18
18 49 10 1666591133 1666677533 1655906073 1666591133 2022100000000003498 0
Edit Edit Copy Copy Delete Delete
DELETE FROM SysAuthSecurity WHERE `SysAuthSecurity`.`id` = 19
19 662 10 1786095724 1786182124 1656585605 1786095724 2026080000000000389 0
Edit Edit Copy Copy Delete Delete
DELETE FROM SysAuthSecurity WHERE `SysAuthSecurity`.`id` = 20
20 664 10 1674720181 1674806581 1656661115 1674720181 2023010000000005580 0
Edit Edit Copy Copy Delete Delete
DELETE FROM SysAuthSecurity WHERE `SysAuthSecurity`.`id` = 21
21 113 10 1664265423 1664351823 1656661794 1664265424 2022090000000000981 0
Edit Edit Copy Copy Delete Delete
DELETE FROM SysAuthSecurity WHERE `SysAuthSecurity`.`id` = 22
22 45 10 1664266483 1664352883 1664266292 1664266484 2022090000000001131 0
Edit Edit Copy Copy Delete Delete
DELETE FROM SysAuthSecurity WHERE `SysAuthSecurity`.`id` = 23
23 23 10 1664276356 1664362756 1664276356 1664276356 2022090000000001493 0
Edit Edit Copy Copy Delete Delete
DELETE FROM SysAuthSecurity WHERE `SysAuthSecurity`.`id` = 24
24 468 10 1673596477 1673682877 1666157094 1673596477 2023010000000001895 0
Edit Edit Copy Copy Delete Delete
DELETE FROM SysAuthSecurity WHERE `SysAuthSecurity`.`id` = 25
25 1276 10 1673529547 1673615947 1666254402 1673529547 2023010000000001177 0
With selected: With selected:
Query results operations Copy to clipboard Copy to clipboard Export Export Display chart Display chart Create view Create view