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)
doc_no varchar(20) utf8mb4_general_ci
book_date date
work_time time
use_date date
return_date date
depart_time time
return_time time
car_type varchar(255) utf8mb4_general_ci
destination varchar(255) utf8mb4_general_ci
map_url varchar(1000) utf8mb4_general_ci
contact_name varchar(100) utf8mb4_general_ci
job_no varchar(50) utf8mb4_general_ci
has_map varchar(10) utf8mb4_general_ci
contact_tel varchar(20) utf8mb4_general_ci
pickup_location varchar(255) utf8mb4_general_ci
pickup_datetime datetime
has_staff varchar(10) utf8mb4_general_ci
staff_data longtext utf8mb4_bin
job_type varchar(255) utf8mb4_general_ci
detail varchar(500) utf8mb4_general_ci
detail2 varchar(500) utf8mb4_general_ci
return_type varchar(50) utf8mb4_general_ci
return_location varchar(255) utf8mb4_general_ci
car_plate varchar(20) utf8mb4_general_ci
vehicle_id int(11)
driver_name varchar(100) utf8mb4_general_ci
requester_sign varchar(100) utf8mb4_general_ci
requester_tel varchar(20) utf8mb4_general_ci
status enum('pending', 'approved', 'cancelled', 'updated', 'delivered') utf8mb4_general_ci
created_by int(11)
created_at timestamp
updated_at timestamp
Display order: