Drop files here

SQL upload ( 0 ) x-

Server: localhost »Database: herp »Table: emp_attandence
Page-related settingsClick on the bar to scroll to top of page
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(11)
empidint(11)
empdeptvarchar(20)
attd_monthchar(2)
date1char(10)
date2char(10)
date3char(10)
date4char(10)
date5char(10)
date6char(10)
date7char(10)
date8char(10)
date9char(10)
date10char(10)
date11char(10)
date12char(10)
date13char(10)
date14char(10)
date15char(10)
date16char(10)
date17char(10)
date18char(10)
date19char(10)
date20char(10)
date21char(10)
date22char(10)
date23char(10)
date24char(10)
date25char(10)
date26char(10)
date27char(10)
date28char(10)
date29char(10)
date30char(10)
date31char(10)
outtime1char(10)
outtime2char(10)
outtime3char(10)
outtime4char(10)
outtime5char(10)
outtime6char(10)
outtime7char(10)
outtime8char(10)
outtime9char(10)
outtime10char(10)
outtime11char(10)
outtime12char(10)
outtime13char(10)
outtime14char(10)
outtime15char(10)
outtime16char(10)
outtime17char(10)
outtime18char(10)
outtime19char(10)
outtime20char(10)
outtime21char(10)
outtime22char(10)
outtime23char(10)
outtime24char(10)
outtime25char(10)
outtime26char(10)
outtime27char(10)
outtime28char(10)
outtime29char(10)
outtime30char(10)
outtime31char(10)


ColumnTypeFunctionNullValue
idint(11)
empidint(11)
empdeptvarchar(20)
attd_monthchar(2)
date1char(10)
date2char(10)
date3char(10)
date4char(10)
date5char(10)
date6char(10)
date7char(10)
date8char(10)
date9char(10)
date10char(10)
date11char(10)
date12char(10)
date13char(10)
date14char(10)
date15char(10)
date16char(10)
date17char(10)
date18char(10)
date19char(10)
date20char(10)
date21char(10)
date22char(10)
date23char(10)
date24char(10)
date25char(10)
date26char(10)
date27char(10)
date28char(10)
date29char(10)
date30char(10)
date31char(10)
outtime1char(10)
outtime2char(10)
outtime3char(10)
outtime4char(10)
outtime5char(10)
outtime6char(10)
outtime7char(10)
outtime8char(10)
outtime9char(10)
outtime10char(10)
outtime11char(10)
outtime12char(10)
outtime13char(10)
outtime14char(10)
outtime15char(10)
outtime16char(10)
outtime17char(10)
outtime18char(10)
outtime19char(10)
outtime20char(10)
outtime21char(10)
outtime22char(10)
outtime23char(10)
outtime24char(10)
outtime25char(10)
outtime26char(10)
outtime27char(10)
outtime28char(10)
outtime29char(10)
outtime30char(10)
outtime31char(10)

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

Continue insertion with rows