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 :
Customise 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 `personnel_employee` ORDER BY `update_time` DESC
[ Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
|
|
|
|
Filter rows:
Sort by key:
Full texts id create_time create_user change_time change_user status emp_code first_name last_name nickname passport driver_license_automobile driver_license_motorcycle photo self_password device_password dev_privilege card_no acc_group acc_timezone gender birthday address postcode office_tel contact_tel mobile national religion title enroll_sn ssn update_time Descending Ascending 1 hire_date verify_mode city emp_type enable_payroll app_status app_role email last_login is_active session_key login_ip department_id position_id leave_group emp_code_digit superior_id company_id password_reset
Edit Edit Copy Copy Delete Delete
DELETE FROM personnel_employee WHERE `personnel_employee`.`id` = 337
 		337 2025-09-22 18:41:47.224116 NULL 2025-09-22 18:41:47.224116 NULL 0 11288 NULL NULL NULL NULL NULL pbkdf2_sha256$390000$WCnWyX1cNkZMoSivYOQAQp$IWyHlQ... 0 NULL 1 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL MED7243700309 NULL 2025-09-22 18:41:47.269964 2025-09-22 0 NULL NULL 1 0 1 NULL NULL 0 NULL NULL 1 NULL NULL 11288 NULL 1 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM personnel_employee WHERE `personnel_employee`.`id` = 336
 		336 2025-09-22 18:41:46.976752 NULL 2025-09-22 18:41:46.976752 NULL 0 11138 NULL NULL NULL NULL NULL pbkdf2_sha256$390000$Bo2HVIAN0dMRVm0jABaHTb$94l0tX... 0 NULL 1 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL MED7243700309 NULL 2025-09-22 18:41:47.030671 2025-09-22 0 NULL NULL 1 0 1 NULL NULL 0 NULL NULL 1 NULL NULL 11138 NULL 1 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM personnel_employee WHERE `personnel_employee`.`id` = 335
 		335 2025-09-22 18:41:46.741359 NULL 2025-09-22 18:41:46.741359 NULL 0 10046 NULL NULL NULL NULL NULL pbkdf2_sha256$390000$UOmF1LaJZePZgiIKl6Zzh4$OOPZk2... 0 NULL 1 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL MED7243700309 NULL 2025-09-22 18:41:46.786247 2025-09-22 0 NULL NULL 1 0 1 NULL NULL 0 NULL NULL 1 NULL NULL 10046 NULL 1 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM personnel_employee WHERE `personnel_employee`.`id` = 334
 		334 2025-09-22 18:41:46.503283 NULL 2025-09-22 18:41:46.503283 NULL 0 11310 NULL NULL NULL NULL NULL pbkdf2_sha256$390000$ecmuZP1nAGzpGPOyecKc4G$SILdtb... 0 NULL 1 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL MED7243700309 NULL 2025-09-22 18:41:46.548650 2025-09-22 0 NULL NULL 1 0 1 NULL NULL 0 NULL NULL 1 NULL NULL 11310 NULL 1 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM personnel_employee WHERE `personnel_employee`.`id` = 333
 		333 2025-09-22 18:41:46.257824 NULL 2025-09-22 18:41:46.257824 NULL 0 11339 NULL NULL NULL NULL NULL pbkdf2_sha256$390000$nfKTdMyshUX7wlbnp0LbSM$/lgy8y... 0 NULL 1 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL MED7243700309 NULL 2025-09-22 18:41:46.311617 2025-09-22 0 NULL NULL 1 0 1 NULL NULL 0 NULL NULL 1 NULL NULL 11339 NULL 1 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM personnel_employee WHERE `personnel_employee`.`id` = 332
 		332 2025-09-22 18:41:46.014899 NULL 2025-09-22 18:41:46.014899 NULL 0 11332 NULL NULL NULL NULL NULL pbkdf2_sha256$390000$zbRoNhdKmYDZEi6x54nHV9$dYbP79... 0 NULL 1 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL MED7243700309 NULL 2025-09-22 18:41:46.065017 2025-09-22 0 NULL NULL 1 0 1 NULL NULL 0 NULL NULL 1 NULL NULL 11332 NULL 1 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM personnel_employee WHERE `personnel_employee`.`id` = 331
 		331 2025-09-22 18:41:45.762879 NULL 2025-09-22 18:41:45.762879 NULL 0 10526 NULL NULL NULL NULL NULL pbkdf2_sha256$390000$D9rtrpz15EcbHra8SoqGyk$0LbLha... 0 NULL 1 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL MED7243700309 NULL 2025-09-22 18:41:45.820870 2025-09-22 0 NULL NULL 1 0 1 NULL NULL 0 NULL NULL 1 NULL NULL 10526 NULL 1 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM personnel_employee WHERE `personnel_employee`.`id` = 330
 		330 2025-09-22 18:41:45.536765 NULL 2025-09-22 18:41:45.536765 NULL 0 10076 NULL NULL NULL NULL NULL pbkdf2_sha256$390000$34sZFnf5iAsCisfSPErKit$IQ5MQ6... 0 NULL 1 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL MED7243700309 NULL 2025-09-22 18:41:45.572133 2025-09-22 0 NULL NULL 1 0 1 NULL NULL 0 NULL NULL 1 NULL NULL 10076 NULL 1 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM personnel_employee WHERE `personnel_employee`.`id` = 329
 		329 2025-09-22 18:41:45.292398 NULL 2025-09-22 18:41:45.292398 NULL 0 10124 NULL NULL NULL NULL NULL pbkdf2_sha256$390000$4va67dQaSRH7pCUuCxfocC$bqH8/5... 0 NULL 1 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL MED7243700309 NULL 2025-09-22 18:41:45.339475 2025-09-22 0 NULL NULL 1 0 1 NULL NULL 0 NULL NULL 1 NULL NULL 10124 NULL 1 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM personnel_employee WHERE `personnel_employee`.`id` = 328
 		328 2025-09-22 18:41:45.059797 NULL 2025-09-22 18:41:45.059797 NULL 0 10528 NULL NULL NULL NULL NULL pbkdf2_sha256$390000$BXq1miKXYJh6GHkSLTpg1w$9UKH1x... 0 NULL 1 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL MED7243700309 NULL 2025-09-22 18:41:45.115155 2025-09-22 0 NULL NULL 1 0 1 NULL NULL 0 NULL NULL 1 NULL NULL 10528 NULL 1 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM personnel_employee WHERE `personnel_employee`.`id` = 327
 		327 2025-09-22 18:41:44.841884 NULL 2025-09-22 18:41:44.841884 NULL 0 10320 NULL NULL NULL NULL NULL pbkdf2_sha256$390000$aFsU1rj5XYqoYy0I82bEkU$bVw++Y... 0 NULL 1 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL MED7243700309 NULL 2025-09-22 18:41:44.877908 2025-09-22 0 NULL NULL 1 0 1 NULL NULL 0 NULL NULL 1 NULL NULL 10320 NULL 1 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM personnel_employee WHERE `personnel_employee`.`id` = 326
 		326 2025-09-22 18:41:44.602535 NULL 2025-09-22 18:41:44.602535 NULL 0 10169 NULL NULL NULL NULL NULL pbkdf2_sha256$390000$XmNhr8nqrycTc7bsSQYAT5$VDmVUd... 0 NULL 1 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL MED7243700309 NULL 2025-09-22 18:41:44.632902 2025-09-22 0 NULL NULL 1 0 1 NULL NULL 0 NULL NULL 1 NULL NULL 10169 NULL 1 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM personnel_employee WHERE `personnel_employee`.`id` = 325
 		325 2025-09-22 18:41:44.294009 NULL 2025-09-22 18:41:44.294009 NULL 0 11330 NULL NULL NULL NULL NULL pbkdf2_sha256$390000$meGVtVHbZ0WnsnDaEJYQJk$/E/h3+... 0 NULL 1 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL MED7243700309 NULL 2025-09-22 18:41:44.352129 2025-09-22 0 NULL NULL 1 0 1 NULL NULL 0 NULL NULL 1 NULL NULL 11330 NULL 1 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM personnel_employee WHERE `personnel_employee`.`id` = 324
 		324 2025-09-22 18:41:44.056481 NULL 2025-09-22 18:41:44.056481 NULL 0 11317 NULL NULL NULL NULL NULL pbkdf2_sha256$390000$t6d3bqRF0K4cMr6CqVAerr$HGJ6II... 0 NULL 1 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL MED7243700309 NULL 2025-09-22 18:41:44.104478 2025-09-22 0 NULL NULL 1 0 1 NULL NULL 0 NULL NULL 1 NULL NULL 11317 NULL 1 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM personnel_employee WHERE `personnel_employee`.`id` = 323
 		323 2025-09-22 18:41:43.810005 NULL 2025-09-22 18:41:43.810005 NULL 0 11315 NULL NULL NULL NULL NULL pbkdf2_sha256$390000$o7C4lLjsc9ioCLkNpn4znn$AytAja... 0 NULL 1 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL MED7243700309 NULL 2025-09-22 18:41:43.868191 2025-09-22 0 NULL NULL 1 0 1 NULL NULL 0 NULL NULL 1 NULL NULL 11315 NULL 1 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM personnel_employee WHERE `personnel_employee`.`id` = 322
 		322 2025-09-22 18:41:43.564148 NULL 2025-09-22 18:41:43.564148 NULL 0 11203 NULL NULL NULL NULL NULL pbkdf2_sha256$390000$UqyKAfmN92mvodtiExiX02$dcZIRI... 0 NULL 1 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL MED7243700309 NULL 2025-09-22 18:41:43.611748 2025-09-22 0 NULL NULL 1 0 1 NULL NULL 0 NULL NULL 1 NULL NULL 11203 NULL 1 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM personnel_employee WHERE `personnel_employee`.`id` = 321
 		321 2025-09-22 18:41:43.326771 NULL 2025-09-22 18:41:43.326771 NULL 0 11314 NULL NULL NULL NULL NULL pbkdf2_sha256$390000$BQv0HW977Zpp8ExSvylgM6$GBHSbY... 0 NULL 1 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL MED7243700309 NULL 2025-09-22 18:41:43.373983 2025-09-22 0 NULL NULL 1 0 1 NULL NULL 0 NULL NULL 1 NULL NULL 11314 NULL 1 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM personnel_employee WHERE `personnel_employee`.`id` = 320
 		320 2025-09-22 18:41:43.099149 NULL 2025-09-22 18:41:43.099658 NULL 0 10121 NULL NULL NULL NULL NULL pbkdf2_sha256$390000$9HohUKydIFfKFjpFD4CehO$deGadP... 0 NULL 1 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL MED7243700309 NULL 2025-09-22 18:41:43.138113 2025-09-22 0 NULL NULL 1 0 1 NULL NULL 0 NULL NULL 1 NULL NULL 10121 NULL 1 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM personnel_employee WHERE `personnel_employee`.`id` = 319
 		319 2025-09-22 18:41:42.855691 NULL 2025-09-22 18:41:42.855691 NULL 0 10060 NULL NULL NULL NULL NULL pbkdf2_sha256$390000$VAZsLI7oZEQaVKFuyDZXRJ$JWInmq... 0 NULL 1 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL MED7243700309 NULL 2025-09-22 18:41:42.901643 2025-09-22 0 NULL NULL 1 0 1 NULL NULL 0 NULL NULL 1 NULL NULL 10060 NULL 1 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM personnel_employee WHERE `personnel_employee`.`id` = 318
 		318 2025-09-22 18:41:42.616227 NULL 2025-09-22 18:41:42.616227 NULL 0 10531 NULL NULL NULL NULL NULL pbkdf2_sha256$390000$fDBr3TvcFIwljzX7telKMC$Fv+8KD... 0 NULL 1 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL MED7243700309 NULL 2025-09-22 18:41:42.663979 2025-09-22 0 NULL NULL 1 0 1 NULL NULL 0 NULL NULL 1 NULL NULL 10531 NULL 1 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM personnel_employee WHERE `personnel_employee`.`id` = 317
 		317 2025-09-22 18:41:42.380180 NULL 2025-09-22 18:41:42.380180 NULL 0 11286 NULL NULL NULL NULL NULL pbkdf2_sha256$390000$gLmZp7HtWwDNHFEtiD7pvM$LXt4uY... 0 NULL 1 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL MED7243700309 NULL 2025-09-22 18:41:42.411642 2025-09-22 0 NULL NULL 1 0 1 NULL NULL 0 NULL NULL 1 NULL NULL 11286 NULL 1 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM personnel_employee WHERE `personnel_employee`.`id` = 316
 		316 2025-09-22 18:41:42.129302 NULL 2025-09-22 18:41:42.129302 NULL 0 10164 NULL NULL NULL NULL NULL pbkdf2_sha256$390000$SsperKnRFDP9Uo1bwf6pbE$7YktoI... 0 NULL 1 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL MED7243700309 NULL 2025-09-22 18:41:42.184554 2025-09-22 0 NULL NULL 1 0 1 NULL NULL 0 NULL NULL 1 NULL NULL 10164 NULL 1 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM personnel_employee WHERE `personnel_employee`.`id` = 315
 		315 2025-09-22 18:41:41.884411 NULL 2025-09-22 18:41:41.884411 NULL 0 10118 NULL NULL NULL NULL NULL pbkdf2_sha256$390000$GYSW43MnDyzvYXMxwMoDUG$Y7VrHS... 0 NULL 1 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL MED7243700309 NULL 2025-09-22 18:41:41.931460 2025-09-22 0 NULL NULL 1 0 1 NULL NULL 0 NULL NULL 1 NULL NULL 10118 NULL 1 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM personnel_employee WHERE `personnel_employee`.`id` = 314
 		314 2025-09-22 18:41:41.643138 NULL 2025-09-22 18:41:41.643138 NULL 0 10122 NULL NULL NULL NULL NULL pbkdf2_sha256$390000$vosvhmRGbwrJer3vQCAhgE$1FZ5cv... 0 NULL 1 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL MED7243700309 NULL 2025-09-22 18:41:41.695025 2025-09-22 0 NULL NULL 1 0 1 NULL NULL 0 NULL NULL 1 NULL NULL 10122 NULL 1 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM personnel_employee WHERE `personnel_employee`.`id` = 313
 		313 2025-09-22 18:41:41.375306 NULL 2025-09-22 18:41:41.375306 NULL 0 10092 NULL NULL NULL NULL NULL pbkdf2_sha256$390000$Y5NMb9XbfrFn222239rAk9$uiz25O... 0 NULL 1 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL MED7243700309 NULL 2025-09-22 18:41:41.423342 2025-09-22 0 NULL NULL 1 0 1 NULL NULL 0 NULL NULL 1 NULL NULL 10092 NULL 1 NULL
With selected: With selected:
|
|
|
|
Filter rows:
Sort by key:
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