Drop files here

SQL upload ( 0 ) x-

Server: localhost »Database: herp »Table: custbranch
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
branchcodevarchar(10)
debtornovarchar(10)
brnamevarchar(40)
braddress1varchar(40)
braddress2varchar(40)
braddress3varchar(40)
braddress4varchar(50)
braddress5varchar(20)
braddress6varchar(15)
latfloat(10,6) 0.000000
lngfloat(10,6) 0.000000
estdeliverydayssmallint(6) 1
areachar(3)
salesmanvarchar(4)
fwddatesmallint(6) 0
phonenovarchar(20)
faxnovarchar(20)
contactnamevarchar(30)
emailvarchar(55)
defaultlocationvarchar(5)
taxgroupidtinyint(4) 1
defaultshipviaint(11) 1
deliverblindtinyint(1) 1
disabletranstinyint(4) 0
brpostaddr1varchar(40)
brpostaddr2varchar(40)
brpostaddr3varchar(30)
brpostaddr4varchar(20)
brpostaddr5varchar(20)
brpostaddr6varchar(15)
specialinstructionstext
custbranchcodevarchar(30)


ColumnTypeFunctionNullValue
branchcodevarchar(10)
debtornovarchar(10)
brnamevarchar(40)
braddress1varchar(40)
braddress2varchar(40)
braddress3varchar(40)
braddress4varchar(50)
braddress5varchar(20)
braddress6varchar(15)
latfloat(10,6) 0.000000
lngfloat(10,6) 0.000000
estdeliverydayssmallint(6) 1
areachar(3)
salesmanvarchar(4)
fwddatesmallint(6) 0
phonenovarchar(20)
faxnovarchar(20)
contactnamevarchar(30)
emailvarchar(55)
defaultlocationvarchar(5)
taxgroupidtinyint(4) 1
defaultshipviaint(11) 1
deliverblindtinyint(1) 1
disabletranstinyint(4) 0
brpostaddr1varchar(40)
brpostaddr2varchar(40)
brpostaddr3varchar(30)
brpostaddr4varchar(20)
brpostaddr5varchar(20)
brpostaddr6varchar(15)
specialinstructionstext
custbranchcodevarchar(30)

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

Continue insertion with rows