Drop files here

SQL upload ( 0 ) x-

Server: localhost »Database: hmis »Table: employee_masters
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(6)
empidvarchar(6)
current_datevarchar(20)
emp_namevarchar(30)
dobdate ...
qualificationvarchar(20)
marital_statusvarchar(10)
a_yearvarchar(4)
a_monthvarchar(2)
a_dayvarchar(2)
gendervarchar(6)
dojdate ...
blood_groupvarchar(2)
doldate ...
father_spvarchar(30)
pfvarchar(20)
relegionvarchar(15)
locationvarchar(20)
staff_typevarchar(10)
department_master_idint(6)
dept_codevarchar(6)
dept_descvarchar(50)
statusvarchar(6)
desigcodevarchar(6)
designation_idvarchar(6)
descriptionvarchar(50)
house_novarchar(20)
streetvarchar(20)
a_locationvarchar(20)
districtvarchar(20)
townvarchar(20)
statevarchar(20)
countryvarchar(20)
pinint(6)
emailvarchar(30)
ph1varchar(15)
ph2varchar(15)
ph3varchar(15)
mobvarchar(15)
faxvarchar(15)
pagervarchar(15)
created_datetimestamp CURRENT_TIMESTAMP ...
created_byint(6)
modified_datetimestamp 0000-00-00 00:00:00.000000 ...
modified_byint(6)
authenum-- no
min_discountfloat(10,2)
max_discountfloat(10,2)
dis_requestenum-- no
req_dis_minfloat(10,2)
req_dis_maxfloat(10,2)
cashenum-- no
nippon_emp_idint(11)
posted_voucher_dis_apr_1enum-- no
posted_voucher_dis_apr_2enum-- no
locationnamevarchar(20)
biomatric_idvarchar(20)


ColumnTypeFunctionNullValue
idint(6)
empidvarchar(6)
current_datevarchar(20)
emp_namevarchar(30)
dobdate ...
qualificationvarchar(20)
marital_statusvarchar(10)
a_yearvarchar(4)
a_monthvarchar(2)
a_dayvarchar(2)
gendervarchar(6)
dojdate ...
blood_groupvarchar(2)
doldate ...
father_spvarchar(30)
pfvarchar(20)
relegionvarchar(15)
locationvarchar(20)
staff_typevarchar(10)
department_master_idint(6)
dept_codevarchar(6)
dept_descvarchar(50)
statusvarchar(6)
desigcodevarchar(6)
designation_idvarchar(6)
descriptionvarchar(50)
house_novarchar(20)
streetvarchar(20)
a_locationvarchar(20)
districtvarchar(20)
townvarchar(20)
statevarchar(20)
countryvarchar(20)
pinint(6)
emailvarchar(30)
ph1varchar(15)
ph2varchar(15)
ph3varchar(15)
mobvarchar(15)
faxvarchar(15)
pagervarchar(15)
created_datetimestamp CURRENT_TIMESTAMP ...
created_byint(6)
modified_datetimestamp 0000-00-00 00:00:00.000000 ...
modified_byint(6)
authenum-- no
min_discountfloat(10,2)
max_discountfloat(10,2)
dis_requestenum-- no
req_dis_minfloat(10,2)
req_dis_maxfloat(10,2)
cashenum-- no
nippon_emp_idint(11)
posted_voucher_dis_apr_1enum-- no
posted_voucher_dis_apr_2enum-- no
locationnamevarchar(20)
biomatric_idvarchar(20)

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

Continue insertion with rows