competence-rs.com / localhost / hmis / employee_masters

Show databases navigation as tree In the navigation panel, replaces the database tree with a selector
Link with main panel Link with main panel by highlighting the current database or table.
Display logo Show logo in navigation panel.
Logo link URL URL where logo in the navigation panel will point to.
Logo link target Open the linked page in the main window (`main`) or in a new one (`new`).
Enable highlighting Highlight server under the mouse cursor.
Maximum items on first level The number of items that can be displayed on each page on the first level of the navigation tree.
Minimum number of items to display the filter box Defines the minimum number of items (tables, views, routines and events) to display a filter box.
Recently used tables Maximum number of recently used tables; set 0 to disable.
Favorite tables Maximum number of favorite tables; set 0 to disable.

Maximum items in branch The number of items that can be displayed on each page of the navigation tree.
Group items in the tree Group items in the navigation tree (determined by the separator defined in the Databases and Tables tabs above).
Enable navigation tree expansion Whether to offer the possibility of tree expansion in the navigation panel.
Show tables in tree Whether to show tables under database in the navigation tree
Show views in tree Whether to show views under database in the navigation tree
Show functions in tree Whether to show functions under database in the navigation tree
Show procedures in tree Whether to show procedures under database in the navigation tree
Show events in tree Whether to show events under database in the navigation tree

Minimum number of databases to display the database filter box
Database tree separator String that separates databases into different tree levels.

Target for quick access icon
Target for second quick access icon
Table tree separator String that separates tables into different tree levels.
Maximum table tree depth

Press Ctrl+Enter to execute query

Collapse Expand Show trace Hide trace Time taken:

No bookmarks

Label: Target database: Share this bookmark

Always expand query messages
Show query history at start
Show current browsing query
Execute queries on Enter and insert new line with Shift + Enter. To make this permanent, view settings.
Switch to dark theme

Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database: Queried time:

Column

Type

Collation

Operator

Value

int(6)

empid

varchar(6)

latin1_swedish_ci

current_date

varchar(20)

latin1_swedish_ci

emp_name

varchar(30)

latin1_swedish_ci

dob

date

qualification

varchar(20)

latin1_swedish_ci

marital_status

varchar(10)

latin1_swedish_ci

a_year

varchar(4)

latin1_swedish_ci

a_month

varchar(2)

latin1_swedish_ci

a_day

varchar(2)

latin1_swedish_ci

gender

varchar(6)

latin1_swedish_ci

doj

date

blood_group

varchar(2)

latin1_swedish_ci

dol

date

father_sp

varchar(30)

latin1_swedish_ci

varchar(20)

latin1_swedish_ci

relegion

varchar(15)

latin1_swedish_ci

location

varchar(20)

latin1_swedish_ci

staff_type

varchar(10)

latin1_swedish_ci

department_master_id

int(6)

dept_code

varchar(6)

latin1_swedish_ci

dept_desc

varchar(50)

latin1_swedish_ci

status

varchar(6)

latin1_swedish_ci

desigcode

varchar(6)

latin1_swedish_ci

designation_id

varchar(6)

latin1_swedish_ci

description

varchar(50)

latin1_swedish_ci

house_no

varchar(20)

latin1_swedish_ci

street

varchar(20)

latin1_swedish_ci

a_location

varchar(20)

latin1_swedish_ci

district

varchar(20)

latin1_swedish_ci

town

varchar(20)

latin1_swedish_ci

state

varchar(20)

latin1_swedish_ci

country

varchar(20)

latin1_swedish_ci

int(6)

varchar(30)

latin1_swedish_ci

ph1

varchar(15)

latin1_swedish_ci

ph2

varchar(15)

latin1_swedish_ci

ph3

varchar(15)

latin1_swedish_ci

mob

varchar(15)

latin1_swedish_ci

fax

varchar(15)

latin1_swedish_ci

pager

varchar(15)

latin1_swedish_ci

created_date

timestamp

created_by

int(6)

modified_date

timestamp

modified_by

int(6)

auth

enum('yes', 'no')

latin1_swedish_ci

min_discount

float(10,2)

max_discount

float(10,2)

dis_request

enum('yes', 'no')

latin1_swedish_ci

req_dis_min

float(10,2)

req_dis_max

float(10,2)

cash

enum('no', 'yes')

latin1_swedish_ci

nippon_emp_id

int(11)

posted_voucher_dis_apr_1

enum('no', 'yes')

latin1_swedish_ci

posted_voucher_dis_apr_2

enum('no', 'yes')

latin1_swedish_ci

locationname

varchar(20)

latin1_swedish_ci

biomatric_id

varchar(20)

latin1_swedish_ci

id
empid
current_date
emp_name
dob
qualification
marital_status
a_year
a_month
a_day
gender
doj
blood_group
dol
father_sp
pf
relegion
location
staff_type
department_master_id
dept_code
dept_desc
status
desigcode
designation_id
description
house_no
street
a_location
district
town
state
country
pin
email
ph1
ph2
ph3
mob
fax
pager
created_date
created_by
modified_date
modified_by
auth
min_discount
max_discount
dis_request
req_dis_min
req_dis_max
cash
nippon_emp_id
posted_voucher_dis_apr_1
posted_voucher_dis_apr_2
locationname
biomatric_id

SQL upload ( 0 ) x-