Drop files here

SQL upload ( 0 ) x-

Server: localhost »Database: herp »Table: direct_po
Page-related settingsClick on the bar to scroll to top of page
Press Ctrl+Enter to execute queryPress 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:

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.
Text fields

Customize text input fields.

Documentation Defines which type of editing controls should be used for CHAR and VARCHAR columns; input - allows limiting of input length, textarea - allows newlines in columns.
Documentation Defines the minimum size for input fields generated for CHAR and VARCHAR columns.
Documentation Defines the maximum size for input fields generated for CHAR and VARCHAR columns.
Documentation Number of columns for CHAR/VARCHAR textareas.
Documentation Number of rows for CHAR/VARCHAR textareas.
Documentation Textarea size (columns) in edit mode, this value will be emphasized for SQL query textareas (*2).
Documentation Textarea size (rows) in edit mode, this value will be emphasized for SQL query textareas (*2).
Documentation Double size of textarea for LONGTEXT columns.
ColumnTypeFunctionNullValue
idint(10)
sitevarchar(255)
pr_novarchar(255)
pr_datedate
vender_idint(10)
contact_personvarchar(255)
delivery_datedate
delivery_placevarchar(255)
payment_modevarchar(255)
sop_noint(10)
sop_mst_itemidint(10)
quotation_novarchar(255)
quotation_datedate
basic_amtdouble(10,2)
pkg_chargedouble(10,2)
excise_idint(10)
excise_valuedouble(10,2)
ecess_perdouble(10,2)
ecess_amtdouble(10,2)
sah_perdouble(10,2)
sah_amtdouble(10,2)
total_excise_amtdouble(10,2)
vatcstint(10)
vatcstvaluedouble(10,2)
surcharge_perdouble(10,2)
surcharge_amtdouble(10,2)
freightdouble(10,2)
add_chargesdouble(10,2)
grand_totaldouble(10,2)
createdDatedate
createdByint(10)
mode_transportvarchar(255)
freight1varchar(255)
recive_statusvarchar(255) Pending
total_taxable_amtdouble(10,2)
direct_statusint(25) 0
requisitionnoint(25)
mst_potypevarchar(255)
shipping_addressvarchar(255)
totalDiscountedPricedouble
insurancechargesdouble
overseasfrieghtdouble
insurancecharges_amtdouble
overseasfrieght_amtdouble
localfreightdouble
localfreight_amtdouble
clearingforwardingdouble
clearingforwarding_amtdouble
detetionchargesdouble
detetioncharges_amtdouble
pkg_perdouble(10,2)
pkg_chargesdouble(16,2)
otherchargesdouble
Approval_statusint(10) 0
CompanyIdint(10)
storeint(11)
duty_typeint(4)
agent_detailtext
remarkstext
cancel_issueint(1) 0
cancel_issue_approvint(1) 0
mobile_novarchar(255)
bill_statusint(1)
mrn_statusint(1)
dealeridint(10) 0
sostatusint(2) 0
Sales_Termsint(10)
typevarchar(30)
soidint(10) 0


ColumnTypeFunctionNullValue
idint(10)
sitevarchar(255)
pr_novarchar(255)
pr_datedate
vender_idint(10)
contact_personvarchar(255)
delivery_datedate
delivery_placevarchar(255)
payment_modevarchar(255)
sop_noint(10)
sop_mst_itemidint(10)
quotation_novarchar(255)
quotation_datedate
basic_amtdouble(10,2)
pkg_chargedouble(10,2)
excise_idint(10)
excise_valuedouble(10,2)
ecess_perdouble(10,2)
ecess_amtdouble(10,2)
sah_perdouble(10,2)
sah_amtdouble(10,2)
total_excise_amtdouble(10,2)
vatcstint(10)
vatcstvaluedouble(10,2)
surcharge_perdouble(10,2)
surcharge_amtdouble(10,2)
freightdouble(10,2)
add_chargesdouble(10,2)
grand_totaldouble(10,2)
createdDatedate
createdByint(10)
mode_transportvarchar(255)
freight1varchar(255)
recive_statusvarchar(255) Pending
total_taxable_amtdouble(10,2)
direct_statusint(25) 0
requisitionnoint(25)
mst_potypevarchar(255)
shipping_addressvarchar(255)
totalDiscountedPricedouble
insurancechargesdouble
overseasfrieghtdouble
insurancecharges_amtdouble
overseasfrieght_amtdouble
localfreightdouble
localfreight_amtdouble
clearingforwardingdouble
clearingforwarding_amtdouble
detetionchargesdouble
detetioncharges_amtdouble
pkg_perdouble(10,2)
pkg_chargesdouble(16,2)
otherchargesdouble
Approval_statusint(10) 0
CompanyIdint(10)
storeint(11)
duty_typeint(4)
agent_detailtext
remarkstext
cancel_issueint(1) 0
cancel_issue_approvint(1) 0
mobile_novarchar(255)
bill_statusint(1)
mrn_statusint(1)
dealeridint(10) 0
sostatusint(2) 0
Sales_Termsint(10)
typevarchar(30)
soidint(10) 0

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

Continue insertion with rows