Drop files here

SQL upload ( 0 ) x-

Server: localhost »Database: herp »Table: addissue
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(20)
issue_slipnovarchar(50)
issuedatedate ...
mst_storeidint(4)
storevarchar(20)
issuetovarchar(20)
received_byvarchar(50)
departmentvarchar(50)
work_order_novarchar(50)
remarksvarchar(255)
totalqtydouble(10,2)
statusvarchar(15) Pending
createdbyvarchar(30)
createddatedate ...
check_statusvarchar(10) 0
issue_reg_novarchar(255)
cost_centervarchar(255)
material_received_byvarchar(255)
material_issue_byvarchar(255)
companyIDint(10)
finished_itemint(25)
job_card_noint(25)
job_card_datedate ...
finished_item_detailvarchar(255)
issue_floorint(11)
modified_byint(10)
modified_datedate ...
mrnidint(255)
issue_typevarchar(100)
mrs_idint(11)
areaint(11)
projectint(11)
wo_idint(11)
cancel_issueint(1) 0
job_idint(10)
issue_reg_datedate ...
indent_idint(11)
size_idint(11)
transaction_timedatetime ...
typevarchar(250)
to_storeint(11)


ColumnTypeFunctionNullValue
idint(5)
sitevarchar(20)
issue_slipnovarchar(50)
issuedatedate ...
mst_storeidint(4)
storevarchar(20)
issuetovarchar(20)
received_byvarchar(50)
departmentvarchar(50)
work_order_novarchar(50)
remarksvarchar(255)
totalqtydouble(10,2)
statusvarchar(15) Pending
createdbyvarchar(30)
createddatedate ...
check_statusvarchar(10) 0
issue_reg_novarchar(255)
cost_centervarchar(255)
material_received_byvarchar(255)
material_issue_byvarchar(255)
companyIDint(10)
finished_itemint(25)
job_card_noint(25)
job_card_datedate ...
finished_item_detailvarchar(255)
issue_floorint(11)
modified_byint(10)
modified_datedate ...
mrnidint(255)
issue_typevarchar(100)
mrs_idint(11)
areaint(11)
projectint(11)
wo_idint(11)
cancel_issueint(1) 0
job_idint(10)
issue_reg_datedate ...
indent_idint(11)
size_idint(11)
transaction_timedatetime ...
typevarchar(250)
to_storeint(11)

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

Continue insertion with rows