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 `SysUsersGroups`
[ Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
Full texts id idUserAccess idGroup accessLevel indateCreated indateModified idUserAccessCreated idUserAccessModified idLogAccess isDeleted
Edit Edit Copy Copy Delete Delete
DELETE FROM SysUsersGroups WHERE `SysUsersGroups`.`id` = 219 AND `SysUsersGroups`.`idUserAccess` = 17 AND `SysUsersGroups`.`idGroup` = 3
219 17 3 0 1652856265 1652856265 NULL NULL 2022050000000013175 0
Edit Edit Copy Copy Delete Delete
DELETE FROM SysUsersGroups WHERE `SysUsersGroups`.`id` = 221 AND `SysUsersGroups`.`idUserAccess` = 17 AND `SysUsersGroups`.`idGroup` = 6
221 17 6 0 1652856265 1652856265 NULL NULL 2022050000000013175 0
Edit Edit Copy Copy Delete Delete
DELETE FROM SysUsersGroups WHERE `SysUsersGroups`.`id` = 223 AND `SysUsersGroups`.`idUserAccess` = 19 AND `SysUsersGroups`.`idGroup` = 3
223 19 3 0 1652856265 1652856265 NULL NULL 2022050000000013175 0
Edit Edit Copy Copy Delete Delete
DELETE FROM SysUsersGroups WHERE `SysUsersGroups`.`id` = 225 AND `SysUsersGroups`.`idUserAccess` = 19 AND `SysUsersGroups`.`idGroup` = 6
225 19 6 0 1652856265 1652856265 NULL NULL 2022050000000013175 0
Edit Edit Copy Copy Delete Delete
DELETE FROM SysUsersGroups WHERE `SysUsersGroups`.`id` = 227 AND `SysUsersGroups`.`idUserAccess` = 21 AND `SysUsersGroups`.`idGroup` = 3
227 21 3 0 1652856265 1652856265 NULL NULL 2022050000000013175 0
Edit Edit Copy Copy Delete Delete
DELETE FROM SysUsersGroups WHERE `SysUsersGroups`.`id` = 229 AND `SysUsersGroups`.`idUserAccess` = 21 AND `SysUsersGroups`.`idGroup` = 6
229 21 6 0 1652856265 1652856265 NULL NULL 2022050000000013175 0
Edit Edit Copy Copy Delete Delete
DELETE FROM SysUsersGroups WHERE `SysUsersGroups`.`id` = 235 AND `SysUsersGroups`.`idUserAccess` = 25 AND `SysUsersGroups`.`idGroup` = 3
235 25 3 0 1652856265 1652856265 NULL NULL 2022050000000013175 0
Edit Edit Copy Copy Delete Delete
DELETE FROM SysUsersGroups WHERE `SysUsersGroups`.`id` = 237 AND `SysUsersGroups`.`idUserAccess` = 25 AND `SysUsersGroups`.`idGroup` = 6
237 25 6 0 1652856265 1652856265 NULL NULL 2022050000000013175 0
Edit Edit Copy Copy Delete Delete
DELETE FROM SysUsersGroups WHERE `SysUsersGroups`.`id` = 239 AND `SysUsersGroups`.`idUserAccess` = 27 AND `SysUsersGroups`.`idGroup` = 3
239 27 3 0 1652856265 1652856265 NULL NULL 2022050000000013175 0
Edit Edit Copy Copy Delete Delete
DELETE FROM SysUsersGroups WHERE `SysUsersGroups`.`id` = 241 AND `SysUsersGroups`.`idUserAccess` = 27 AND `SysUsersGroups`.`idGroup` = 6
241 27 6 0 1652856265 1652856265 NULL NULL 2022050000000013175 0
Edit Edit Copy Copy Delete Delete
DELETE FROM SysUsersGroups WHERE `SysUsersGroups`.`id` = 243 AND `SysUsersGroups`.`idUserAccess` = 29 AND `SysUsersGroups`.`idGroup` = 3
243 29 3 0 1652856265 1652856265 NULL NULL 2022050000000013175 0
Edit Edit Copy Copy Delete Delete
DELETE FROM SysUsersGroups WHERE `SysUsersGroups`.`id` = 245 AND `SysUsersGroups`.`idUserAccess` = 29 AND `SysUsersGroups`.`idGroup` = 6
245 29 6 0 1652856265 1652856265 NULL NULL 2022050000000013175 0
Edit Edit Copy Copy Delete Delete
DELETE FROM SysUsersGroups WHERE `SysUsersGroups`.`id` = 247 AND `SysUsersGroups`.`idUserAccess` = 31 AND `SysUsersGroups`.`idGroup` = 3
247 31 3 0 1652856265 1652856265 NULL NULL 2022050000000013175 0
Edit Edit Copy Copy Delete Delete
DELETE FROM SysUsersGroups WHERE `SysUsersGroups`.`id` = 249 AND `SysUsersGroups`.`idUserAccess` = 31 AND `SysUsersGroups`.`idGroup` = 6
249 31 6 0 1652856265 1652856265 NULL NULL 2022050000000013175 0
Edit Edit Copy Copy Delete Delete
DELETE FROM SysUsersGroups WHERE `SysUsersGroups`.`id` = 251 AND `SysUsersGroups`.`idUserAccess` = 33 AND `SysUsersGroups`.`idGroup` = 3
251 33 3 0 1652856265 1652856265 NULL NULL 2022050000000013175 0
Edit Edit Copy Copy Delete Delete
DELETE FROM SysUsersGroups WHERE `SysUsersGroups`.`id` = 253 AND `SysUsersGroups`.`idUserAccess` = 33 AND `SysUsersGroups`.`idGroup` = 6
253 33 6 0 1652856265 1652856265 NULL NULL 2022050000000013175 0
Edit Edit Copy Copy Delete Delete
DELETE FROM SysUsersGroups WHERE `SysUsersGroups`.`id` = 255 AND `SysUsersGroups`.`idUserAccess` = 35 AND `SysUsersGroups`.`idGroup` = 3
255 35 3 0 1652856265 1652856265 NULL NULL 2022050000000013175 0
Edit Edit Copy Copy Delete Delete
DELETE FROM SysUsersGroups WHERE `SysUsersGroups`.`id` = 257 AND `SysUsersGroups`.`idUserAccess` = 35 AND `SysUsersGroups`.`idGroup` = 6
257 35 6 0 1652856265 1652856265 NULL NULL 2022050000000013175 0
Edit Edit Copy Copy Delete Delete
DELETE FROM SysUsersGroups WHERE `SysUsersGroups`.`id` = 259 AND `SysUsersGroups`.`idUserAccess` = 37 AND `SysUsersGroups`.`idGroup` = 3
259 37 3 0 1652856265 1652856265 NULL NULL 2022050000000013175 0
Edit Edit Copy Copy Delete Delete
DELETE FROM SysUsersGroups WHERE `SysUsersGroups`.`id` = 261 AND `SysUsersGroups`.`idUserAccess` = 37 AND `SysUsersGroups`.`idGroup` = 6
261 37 6 0 1652856265 1652856265 NULL NULL 2022050000000013175 0
Edit Edit Copy Copy Delete Delete
DELETE FROM SysUsersGroups WHERE `SysUsersGroups`.`id` = 263 AND `SysUsersGroups`.`idUserAccess` = 39 AND `SysUsersGroups`.`idGroup` = 3
263 39 3 0 1652856265 1652856265 NULL NULL 2022050000000013175 0
Edit Edit Copy Copy Delete Delete
DELETE FROM SysUsersGroups WHERE `SysUsersGroups`.`id` = 265 AND `SysUsersGroups`.`idUserAccess` = 39 AND `SysUsersGroups`.`idGroup` = 6
265 39 6 0 1652856265 1652856265 NULL NULL 2022050000000013175 0
Edit Edit Copy Copy Delete Delete
DELETE FROM SysUsersGroups WHERE `SysUsersGroups`.`id` = 267 AND `SysUsersGroups`.`idUserAccess` = 41 AND `SysUsersGroups`.`idGroup` = 3
267 41 3 0 1652856266 1652856266 NULL NULL 2022050000000013175 0
Edit Edit Copy Copy Delete Delete
DELETE FROM SysUsersGroups WHERE `SysUsersGroups`.`id` = 269 AND `SysUsersGroups`.`idUserAccess` = 41 AND `SysUsersGroups`.`idGroup` = 6
269 41 6 0 1652856266 1652856266 NULL NULL 2022050000000013175 0
Edit Edit Copy Copy Delete Delete
DELETE FROM SysUsersGroups WHERE `SysUsersGroups`.`id` = 271 AND `SysUsersGroups`.`idUserAccess` = 43 AND `SysUsersGroups`.`idGroup` = 3
271 43 3 0 1652856266 1652856266 NULL NULL 2022050000000013175 0
With selected: With selected:
Query results operations Copy to clipboard Copy to clipboard Export Export Display chart Display chart Create view Create view