competence-rs.com / localhost / hmis / employee_masters

Navigation panel
Navigation tree
Databases
Tables

Navigation panel

Customize appearance of the navigation panel.

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.

Navigation tree

Customize the navigation tree.

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

Databases

Databases display options.

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

Tables

Tables display options.

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

Drop files here

SQL upload ( 0 ) x-

Server: localhost »

Database: hmis »

Table: employee_masters

Click on the bar to scroll to top of page

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:

Browse mode

Browse mode

Customize browse mode.

Table navigation bar Use only icons, only text or both.
How to display various action links Use only icons, only text or both.
Allow to display all the rows Whether a user should be displayed a "show all (rows)" button.
Maximum number of rows to display Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown.
Default sorting order `SMART` - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise.
Highlight pointer Highlight row pointed by the mouse cursor.
Row marker Highlight selected rows.
Grid editing: trigger action
Grid editing: save all edited cells at once
Repeat headers Repeat the headers every X cells, `0` deactivates this feature.
Limit column characters Maximum number of characters shown in any non-numeric column on browse view.
Where to show the table row links These are Edit, Copy and Delete links.
Show row links anyway Whether to show row links even in the absence of a unique key.
Primary key default sort order Default sort order for tables with a primary key.
Remember table's sorting When browsing tables, the sorting of each table is remembered.
Relational display For display Options

Showing rows 0 - 24 (302 total, Query took 0.0202 seconds.)

SELECT * FROM `employee_masters`

[ Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]

			id	empid	current_date	emp_name	dob	qualification	marital_status	a_year	a_month	a_day	gender	doj	blood_group	dol	father_sp	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 For voucher_discount_approvals form's MD appoval	posted_voucher_dis_apr_2 For voucher_discount_approvals form's MD's junior'…	locationname	biomatric_id
Edit	Copy	Delete DELETE FROM `employee_masters` WHERE `employee_masters`.`id` = 1	1	000001	08-06-2017 06:16:41	Admin	0000-00-00		Single				Male	2014-01-06	A+	0000-00-00				E	3	IT03	Information Technolo	A	NULL	NULL	NULL								NULL								2014-01-06 12:59:30	1	2017-06-08 00:46:46	1	yes	10.00	100.00	yes	10.00	20.00	no	NULL	no	no	AEH
Edit	Copy	Delete DELETE FROM `employee_masters` WHERE `employee_masters`.`id` = 8	8	000002	06-12-2019 02:42:16	Ramesh Chandra Maurya	1973-06-12	DCH	Married	46	7	3	Male	2007-10-28	O+	0000-00-00	Late Radhey Shyam Maurya	Hindu	AEH	E	3	IT03	Information Technology	A	ITM09	9	IT Manager	Muntaj nagar	Mumtaj nagar	sohawal	Ayodhya	70	4	21	224001	rcmauryahw@gmail.com				9415917910			2017-06-08 07:16:06	NULL	2019-12-05 21:12:29	218	yes	NULL	NULL	yes	NULL	NULL	no	2	no	no	AEH	0
Edit	Copy	Delete DELETE FROM `employee_masters` WHERE `employee_masters`.`id` = 9	9	000003	10-06-2017 04:24:44	Dr Ashutosh Rastogi	1970-06-08	DO	Married	48	1	15	Male	2016-12-02	B+	2017-12-01	NA	Hindu	AEH	D	4	OPTL04	Opthalmology	I	SS13	13	Senior Surgeon	Na				70	4	21	224001					1111111111			2017-06-08 07:17:56	NULL	2017-06-09 22:55:29	1	no	NULL	NULL	no	NULL	NULL	no	3	no	no	AEH
Edit	Copy	Delete DELETE FROM `employee_masters` WHERE `employee_masters`.`id` = 10	10	000004	29-10-2019 09:47:04	Dr Vipin Kumar Singh	1984-09-12		Married	35	1	17	Male	2017-06-08	A+	0000-00-00	NA	Hindu	AEH	D	4	OPTL04	Opthalmology	I	SS13	4	Senior Surgeon	Swargdwar	Ram Ki Paidi Nayagha	Ayodhya		70	4	21	224123		234207			9415111272			2017-06-08 07:18:12	NULL	2019-10-29 04:17:10	2	no	NULL	NULL	no	NULL	NULL	no	4	no	no	AEH	472
Edit	Copy	Delete DELETE FROM `employee_masters` WHERE `employee_masters`.`id` = 11	11	000005	26-07-2017 01:31:57	Pawan Kumar Sah	1953-06-08		Married	66	8	11	Male	2009-10-01	AB	0000-00-00	NA	Hindu	AEH	E	19	ADM19	Administration Department	A	CON51	51	Co-Ordinator	swargdwar	nayaghat	ayodhya		70	0	0	224001					9415111272			2017-06-08 07:18:35	NULL	2017-07-25 20:02:12	1	yes	NULL	NULL	no	NULL	NULL	no	5	no	no	AEH	0
Edit	Copy	Delete DELETE FROM `employee_masters` WHERE `employee_masters`.`id` = 12	12	000006	07-12-2018 05:00:35	Rabindra Pratap Singh	1951-06-08		Married	67	1	20	Male	2017-06-08	A+	0000-00-00	NA	Hindu	AEH	E	19	ADM19	Administration Department	I	MNG50	18	Manager	3/24 Adarsha Nagar C	colcota	colcota 31		46	17	21	700031					8957791505			2017-06-08 07:21:57	NULL	2018-12-06 23:30:39	1	no	NULL	NULL	no	NULL	NULL	no	6	no	no	AEH
Edit	Copy	Delete DELETE FROM `employee_masters` WHERE `employee_masters`.`id` = 13	13	000007	21-03-2023 09:53:00	Babul Roy	1951-03-10		Married	68	10	20	Male	2010-03-06	B+	0000-00-00	Late M. L. Roy	Hindu	AEH	E	12	HK12	House Keeping	I	HKI35	12	House Keeping Incharge	Vill - Kadipur	Post - Barun Bazar			70	4	21	224127					9919501305			2017-06-08 07:22:35	NULL	2023-03-21 04:23:12	218	no	NULL	NULL	no	NULL	NULL	no	7	no	no	AEH	132
Edit	Copy	Delete DELETE FROM `employee_masters` WHERE `employee_masters`.`id` = 14	14	000008	02-10-2020 12:16:13	Kuldeep Dubey	1989-03-07	ITI	Married	30	11	5	Male	2009-12-12	A+	0000-00-00	Kailash Nath Dubey	Hindu	AEH	E	8	FD08	Finance Department	A	AM24	8	Account Manager	LIG 10	kaulesh kunj	Ayodhya		70	4	21	224123	kuldeepdubey47@gmail.com				8423543925			2017-06-08 07:22:56	NULL	2020-10-02 06:46:28	218	yes	NULL	NULL	no	NULL	NULL	no	8	no	no	AEH	2
Edit	Copy	Delete DELETE FROM `employee_masters` WHERE `employee_masters`.`id` = 15	15	000009	12-02-2019 02:26:38	Sunil Srivastava	1971-09-26	CA Work	Married	49	3	4	Male	2009-10-24	O+	0000-00-00	Jugal Kishor Srivastava	Hindu	AEH	E	8	FD08	Finance Department	A	SA23	23	Senior Accountant	Nagarbagh	Mandi	Ayodhya		70	4	21	224123					1111111111			2017-06-08 07:23:18	NULL	2019-02-11 21:00:58	2	no	NULL	NULL	no	NULL	NULL	no	9	no	no	AEH	3
Edit	Copy	Delete DELETE FROM `employee_masters` WHERE `employee_masters`.`id` = 16	16	000010	NULL	Vikash Kaushal	1992-06-08		Married	26	1	9	Male	2017-06-08	B	0000-00-00	NA	Hindu	AEH	E	8	FD08	Finance Department	I	JA22	22	Junior Accountant	Swargdwar	Ram Ki Paidi Nayagha	Ayodhya	NULL	70	4	21	224123			NULL	NULL	7408277543	NULL	NULL	2017-06-08 07:24:34	NULL	0000-00-00 00:00:00	NULL	no	NULL	NULL	no	NULL	NULL	no	10	no	no	AEH	328
Edit	Copy	Delete DELETE FROM `employee_masters` WHERE `employee_masters`.`id` = 17	17	000011	12-12-2018 10:31:13	Sachin Pandey	1992-10-31	ccc	Married	27	2	7	Male	2014-12-19	B+	0000-00-00	Umesh Prasad Pandey	Hindu	AEH	E	1	RD01	Front Desk	I	FM03	3	FRONT DESK MANAGER	Vill - Beladeeh	Post - Tamakhash		faizabad	70	4	21	272164	sachinpandey1992@gmail.com				7523008103			2017-06-08 07:26:18	NULL	2018-12-12 05:02:53	2	no	0.00	100.00	yes	0.00	100.00	yes	11	no	no	AEH
Edit	Copy	Delete DELETE FROM `employee_masters` WHERE `employee_masters`.`id` = 18	18	000012	23-07-2019 12:16:20	Vishal Pandey	1995-07-18	DCA	Married	25	3	12	Male	2016-11-17	B	0000-00-00	Uma Shankar Pandey	Hindu	AHB	E	8	FD08	Finance Department	A	JA22	22	Junior Accountant	H.N. 25/04/51	Lavkush Nagar	Ramghat Ayodhya		70	4	21	224123	visalpandey123@gmail.com				7355506068			2017-06-08 07:27:08	NULL	2019-07-23 06:46:28	2	no	0.00	100.00	yes	0.00	100.00	yes	12	no	no	AHB	4
Edit	Copy	Delete DELETE FROM `employee_masters` WHERE `employee_masters`.`id` = 19	19	000013	30-08-2019 09:30:55	Shraddha Mishra	1993-06-25	CCCA	Married	26	7	14	Female	2016-10-01	AB	0000-00-00	V. B. Mishra	Hindu	AEH	E	1	RD01	Front Desk	A	SE02	2	SENIOR EXECUTIVE				faizabad				0	shradhamishra@gmail.com							2017-06-08 07:27:52	NULL	2019-08-30 04:01:01	2	no	0.00	100.00	yes	0.00	100.00	yes	13	no	no	AEH	12
Edit	Copy	Delete DELETE FROM `employee_masters` WHERE `employee_masters`.`id` = 20	20	000020	2017-06-09 10:45:24	Amit Mishra	1988-10-19		Single	31	3	19	Male	2010-05-01	A+	0000-00-00	NA	Hindu	APH	E	10	PH10	Pharmacy	A	JPH27	27	Junior Pharmacist	Katari Mandir	Nayaghat	Ayodhya	NULL	70	4	21	224123			NULL	NULL	1111111111	NULL	NULL	2017-06-08 18:30:00	NULL	0000-00-00 00:00:00	NULL	no	NULL	NULL	no	NULL	NULL	no	14	no	no	APH	69
Edit	Copy	Delete DELETE FROM `employee_masters` WHERE `employee_masters`.`id` = 21	21	000021	2017-06-09 10:49:31	Kunwar Tiwari	1963-01-01		Married	57	1	12	Male	2010-03-17	A+	0000-00-00	NA	Hindu	APH	E	20	OPT20	Optical	A	OPT52	52	OPTICAL	Nawabganj			NULL	70	4	21	224123			NULL	NULL	11111111111	NULL	NULL	2017-06-08 18:30:00	NULL	0000-00-00 00:00:00	NULL	no	NULL	NULL	no	NULL	NULL	no	15	no	no	APH	72
Edit	Copy	Delete DELETE FROM `employee_masters` WHERE `employee_masters`.`id` = 22	22	000022	14-06-2017 05:48:31	Dinesh Prajapati	1990-08-17		Married	27	5	4	Male	2010-10-13	B	0000-00-00	na	Hindu	APH	E	20	OPT20	Optical	I	OPT52	52	OPTICAL	Vill- Paliya Gova	Post - Masaudha	Motinagar		70	4	21	224127					1111111111			2017-06-08 18:30:00	NULL	2017-06-14 00:18:43	1	no	NULL	NULL	no	NULL	NULL	no	16	no	no	APH	196
Edit	Copy	Delete DELETE FROM `employee_masters` WHERE `employee_masters`.`id` = 23	23	000023	20-07-2017 12:37:58	Deepak Sharma	1986-09-19		Married	33	4	20	Male	2011-06-21	A+	0000-00-00	na	Hindu	APH	E	20	OPT20	Optical	A	OPT52	52	OPTICAL	Nawabganj	na			70	4	21	224123					1111111111			2017-06-08 18:30:00	NULL	2017-07-20 07:08:14	1	no	NULL	NULL	no	NULL	NULL	no	17	no	no	APH	71
Edit	Copy	Delete DELETE FROM `employee_masters` WHERE `employee_masters`.`id` = 24	24	000024	2017-06-09 11:10:58	Roop Shri Shukla	1990-06-10		Married	29	8	0	Male	2011-09-05	A+	0000-00-00	Na	Hindu	APH	E	20	OPT20	Optical	A	OPT52	52	OPTICAL	na			NULL	70	4	21	224123			NULL	NULL	1111111111	NULL	NULL	2017-06-08 18:30:00	NULL	0000-00-00 00:00:00	NULL	no	NULL	NULL	no	NULL	NULL	no	18	no	no	APH	73
Edit	Copy	Delete DELETE FROM `employee_masters` WHERE `employee_masters`.`id` = 25	25	000025	2017-06-09 11:12:39	KULDEEP TIWARI	1981-04-25		Married	38	9	18	Male	2011-09-02	A+	0000-00-00	na	Hindu	APH	E	10	PH10	Pharmacy	A	PHI29	29	Pharmacist Incharge	ayodhay			NULL	70	4	21	224123			NULL	NULL	1111111111	NULL	NULL	2017-06-08 18:30:00	NULL	0000-00-00 00:00:00	NULL	no	NULL	NULL	no	NULL	NULL	no	19	no	no	APH	68
Edit	Copy	Delete DELETE FROM `employee_masters` WHERE `employee_masters`.`id` = 26	26	000026	2017-06-09 11:14:28	Arjun Shonkar	2000-02-01		Married	19	1	15	Male	2013-12-06	B+	0000-00-00	na	Hindu	APH	E	20	OPT20	Optical	I	OPT52	52	OPTICAL	10, Kashi ram colony	Ramghat	Ayodhya	NULL	70	4	21	224123			NULL	NULL	1111111111	NULL	NULL	2017-06-08 18:30:00	NULL	0000-00-00 00:00:00	NULL	no	NULL	NULL	no	NULL	NULL	no	20	no	no	APH	403
Edit	Copy	Delete DELETE FROM `employee_masters` WHERE `employee_masters`.`id` = 27	27	000027	14-06-2017 04:36:11	Krishna Kumar Gupta	1987-09-02		Married	32	5	7	Male	2012-04-01	B+	0000-00-00	Na	Hindu	APH	E	20	OPT20	Optical	A	OPT52	52	OPTICAL	ayodhya				70	4	21	224123					1111111111			2017-06-08 18:30:00	NULL	2017-06-13 23:06:32	1	no	NULL	NULL	no	NULL	NULL	no	21	no	no	APH	74
Edit	Copy	Delete DELETE FROM `employee_masters` WHERE `employee_masters`.`id` = 28	28	000028	2017-06-09 11:23:45	SATYENDRA KUMAR	1995-08-10		Married	23	0	14	Male	2015-10-01	A+	0000-00-00	Ramnaresh chaursiya	Hindu	APH	E	10	PH10	Pharmacy	I	JPH27	27	Junior Pharmacist	Tulsi Nagar	Ayodhya		NULL	70	4	21	224123	satyendrak904@gmail.com		NULL	NULL	1111111111	NULL	NULL	2017-06-08 18:30:00	NULL	0000-00-00 00:00:00	NULL	no	NULL	NULL	no	NULL	NULL	no	22	no	no	APH	458
Edit	Copy	Delete DELETE FROM `employee_masters` WHERE `employee_masters`.`id` = 29	29	000029	2017-06-09 11:25:17	Pradeep Chandra	1996-07-03		Married	22	0	13	Male	2016-09-07	B	0000-00-00	na	Hindu	APH	E	10	PH10	Pharmacy	I	JPH27	27	Junior Pharmacist	Tedhi Bazar	Ayodhya		NULL	70	4	21	224123			NULL	NULL	1111111111	NULL	NULL	2017-06-08 18:30:00	NULL	0000-00-00 00:00:00	NULL	no	NULL	NULL	no	NULL	NULL	no	23	no	no	APH	20001
Edit	Copy	Delete DELETE FROM `employee_masters` WHERE `employee_masters`.`id` = 30	30	000030	01-08-2019 10:59:20	Janardan Achari	1970-06-09		Married	49	8	5	Male	2005-11-15	A+	0000-00-00	na	Hindu	AEH	E	9	STR09	Store	A	STI26	26	Store Incharge	ayodhya	Ayodhya			70	4	21	224123					1111111111			2017-06-08 18:30:00	NULL	2019-08-01 05:29:34	2	no	NULL	NULL	no	NULL	NULL	no	24	no	no	AEH	6
Edit	Copy	Delete DELETE FROM `employee_masters` WHERE `employee_masters`.`id` = 31	31	000031	2017-06-09 12:00:03	Shiv Karan Ojha	1960-02-01		Married	60	0	12	Male	2012-08-01	A+	0000-00-00	na	Hindu	AEH	E	9	STR09	Store	A	STE25	25	Store Excecutive	na			NULL	70	4	21	224001			NULL	NULL	1111111111	NULL	NULL	2017-06-08 18:30:00	NULL	0000-00-00 00:00:00	NULL	no	NULL	NULL	no	NULL	NULL	no	25	no	no	AEH	8

Check all With selected:

Query results operations

Print view

Export

Display chart

Create view