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 :
Options
Set default





Collapse Expand Requery Edit Explain Profiling Query failed Database : Queried time :
Do a "query by example" (wildcard: "%")
Column Type Collation Operator Value
id int(11)
main_id int(11)
ItemNo varchar(255) latin1_swedish_ci
item_id int(11)
Description varchar(255) latin1_swedish_ci
org_qty double(12,2)
Unit varchar(255) latin1_swedish_ci
org_unit_cost decimal(36,16)
org_amount decimal(36,16)
Wt decimal(36,16)
revised_qty decimal(36,16)
revised_cont_amount decimal(36,16)
revised_wt decimal(36,16)
prev_acc decimal(36,16)
prev_wt decimal(36,16)
prev_amt decimal(36,16)
accomplishment decimal(36,16)
accomplishment_wt decimal(36,16)
accomplishment_amount decimal(36,16)
total_acc decimal(36,16)
total_wt decimal(36,16)
total_amt decimal(36,16)
add_qty decimal(36,16)
add_unitcost decimal(36,16)
add_amnt decimal(36,16)
ded_qty decimal(36,16)
ded_unitcost decimal(36,16)
ded_amnt decimal(36,16)
extra_qty decimal(36,16)
extra_unit varchar(255) latin1_swedish_ci
extra_unitcost decimal(36,16)
extra_amnt decimal(36,16)
amount_ decimal(36,16)
ts timestamp
isBoldText int(11)
swa_guid varchar(2555) latin1_swedish_ci
dupa_id int(11)