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(10)
travel_date date
booking_date date
guest_name varchar(255) utf8mb4_unicode_ci
customer_id int(11)
package_type varchar(100) utf8mb4_unicode_ci
customer_type varchar(100) utf8mb4_unicode_ci
adult_pax int(11)
adult_price decimal(10,2)
senior_pax int(11)
senior_price decimal(10,2)
child_pax int(11)
child_price decimal(10,2)
infant_pax int(11)
infant_price decimal(10,2)
total_pax int(11)
total_invoice decimal(10,2)
total_cost decimal(10,2)
net_profit decimal(10,2)
deposit_paid decimal(10,2)
balance_due decimal(10,2)
adult_tax tinyint(1)
senior_tax tinyint(1)
child_tax tinyint(1)
infant_tax tinyint(1)
status varchar(50) utf8mb4_unicode_ci
assigned_to varchar(100) utf8mb4_unicode_ci
created_at datetime
created_by int(10)
updated_at datetime