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)
lot_code varchar(80) utf8mb4_general_ci
barcode_value varchar(100) utf8mb4_general_ci
product_name varchar(180) utf8mb4_general_ci
category varchar(80) utf8mb4_general_ci
supplier varchar(180) utf8mb4_general_ci
purchase_date varchar(30) utf8mb4_general_ci
received_date varchar(30) utf8mb4_general_ci
received_by_name varchar(120) utf8mb4_general_ci
received_by_user_id int(11)
initial_qty double
current_qty double
unit varchar(40) utf8mb4_general_ci
location_id int(11) Browse foreign values Browse foreign values
notes text utf8mb4_general_ci
status varchar(30) utf8mb4_general_ci
approval_status varchar(30) utf8mb4_general_ci
approved_by_name varchar(120) utf8mb4_general_ci
approved_at varchar(40) utf8mb4_general_ci
created_at varchar(40) utf8mb4_general_ci
supplier_id int(11)
supplier_rep_id int(11)
supplier_rep_name varchar(120) utf8mb4_general_ci
attachment_path varchar(255) utf8mb4_general_ci
Display order: