competence-rs.com / localhost / herp / empmaster

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: herp »

Table: empmaster

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 (253 total, Query took 0.0191 seconds.) [id: 306... - 282...]

SELECT * FROM `empmaster` ORDER BY `id`  DESC

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

			id 1	mst_www_userid	emp_site	employment_type	employee_type	emp_code	emp_name	fh_name	nationality	religion	dob	doj	dol	department	emp_shift	emp_weekly_off	designation	marital_status	marriage	wh_name	sex	grade	leave_eff_date	bachelor	other_bachelor	master	basic_perc	eff_sal_date	adv_date	document2	document3	ESI_account	PF_accountno	payment_mode	created_by	created_date	CompanyId	bloodgroup	course1	tenth_standard	tenthplus2_standard	otapplicable	auth	status	loan_ledger	advance_ledger	staff_type	biomatric_id
Edit	Copy	Delete DELETE FROM `empmaster` WHERE `empmaster`.`id` = 306	306	NULL	AHB	E	34	000311	Aviral Singh	Bhanu Pratap Singh	indian	hindu	1992-03-29	2024-07-11	0000-00-00	18	44	7	50	Married	0000-00-00	N/A	Male	1	2024-07-17	B.Sc	NULL		4000.00	0000-00-00	0000-00-00	NULL	NULL	NULL	NULL	Cheque	115	2024-07-17	3	A+	MBA	true	true	N	yes	A	NULL	NULL	R	0
Edit	Copy	Delete DELETE FROM `empmaster` WHERE `empmaster`.`id` = 305	305	NULL	AHB	E	34	000310	Ravi Shankar Sharma	Ram Kumar Sharma	indian	hindu	1991-10-02	2024-04-01	0000-00-00	9	44	7	26	Married	2024-04-10	N/A	Male	1	2024-04-10	B.Tech/B.E	NULL		4000.00	0000-00-00	0000-00-00	NULL	NULL	NULL	NULL	Cheque	115	2024-04-10	3	A+		true	true	N	yes	A	NULL	NULL	R	0
Edit	Copy	Delete DELETE FROM `empmaster` WHERE `empmaster`.`id` = 304	304	NULL	AEH	E	34	000309	Durgesh Chandra Srivastava	krishna mohan	indian	hindu	1984-07-15	2024-04-02	0000-00-00	7	NULL	7	21	Married	2024-04-10	N/A	Male	1	2024-04-10	B.A	NULL		4000.00	0000-00-00	0000-00-00	NULL	NULL	NULL	NULL	Cheque	115	2024-04-10	3	A+	PGDCA	true	true		yes	A	NULL	NULL	R	176
Edit	Copy	Delete DELETE FROM `empmaster` WHERE `empmaster`.`id` = 303	303	NULL	AHB	D	34	000308	Dr. Shitiz Saxena	Dr. Rajeev Saxena	indian	hindu	1990-10-02	2024-03-13	0000-00-00	4	44	7	10	Married	0000-00-00	N/A	Male	1	2024-03-14	MBBS	NULL	MS	4000.00	0000-00-00	0000-00-00	NULL	NULL	NULL	NULL	Cheque	115	2024-03-14	3	A+		true	true	N	yes	A	NULL	NULL	R	0
Edit	Copy	Delete DELETE FROM `empmaster` WHERE `empmaster`.`id` = 302	302	NULL	AHB	D	34	000307	Dr. Rahul Kumar	Shree Dhruv Narayan Mahto	indian	hindu	1993-04-07	2024-01-06	0000-00-00	4	44	7	10	Married	0000-00-00	N/A	Male	1	2024-01-09	MBBS	NULL	MS	4000.00	0000-00-00	0000-00-00	NULL	NULL	NULL	NULL	Cheque	115	2024-01-09	3	A+		true	true	N	yes	A	NULL	NULL	R	0
Edit	Copy	Delete DELETE FROM `empmaster` WHERE `empmaster`.`id` = 301	301	NULL	AEH	D	34	000306	Dr. Lokesh Mehla	shree Raj Kumar mehla	indian	hindu	1995-12-14	2024-01-09	0000-00-00	4	NULL	7	10	Married	0000-00-00		Male	1	2024-01-09	MBBS	NULL	MS	4000.00	0000-00-00	0000-00-00	NULL	NULL	NULL	NULL	Cheque	115	2024-01-09	3	A+		true	true		yes	A	NULL	NULL	R	0
Edit	Copy	Delete DELETE FROM `empmaster` WHERE `empmaster`.`id` = 300	300	NULL	AEH	E	34	000305	Awadhesh Kumar	Harakhu Chaurasiya	indian	hindu	2003-06-05	2023-12-13	0000-00-00	2	34	7	4	Married	0000-00-00	N/A	Male	1	2023-12-21	Diploma	NULL		4000.00	0000-00-00	0000-00-00	NULL	NULL	NULL	NULL	Cheque	115	2023-12-21	3	A+	optm	true	true	N	yes	A	NULL	NULL	R	169
Edit	Copy	Delete DELETE FROM `empmaster` WHERE `empmaster`.`id` = 299	299	NULL	AEH	E	34	000304	Anju Maurya	Saryu Prasad	indian	hindu	2003-12-11	2023-12-13	0000-00-00	2	34	7	4	Married	0000-00-00	N/A	Female	1	2023-12-21	Diploma	NULL		4000.00	0000-00-00	0000-00-00	NULL	NULL	NULL	NULL	Cheque	115	2023-12-21	3	A	optm	true	true	N	yes	A	NULL	NULL	R	168
Edit	Copy	Delete DELETE FROM `empmaster` WHERE `empmaster`.`id` = 298	298	NULL	AEH	D	34	000303	Dr. Suraj Singh	Ram Naresh Singh	indian	hindu	2023-10-24	2023-10-24	0000-00-00	4	34	7	10	Married	0000-00-00	N/A	Male	1	2023-10-24	MBBS	NULL	MS	4000.00	0000-00-00	0000-00-00	NULL	NULL	NULL	NULL	Cheque	115	2023-10-24	3	B		true	true	N	yes	A	NULL	NULL	R	0
Edit	Copy	Delete DELETE FROM `empmaster` WHERE `empmaster`.`id` = 297	297	NULL	AEH	E	34	000302	Gauri	Kamlesh Das Shastri	indian	hindu	2023-09-22	2023-09-22	0000-00-00	1	34	7	1	Married	0000-00-00	N/A	Female	1	2023-09-22	B.A	NULL	M.A	4000.00	0000-00-00	0000-00-00	NULL	NULL	NULL	NULL	Cheque	115	2023-09-22	3	B		true	true	N	yes	A	NULL	NULL	R	0
Edit	Copy	Delete DELETE FROM `empmaster` WHERE `empmaster`.`id` = 296	296	NULL	AEH	D	34	000301	Dr.Sajan Dev Kesar	Shashi Kant Kesar	indian	hindu	2023-09-21	2023-09-22	0000-00-00	4	NULL	7	12	Married	2023-09-21	N/A	Male	1	2023-09-21	MBBS	NULL	MS	4000.00	0000-00-00	0000-00-00	NULL	NULL	NULL	NULL	Cheque	115	2023-09-21	3	A+		true	true		yes	A	NULL	NULL	R	0
Edit	Copy	Delete DELETE FROM `empmaster` WHERE `empmaster`.`id` = 295	295	NULL	AHB	D	34	000300	Dr. Jyoti Singh	Surendra Kumar Singh	indian	hindu	2023-09-18	2023-09-18	0000-00-00	4	44	7	10	Married	0000-00-00	N/A	Female	1	2023-09-18	MBBS	NULL	MS	4000.00	0000-00-00	0000-00-00	NULL	NULL	NULL	NULL	Cheque	115	2023-09-18	3	A+	DNB,	true	true	N	yes	A	NULL	NULL	R	0
Edit	Copy	Delete DELETE FROM `empmaster` WHERE `empmaster`.`id` = 294	294	NULL	AEH	E	34	000299	Shravan Kumar	fool chand Chaudhary	indian	hindu	2023-09-16	2023-09-16	0000-00-00	6	NULL	7	17	Married	0000-00-00		Male	1	2023-09-16	B.Sc	NULL		4000.00	0000-00-00	0000-00-00	NULL	NULL	NULL	NULL	Cheque	115	2023-09-16	3	A+	Ot tech	true	true		yes	A	NULL	NULL	R	0
Edit	Copy	Delete DELETE FROM `empmaster` WHERE `empmaster`.`id` = 293	293	NULL	AEH	E	34	000298	Umesh Kumar	Ratnesh kumar pandey	indian	hindu	2023-08-26	2023-08-26	0000-00-00	25	NULL	7	66	Married	2023-08-26	N/A	Male	1	2023-08-26	B.A	NULL	M.A	4000.00	0000-00-00	0000-00-00	NULL	NULL	NULL	NULL	Cheque	115	2023-08-26	3	B		true	true		yes	A	NULL	NULL	R	0
Edit	Copy	Delete DELETE FROM `empmaster` WHERE `empmaster`.`id` = 292	292	NULL	AHB	E	34	000297	Ashish Kumar	Bhagwan Deen	indian	hindu	2023-08-26	2023-08-26	0000-00-00	18	44	7	51	Married	2023-08-26	N/A	Male	1	2023-08-26	B.Tech/B.E	NULL		4000.00	0000-00-00	0000-00-00	NULL	NULL	NULL	NULL	Cheque	115	2023-08-26	3	A+	MBA	true	true	N	yes	A	NULL	NULL	R	0
Edit	Copy	Delete DELETE FROM `empmaster` WHERE `empmaster`.`id` = 291	291	NULL	AHB	E	34	000296	Awdhesh Ram Pandey	Dinesh Chandra Pandey	indian	hindu	1992-01-01	2023-08-11	0000-00-00	2	44	7	4	Married	0000-00-00	N/A	Male	1	2023-08-11	Diploma	NULL		4000.00	0000-00-00	0000-00-00	NULL	NULL	NULL	NULL	Cheque	115	2023-08-11	3	A+	optm	true	true	N	yes	A	NULL	NULL	R	0
Edit	Copy	Delete DELETE FROM `empmaster` WHERE `empmaster`.`id` = 290	290	NULL	AHB	E	34	000295	Amarnath gupta	Ram shankar gupta	indian	hindu	2023-08-11	2023-08-11	0000-00-00	2	44	7	4	Married	0000-00-00	N/A	Male	1	2023-08-11	Diploma	NULL		4000.00	0000-00-00	0000-00-00	NULL	NULL	NULL	NULL	Cheque	115	2023-08-11	3	A	optm	true	true	N	yes	A	NULL	NULL	R	0
Edit	Copy	Delete DELETE FROM `empmaster` WHERE `empmaster`.`id` = 289	289	NULL	AEH	D	34	000294	Dr. Amar Kumar	Sri Ganga Ram Pandit	indian	hindu	1992-02-25	2023-07-12	0000-00-00	4	34	7	12	Married	0000-00-00	N/A	Male	1	2023-07-12	MBBS	NULL	MS	4000.00	0000-00-00	0000-00-00	NULL	NULL	NULL	NULL	Cheque	115	2023-07-12	3	A+		true	true	N	yes	A	NULL	NULL	R	0
Edit	Copy	Delete DELETE FROM `empmaster` WHERE `empmaster`.`id` = 288	288	NULL	AHB	E	34	000293	Vikash Yadav	virendra pratap yadav	indian	hindu	2023-07-08	2023-07-08	0000-00-00	1	44	7	3	Married	0000-00-00	N/A	Male	1	2023-07-08	B.A	NULL		4000.00	0000-00-00	0000-00-00	NULL	NULL	NULL	NULL	Cheque	115	2023-07-08	3	A+		true	true	N	yes	A	NULL	NULL	R	0
Edit	Copy	Delete DELETE FROM `empmaster` WHERE `empmaster`.`id` = 287	287	NULL	AEH	E	34	000292	Pooja Maurya	Chhotelal Maurya	indian	hindu	1999-12-21	2023-07-06	0000-00-00	1	NULL	7	1	Married	0000-00-00		Female	1	2023-07-06	B.Sc	NULL		4000.00	0000-00-00	0000-00-00	NULL	NULL	NULL	NULL	Cheque	115	2023-07-06	3	A	D pharma	true	true		yes	A	NULL	NULL	R	155
Edit	Copy	Delete DELETE FROM `empmaster` WHERE `empmaster`.`id` = 286	286	NULL	AEH	D	34	000291	Dr. Punam Tiwari	RAM SHANKAR TIWARI	indian	hindu	1983-03-25	2023-06-01	0000-00-00	4	NULL	7	12	Married	2023-06-01	N/A	Female	1	2023-06-01	MBBS	NULL	MS	4000.00	0000-00-00	0000-00-00	NULL	NULL	NULL	NULL	Cheque	115	2023-06-01	3	A		true	true		yes	A	NULL	NULL	R	0
Edit	Copy	Delete DELETE FROM `empmaster` WHERE `empmaster`.`id` = 285	285	NULL	AEH	E	34	000290	ravi sharma	shambhu nath sharma	indian	hindu	1998-08-10	2023-02-24	0000-00-00	1	NULL	7	1	Married	0000-00-00		Male	1	2023-03-14		NULL		4000.00	0000-00-00	0000-00-00	NULL	NULL	NULL	NULL	Cheque	115	2023-03-14	3	A+	ADCA	true	true		yes	A	NULL	NULL	R	0
Edit	Copy	Delete DELETE FROM `empmaster` WHERE `empmaster`.`id` = 284	284	NULL	AEH	D	34	000289	Dr. Farhat Siddiqui	Mohd Anzarul Hasan	indian	muslim	1988-04-01	2023-03-09	0000-00-00	4	34	7	10	Married	0000-00-00	N/A	Female	1	2023-03-09	MBBS	NULL	MS	4000.00	0000-00-00	0000-00-00	NULL	NULL	NULL	NULL	Cheque	115	2023-03-09	3	A		true	true	N	yes	A	NULL	NULL	R	0
Edit	Copy	Delete DELETE FROM `empmaster` WHERE `empmaster`.`id` = 283	283	NULL	AEH	E	34	000288	Mohammad raza	Insaf Ali	indian	muslim	2002-01-01	2023-02-28	0000-00-00	2	34	7	4	Married	0000-00-00	N/A	Male	1	2023-02-28		NULL		4000.00	0000-00-00	0000-00-00	NULL	NULL	NULL	NULL	Cheque	115	2023-02-28	3	A	optam	true	true	N	no	A	NULL	NULL	R	0
Edit	Copy	Delete DELETE FROM `empmaster` WHERE `empmaster`.`id` = 282	282	NULL	AEH	E	34	000287	Abhishek tiwari	shree v.d tiwri	indian	hindu	1990-07-18	2023-02-01	0000-00-00	30	34	7	74	Married	2015-02-14	N/A	Male	1	2023-02-06	B.Sc	NULL		4000.00	0000-00-00	0000-00-00	NULL	NULL	NULL	NULL	Cheque	115	2023-02-06	3	O+	MHA	true		N	yes	A	NULL	NULL	R	0

Check all With selected:

Query results operations

Print view

Export

Display chart

Create view