Drop files here

SQL upload ( 0 ) x-

Server: localhost »Database: herp »Table: dispatch
Page-related settingsClick on the bar to scroll to top of page
Press Ctrl+Enter to execute query
x
 
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
xxxxxxxxxx
 
Options
Set default





Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database: Queried time:

Edit mode

Customize edit mode.

Documentation Disallow BLOB and BINARY columns from editing.
Documentation Display the function fields in edit/insert mode.
Documentation Defines whether or not type fields should be initially displayed in edit/insert mode.
Documentation How many rows can be inserted at one time.
Documentation Sort order for items in a foreign-key dropdown box; content is the referenced data, id is the key value.
Documentation A dropdown will be used if fewer items are present.
ColumnTypeFunctionNullValue
idint(5)
sitevarchar(10)
adviceNovarchar(20)
partyvarchar(20)
dispatchDatedate ...
name_of_commodityvarchar(200)
dispatch_modevarchar(200)
tarrif_headingvarchar(200)
da_refnovarchar(255)
payment_termvarchar(150)
desitinationvarchar(200)
ex_cust_groupvarchar(200)
ecc_novarchar(200)
our_refnovarchar(200)
form_statusenum-- No
form_novarchar(200)
po_ordernovarchar(200)
po_datedate ...
againstSOPvarchar(30)
totalDispatchint(5)
remarkstinyblob Binary - do not edit (0 B)
 (Max: 256B)
statusint(2) 0
createdByvarchar(5)
createdDatedate ...
pre_statusvarchar(5) 0
basicAmountvarchar(200)
Excise_dutydouble(10,2)
totalDiscountedPricevarchar(200)
ECessIDvarchar(200)
ECessPercentagevarchar(200)
ECessValuevarchar(200)
SHECessIdvarchar(200)
SAHCessPercentagevarchar(200)
SAHCessValuevarchar(200)
taxableAmountvarchar(200)
VatCstvarchar(200)
VatCstValuevarchar(200)
grandTotalvarchar(200)
CompanyIdint(10)
dispatchmodetypeenum-- InDirect
order_typevarchar(250)
freightvarchar(255)
storeint(10)
lr_novarchar(255)
lr_datedate ...
modified_byint(11)
modified_datedate ...
dealeridint(10) 0
rejectint(1) 0


ColumnTypeFunctionNullValue
idint(5)
sitevarchar(10)
adviceNovarchar(20)
partyvarchar(20)
dispatchDatedate ...
name_of_commodityvarchar(200)
dispatch_modevarchar(200)
tarrif_headingvarchar(200)
da_refnovarchar(255)
payment_termvarchar(150)
desitinationvarchar(200)
ex_cust_groupvarchar(200)
ecc_novarchar(200)
our_refnovarchar(200)
form_statusenum-- No
form_novarchar(200)
po_ordernovarchar(200)
po_datedate ...
againstSOPvarchar(30)
totalDispatchint(5)
remarkstinyblob Binary - do not edit (0 B)
 (Max: 256B)
statusint(2) 0
createdByvarchar(5)
createdDatedate ...
pre_statusvarchar(5) 0
basicAmountvarchar(200)
Excise_dutydouble(10,2)
totalDiscountedPricevarchar(200)
ECessIDvarchar(200)
ECessPercentagevarchar(200)
ECessValuevarchar(200)
SHECessIdvarchar(200)
SAHCessPercentagevarchar(200)
SAHCessValuevarchar(200)
taxableAmountvarchar(200)
VatCstvarchar(200)
VatCstValuevarchar(200)
grandTotalvarchar(200)
CompanyIdint(10)
dispatchmodetypeenum-- InDirect
order_typevarchar(250)
freightvarchar(255)
storeint(10)
lr_novarchar(255)
lr_datedate ...
modified_byint(11)
modified_datedate ...
dealeridint(10) 0
rejectint(1) 0

   and then   
Use TAB key to move from value to value, or CTRL+arrows to move anywhere

Continue insertion with rows