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 bigint(20)
branch_id int(10)
finance_year_id int(10)
balance_date date
item_id bigint(20)
godown_id int(10)
item_name varchar(255) utf8mb4_unicode_ci
item_cat_id int(10)
stock_group varchar(100) utf8mb4_unicode_ci
valuation_method_used varchar(20) utf8mb4_unicode_ci
opening_qty decimal(14,2)
opening_value decimal(16,2)
opening_rate decimal(12,2)
in_qty decimal(14,2)
in_value decimal(16,2)
in_rate decimal(12,2)
out_qty decimal(14,2)
out_value decimal(16,2)
out_rate decimal(12,2)
valuation_adjustment_value decimal(16,2)
closing_qty decimal(14,2)
closing_value decimal(16,2)
closing_rate decimal(12,2)
created_at datetime
updated_at datetime