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 `usermanagement` ORDER BY `umacmanager` DESC 
[ Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
Full texts usrmgtid umacholder umacmanager Descending Ascending 1 umuser umstartdate umenddate umstatus
Y=active, N=inactive, H=hold
ownerid
Edit Edit Copy Copy Delete Delete
DELETE FROM usermanagement WHERE `usermanagement`.`usrmgtid` = 303
303 479 479 479 2025-08-18 NULL Y 043204070432040704320407
Edit Edit Copy Copy Delete Delete
DELETE FROM usermanagement WHERE `usermanagement`.`usrmgtid` = 302
302 478 478 478 2025-07-02 NULL Y 043104110431041104310411
Edit Edit Copy Copy Delete Delete
DELETE FROM usermanagement WHERE `usermanagement`.`usrmgtid` = 309
309 478 478 481 2025-12-02 NULL Y 043404170431041104310411
Edit Edit Copy Copy Delete Delete
DELETE FROM usermanagement WHERE `usermanagement`.`usrmgtid` = 290
290 478 478 466 2025-01-14 NULL Y 041904090105042001050420
Edit Edit Copy Copy Delete Delete
DELETE FROM usermanagement WHERE `usermanagement`.`usrmgtid` = 299
299 473 473 474 2025-05-10 NULL Y 042704080426041104260411
Edit Edit Copy Copy Delete Delete
DELETE FROM usermanagement WHERE `usermanagement`.`usrmgtid` = 274
274 462 462 463 2024-11-03 2025-12-14 N 041604090415040404150404
Edit Edit Copy Copy Delete Delete
DELETE FROM usermanagement WHERE `usermanagement`.`usrmgtid` = 273
273 462 462 462 2024-10-29 2025-12-14 N 040120100415040404150404
Edit Edit Copy Copy Delete Delete
DELETE FROM usermanagement WHERE `usermanagement`.`usrmgtid` = 287
287 462 462 183 2024-12-05 2025-12-14 N 014904080415040404150404
Edit Edit Copy Copy Delete Delete
DELETE FROM usermanagement WHERE `usermanagement`.`usrmgtid` = 288
288 462 462 464 2024-12-28 2025-10-27 N 041704200415040404150404
Edit Edit Copy Copy Delete Delete
DELETE FROM usermanagement WHERE `usermanagement`.`usrmgtid` = 265
265 68 451 425 2024-06-22 2024-11-21 N 037804100404042000681707
Edit Edit Copy Copy Delete Delete
DELETE FROM usermanagement WHERE `usermanagement`.`usrmgtid` = 257
257 451 451 446 2024-02-17 2024-06-22 N 039904170404042004040420
Edit Edit Copy Copy Delete Delete
DELETE FROM usermanagement WHERE `usermanagement`.`usrmgtid` = 256
256 451 451 425 2024-02-17 2024-06-22 N 037804100404042004040420
Edit Edit Copy Copy Delete Delete
DELETE FROM usermanagement WHERE `usermanagement`.`usrmgtid` = 258
258 451 451 445 2024-02-17 2024-06-22 N 039804170404042004040420
Edit Edit Copy Copy Delete Delete
DELETE FROM usermanagement WHERE `usermanagement`.`usrmgtid` = 267
267 68 451 445 2024-06-22 2024-11-21 N 039804170404042000681707
Edit Edit Copy Copy Delete Delete
DELETE FROM usermanagement WHERE `usermanagement`.`usrmgtid` = 264
264 68 451 365 2024-06-22 2024-11-21 N 031804160404042000681707
Edit Edit Copy Copy Delete Delete
DELETE FROM usermanagement WHERE `usermanagement`.`usrmgtid` = 255
255 451 451 365 2024-02-17 2024-06-22 N 031804160404042004040420
Edit Edit Copy Copy Delete Delete
DELETE FROM usermanagement WHERE `usermanagement`.`usrmgtid` = 266
266 68 451 446 2024-06-22 2024-11-21 N 039904170404042000681707
Edit Edit Copy Copy Delete Delete
DELETE FROM usermanagement WHERE `usermanagement`.`usrmgtid` = 279
279 433 433 458 2024-11-06 2025-10-22 N 041104100386192303861923
Edit Edit Copy Copy Delete Delete
DELETE FROM usermanagement WHERE `usermanagement`.`usrmgtid` = 278
278 433 433 368 2024-11-06 2024-12-28 N 032104100386192303861923
Edit Edit Copy Copy Delete Delete
DELETE FROM usermanagement WHERE `usermanagement`.`usrmgtid` = 277
277 433 433 183 2024-11-06 2024-12-05 N 014904080386192303861923
Edit Edit Copy Copy Delete Delete
DELETE FROM usermanagement WHERE `usermanagement`.`usrmgtid` = 276
276 433 433 444 2024-11-06 2024-11-21 N 039704170386192303861923
Edit Edit Copy Copy Delete Delete
DELETE FROM usermanagement WHERE `usermanagement`.`usrmgtid` = 275
275 433 433 207 2024-11-06 2024-11-21 N 017204100386192303861923
Edit Edit Copy Copy Delete Delete
DELETE FROM usermanagement WHERE `usermanagement`.`usrmgtid` = 280
280 433 433 433 2024-11-07 2024-12-28 N 4110410038619230386192303861923
Edit Edit Copy Copy Delete Delete
DELETE FROM usermanagement WHERE `usermanagement`.`usrmgtid` = 226
226 430 430 425 2023-01-18 2024-02-17 N 037804100383041103830411
Edit Edit Copy Copy Delete Delete
DELETE FROM usermanagement WHERE `usermanagement`.`usrmgtid` = 229
229 430 430 365 2023-01-26 2024-02-17 N 031804160383041103830411
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