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)
inv_id int(50)
client_id int(20)
dr_id int(20)
dr_number varchar(255) utf8_general_ci
CustomDR varchar(100) utf8_general_ci
dr_date date
item_id int(20)
qty double
uom varchar(50) utf8_general_ci
item_code varchar(50) utf8_general_ci
item_name varchar(255) utf8_general_ci
item_description varchar(255) utf8_general_ci
Serial varchar(50) utf8_general_ci
po_price decimal(26,6)
selling_price decimal(26,6)
soid int(20)
so_num varchar(100) utf8_general_ci
customer_ponum varchar(255) utf8_general_ci
PRJID int(20)
title_id int(50)
branch_loc int(20)
temp_cogs int(50)
temp_AR int(50)
temp_asset int(50)
temp_income int(50)
temp_AR_amt decimal(26,6)
temp_cogs_amt decimal(26,6)
temp_income_amt decimal(26,6)
temp_asset_amt decimal(26,6)
type varchar(50) utf8_general_ci
GUID varchar(50) utf8_general_ci
status varchar(11) utf8_general_ci
invoice_id int(50)
invoice_num varchar(50) utf8_general_ci
TS timestamp
UID int(20)
JID int(20)
imported_from_excel int(1)