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)
img varchar(255) utf8mb4_general_ci
name varchar(255) utf8mb4_general_ci
model varchar(100) utf8mb4_general_ci
brand varchar(100) utf8mb4_general_ci
serial_number varchar(255) utf8mb4_general_ci
serial varchar(100) utf8mb4_general_ci
quantity int(11)
category_id int(11)
description text utf8mb4_general_ci
status enum('available', 'in_use', 'maintenance', 'damaged') utf8mb4_general_ci
condition_status enum('good', 'fair', 'needs_repair', 'broken') utf8mb4_general_ci
location varchar(255) utf8mb4_general_ci
purchase_date date
purchase_price decimal(10,2)
warranty_expiry date
last_maintenance date
image_path varchar(500) utf8mb4_general_ci
created_at timestamp
updated_at timestamp
Display order: