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 :
Do a "query by example" (wildcard: "%")
Column Type Collation Operator Value
id int(11)
create_time datetime(6)
create_user varchar(150) utf8mb4_general_ci
change_time datetime(6)
change_user varchar(150) utf8mb4_general_ci
status smallint(6)
emp_code varchar(20) utf8mb4_general_ci
first_name varchar(100) utf8mb4_general_ci
last_name varchar(100) utf8mb4_general_ci
nickname varchar(100) utf8mb4_general_ci
passport varchar(30) utf8mb4_general_ci
driver_license_automobile varchar(30) utf8mb4_general_ci
driver_license_motorcycle varchar(30) utf8mb4_general_ci
photo varchar(200) utf8mb4_general_ci
self_password varchar(128) utf8mb4_general_ci
device_password varchar(20) utf8mb4_general_ci
dev_privilege int(11)
card_no varchar(20) utf8mb4_general_ci
acc_group varchar(5) utf8mb4_general_ci
acc_timezone varchar(20) utf8mb4_general_ci
gender varchar(1) utf8mb4_general_ci
birthday date
address varchar(200) utf8mb4_general_ci
postcode varchar(10) utf8mb4_general_ci
office_tel varchar(20) utf8mb4_general_ci
contact_tel varchar(20) utf8mb4_general_ci
mobile varchar(20) utf8mb4_general_ci
national varchar(50) utf8mb4_general_ci
religion varchar(20) utf8mb4_general_ci
title varchar(20) utf8mb4_general_ci
enroll_sn varchar(20) utf8mb4_general_ci
ssn varchar(20) utf8mb4_general_ci
update_time datetime(6)
hire_date date
verify_mode int(11)
city varchar(20) utf8mb4_general_ci
emp_type smallint(6)
enable_payroll tinyint(1)
app_status smallint(6)
app_role smallint(6)
email varchar(50) utf8mb4_general_ci
last_login datetime(6)
is_active tinyint(1)
session_key varchar(32) utf8mb4_general_ci
login_ip varchar(32) utf8mb4_general_ci
department_id int(11)
position_id int(11)
leave_group int(11)
emp_code_digit bigint(20)
superior_id int(11) Browse foreign values Browse foreign values
company_id int(11)
password_reset datetime(6)