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`
[ 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 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` = 1
 		1 2025-09-22 18:40:21.666589 NULL 2025-09-22 18:40:21.666589 NULL 0 1177 1177 NULL NULL NULL NULL NULL pbkdf2_sha256$390000$0XIs816lHCKskatF9iAdcw$cjDJXU... 0 NULL 1 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL MED7243700309 NULL 2025-09-22 18:40:21.743499 2025-09-22 0 NULL NULL 1 0 1 NULL NULL 0 NULL NULL 1 NULL NULL 1177 NULL 1 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM personnel_employee WHERE `personnel_employee`.`id` = 2
 		2 2025-09-22 18:40:21.946617 NULL 2025-09-22 18:40:21.946617 NULL 0 1282 1282 NULL NULL NULL NULL NULL pbkdf2_sha256$390000$MAjEGRRIIZHRKnxoaTqwbv$XvTWR4... 0 NULL 1 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL MED7243700309 NULL 2025-09-22 18:40:22.008184 2025-09-22 0 NULL NULL 1 0 1 NULL NULL 0 NULL NULL 1 NULL NULL 1282 NULL 1 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM personnel_employee WHERE `personnel_employee`.`id` = 3
 		3 2025-09-22 18:40:22.200128 NULL 2025-09-22 18:40:22.200128 NULL 0 1169 1169 NULL NULL NULL NULL NULL pbkdf2_sha256$390000$i99hJYgVgClG82EdYwQR1g$2SP8ei... 0 NULL 1 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL MED7243700309 NULL 2025-09-22 18:40:22.239060 2025-09-22 0 NULL NULL 1 0 1 NULL NULL 0 NULL NULL 1 NULL NULL 1169 NULL 1 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM personnel_employee WHERE `personnel_employee`.`id` = 4
 		4 2025-09-22 18:40:22.430919 NULL 2025-09-22 18:40:22.430919 NULL 0 1 1 NULL NULL NULL NULL NULL pbkdf2_sha256$390000$0MceRkAt86MmrYZIh4b93m$S/qfRJ... 0 11184201 1 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL MED7243700309 NULL 2025-09-22 18:40:22.478334 2025-09-22 0 NULL NULL 1 0 1 NULL NULL 0 NULL NULL 1 NULL NULL 1 NULL 1 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM personnel_employee WHERE `personnel_employee`.`id` = 5
 		5 2025-09-22 18:40:22.690953 NULL 2025-09-22 18:40:22.690953 NULL 0 1108 1108 NULL NULL NULL NULL NULL pbkdf2_sha256$390000$6RdJHjXdhE3tXjWVV8ZEg8$Lky1Pn... 0 NULL 1 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL MED7243700309 NULL 2025-09-22 18:40:22.735445 2025-09-22 0 NULL NULL 1 0 1 NULL NULL 0 NULL NULL 1 NULL NULL 1108 NULL 1 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM personnel_employee WHERE `personnel_employee`.`id` = 6
 		6 2025-09-22 18:40:22.915072 NULL 2025-09-22 18:40:22.915072 NULL 0 1119 1119 NULL NULL NULL NULL NULL pbkdf2_sha256$390000$aOWIZ9P60PLxsL0005AwoK$+Sg6K7... 0 NULL 1 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL MED7243700309 NULL 2025-09-22 18:40:22.967067 2025-09-22 0 NULL NULL 1 0 1 NULL NULL 0 NULL NULL 1 NULL NULL 1119 NULL 1 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM personnel_employee WHERE `personnel_employee`.`id` = 7
 		7 2025-09-22 18:40:23.151046 NULL 2025-09-22 18:40:23.151046 NULL 0 1159 1159 NULL NULL NULL NULL NULL pbkdf2_sha256$390000$0PN1QF8iv5bCfShvhn3HzQ$v7Qb07... 0 NULL 1 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL MED7243700309 NULL 2025-09-22 18:40:23.196099 2025-09-22 0 NULL NULL 1 0 1 NULL NULL 0 NULL NULL 1 NULL NULL 1159 NULL 1 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM personnel_employee WHERE `personnel_employee`.`id` = 8
 		8 2025-09-22 18:40:23.383522 NULL 2025-09-22 18:40:23.383522 NULL 0 10430 10430 NULL NULL NULL NULL NULL pbkdf2_sha256$390000$8dmW4uM9AOHGRAXQljIEEd$9d/5tD... 0 NULL 1 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL MED7243700309 NULL 2025-09-22 18:40:23.437298 2025-09-22 0 NULL NULL 1 0 1 NULL NULL 0 NULL NULL 1 NULL NULL 10430 NULL 1 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM personnel_employee WHERE `personnel_employee`.`id` = 9
 		9 2025-09-22 18:40:23.617599 NULL 2025-09-22 18:40:23.617599 NULL 0 1234 1234 NULL NULL NULL NULL NULL pbkdf2_sha256$390000$97Fg1WDcyNpcbS3MtyGTMt$JyPBrb... 0 NULL 1 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL MED7243700309 NULL 2025-09-22 18:40:23.676255 2025-09-22 0 NULL NULL 1 0 1 NULL NULL 0 NULL NULL 1 NULL NULL 1234 NULL 1 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM personnel_employee WHERE `personnel_employee`.`id` = 10
 		10 2025-09-22 18:40:23.853891 NULL 2025-09-22 18:40:23.853891 NULL 0 10432 10432 NULL NULL NULL NULL NULL pbkdf2_sha256$390000$gMf6hpxuoSztyTAaCGH6wC$hnXizt... 0 NULL 1 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL MED7243700309 NULL 2025-09-22 18:40:23.901121 2025-09-22 0 NULL NULL 1 0 1 NULL NULL 0 NULL NULL 1 NULL NULL 10432 NULL 1 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM personnel_employee WHERE `personnel_employee`.`id` = 11
 		11 2025-09-22 18:40:24.088250 NULL 2025-09-22 18:40:24.088250 NULL 0 1085 1085 NULL NULL NULL NULL NULL pbkdf2_sha256$390000$YoGm3H4CLOAD7GmnRoDCP0$amwKP9... 0 NULL 1 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL MED7243700309 NULL 2025-09-22 18:40:24.135094 2025-09-22 0 NULL NULL 1 0 1 NULL NULL 0 NULL NULL 1 NULL NULL 1085 NULL 1 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM personnel_employee WHERE `personnel_employee`.`id` = 12
 		12 2025-09-22 18:40:24.355603 NULL 2025-09-22 18:40:24.355603 NULL 0 10429 10429 NULL NULL NULL NULL NULL pbkdf2_sha256$390000$i5lAbZ8SqMJ5gWm6seNbya$l7+ypq... 0 NULL 1 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL MED7243700309 NULL 2025-09-22 18:40:24.390135 2025-09-22 0 NULL NULL 1 0 1 NULL NULL 0 NULL NULL 1 NULL NULL 10429 NULL 1 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM personnel_employee WHERE `personnel_employee`.`id` = 13
 		13 2025-09-22 18:40:24.582813 NULL 2025-09-22 18:40:24.582813 NULL 0 1164 1164 NULL NULL NULL NULL NULL pbkdf2_sha256$390000$MzbehHuaWxAiyVolkcz1AG$B0d8R1... 0 NULL 1 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL MED7243700309 NULL 2025-09-22 18:40:24.618685 2025-09-22 0 NULL NULL 1 0 1 NULL NULL 0 NULL NULL 1 NULL NULL 1164 NULL 1 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM personnel_employee WHERE `personnel_employee`.`id` = 14
 		14 2025-09-22 18:40:24.820749 NULL 2025-09-22 18:40:24.820749 NULL 0 1295 1295 NULL NULL NULL NULL NULL pbkdf2_sha256$390000$kuYIgBK4JrHxI6db37ufHc$VpRylX... 0 NULL 1 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL MED7243700309 NULL 2025-09-22 18:40:24.852450 2025-09-22 0 NULL NULL 1 0 1 NULL NULL 0 NULL NULL 1 NULL NULL 1295 NULL 1 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM personnel_employee WHERE `personnel_employee`.`id` = 15
 		15 2025-09-22 18:40:25.048116 NULL 2025-09-22 18:40:25.048116 NULL 0 1297 1297 NULL NULL NULL NULL NULL pbkdf2_sha256$390000$DWdIEQ1XdkOKOmNKr2doid$pFleFh... 0 NULL 1 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL MED7243700309 NULL 2025-09-22 18:40:25.086310 2025-09-22 0 NULL NULL 1 0 1 NULL NULL 0 NULL NULL 1 NULL NULL 1297 NULL 1 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM personnel_employee WHERE `personnel_employee`.`id` = 16
 		16 2025-09-22 18:40:25.274229 NULL 2025-09-22 18:40:25.274229 NULL 0 2057 2057 NULL NULL NULL NULL NULL pbkdf2_sha256$390000$N5aFCRL2g69a3bcDMtngXu$/Y8S6k... 0 NULL 1 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL MED7243700309 NULL 2025-09-22 18:40:25.304992 2025-09-22 0 NULL NULL 1 0 1 NULL NULL 0 NULL NULL 1 NULL NULL 2057 NULL 1 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM personnel_employee WHERE `personnel_employee`.`id` = 17
 		17 2025-09-22 18:40:25.507723 NULL 2025-09-22 18:40:25.507723 NULL 0 1253 1253 NULL NULL NULL NULL NULL pbkdf2_sha256$390000$sKwIw55QbkL0Yx0JyYRszg$7dOo80... 0 NULL 1 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL MED7243700309 NULL 2025-09-22 18:40:25.571191 2025-09-22 0 NULL NULL 1 0 1 NULL NULL 0 NULL NULL 1 NULL NULL 1253 NULL 1 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM personnel_employee WHERE `personnel_employee`.`id` = 18
 		18 2025-09-22 18:40:25.772120 NULL 2025-09-22 18:40:25.772120 NULL 0 1109 1109 NULL NULL NULL NULL NULL pbkdf2_sha256$390000$68YnltktxXRmHjYCEcV8tc$JI9xwe... 0 NULL 1 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL MED7243700309 NULL 2025-09-22 18:40:25.808002 2025-09-22 0 NULL NULL 1 0 1 NULL NULL 0 NULL NULL 1 NULL NULL 1109 NULL 1 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM personnel_employee WHERE `personnel_employee`.`id` = 19
 		19 2025-09-22 18:40:25.999861 NULL 2025-09-22 18:40:25.999861 NULL 0 1162 1162 NULL NULL NULL NULL NULL pbkdf2_sha256$390000$W3c5xBu7vXVm6NPMFoZdhD$hGVefn... 0 NULL 1 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL MED7243700309 NULL 2025-09-22 18:40:26.044604 2025-09-22 0 NULL NULL 1 0 1 NULL NULL 0 NULL NULL 1 NULL NULL 1162 NULL 1 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM personnel_employee WHERE `personnel_employee`.`id` = 20
 		20 2025-09-22 18:40:26.237505 NULL 2025-09-22 18:40:26.237505 NULL 0 3052 3052 NULL NULL NULL NULL NULL pbkdf2_sha256$390000$yjDQm3NA1nFqTkSVPyD0ew$Yg3sW3... 0 NULL 1 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL MED7243700309 NULL 2025-09-22 18:40:26.290681 2025-09-22 0 NULL NULL 1 0 1 NULL NULL 0 NULL NULL 1 NULL NULL 3052 NULL 1 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM personnel_employee WHERE `personnel_employee`.`id` = 21
 		21 2025-09-22 18:40:26.477589 NULL 2025-09-22 18:40:26.477589 NULL 0 1044 1044 NULL NULL NULL NULL NULL pbkdf2_sha256$390000$r1dFpndX9oUUzgsfBuSGaQ$QBKeYP... 0 NULL 1 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL MED7243700309 NULL 2025-09-22 18:40:26.525157 2025-09-22 0 NULL NULL 1 0 1 NULL NULL 0 NULL NULL 1 NULL NULL 1044 NULL 1 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM personnel_employee WHERE `personnel_employee`.`id` = 22
 		22 2025-09-22 18:40:26.716680 NULL 2025-09-22 18:40:26.716680 NULL 0 1306 1306 NULL NULL NULL NULL NULL pbkdf2_sha256$390000$vYQIl2qqiRQuiu7EBZcs6W$y5YwBa... 0 NULL 1 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL MED7243700309 NULL 2025-09-22 18:40:26.770913 2025-09-22 0 NULL NULL 1 0 1 NULL NULL 0 NULL NULL 1 NULL NULL 1306 NULL 1 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM personnel_employee WHERE `personnel_employee`.`id` = 23
 		23 2025-09-22 18:40:26.961291 NULL 2025-09-22 18:40:26.961291 NULL 0 417 417 NULL NULL NULL NULL NULL pbkdf2_sha256$390000$YNT16Z0Lc4x2Epk3fyMabq$oCyodf... 0 NULL 1 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL MED7243700309 NULL 2025-09-22 18:40:27.010476 2025-09-22 0 NULL NULL 1 0 1 NULL NULL 0 NULL NULL 1 NULL NULL 417 NULL 1 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM personnel_employee WHERE `personnel_employee`.`id` = 24
 		24 2025-09-22 18:40:27.195912 NULL 2025-09-22 18:40:27.195912 NULL 0 1283 1283 NULL NULL NULL NULL NULL pbkdf2_sha256$390000$hpcDwxuS79FyJZqy5EJzky$KkOgbN... 0 NULL 1 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL MED7243700309 NULL 2025-09-22 18:40:27.236949 2025-09-22 0 NULL NULL 1 0 1 NULL NULL 0 NULL NULL 1 NULL NULL 1283 NULL 1 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM personnel_employee WHERE `personnel_employee`.`id` = 25
 		25 2025-09-22 18:40:27.438391 NULL 2025-09-22 18:40:27.438391 NULL 0 1055 1055 NULL NULL NULL NULL NULL pbkdf2_sha256$390000$f5OKDg0zd55oXeieI3uqQP$gupOPP... 0 NULL 1 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL MED7243700309 NULL 2025-09-22 18:40:27.468035 2025-09-22 0 NULL NULL 1 0 1 NULL NULL 0 NULL NULL 1 NULL NULL 1055 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