competence-rs.com / localhost / herp / www_users

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: www_users

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 (181 total, Query took 0.0016 seconds.)

SELECT * FROM `www_users`

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

			id	userid	password	companyid	mst_site	mst_dpt_heirarchy	department	designation	rolepid	realname	assigned_sites	phone	email	parentid	fullaccess	lastvisitdate	pagesize	modulesallowed	theme	language	Type	dashboard_assign	dealer	empid	vendorid	hmis_userid	hmis_storeid
Edit	Copy	Delete DELETE FROM `www_users` WHERE `www_users`.`userid` = \'\'	128		b2e45ee9b158d2add246f4366c57c81b	3	NULL	NULL	NULL	NULL	1		3,4,5,6			NULL	8	2020-12-03 12:34:40	A4	1,1,1,1,1,1,1,1	professional	en_GB	user	5	NULL	NULL	NULL	146	NULL
Edit	Copy	Delete DELETE FROM `www_users` WHERE `www_users`.`userid` = \'Abhishek Kumar Tiwari\'	89	Abhishek Kumar Tiwari	40bd001563085fc35165329ea1ff5c5ecbdbbeef	3	AEH	0	2	4	2	Abhishek Kumar Tiwari				0	8	2020-10-02 07:08:32	A4	1,1,1,1,1,1,1,1	professional	en_US	user	5	NULL	181	NULL	104	NULL
Edit	Copy	Delete DELETE FROM `www_users` WHERE `www_users`.`userid` = \'Abhishek tiwari\'	166	Abhishek tiwari	802df43ad0487ea440724d5d0c62378caed12152	3	AEH,APH,VCT	0	1	3	14	Abhishek tiwari				0	8	2023-09-07 05:29:41	A4	1,1,1,1,1,1,1,1	professional	en_US	user	5	NULL	0	NULL	185	1
Edit	Copy	Delete DELETE FROM `www_users` WHERE `www_users`.`userid` = \'abhishek upadhyay\'	146	abhishek upadhyay	dcddb75469b4b4875094e14561e573d8	3	AEH	0	1	1	2	abhishek upadhyay		09415715484	6499abhishek@gmail.com	0	8	2023-02-09 04:33:08	A4	1,1,1,1,1,1,1,1	professional	en_US	user	5	NULL	267	NULL	165	NULL
Edit	Copy	Delete DELETE FROM `www_users` WHERE `www_users`.`userid` = \'Adarsh Srivastava\'	105	Adarsh Srivastava	a66215ac658080983916953b2896b080	3	AHB	0	7	21	2	Adarsh Srivastava				0	8	2019-03-28 06:28:29	A4	1,1,1,1,1,1,1,1	professional	en_US	user	5	NULL	193	NULL	120	NULL
Edit	Copy	Delete DELETE FROM `www_users` WHERE `www_users`.`userid` = \'Admin\'	1	Admin	7c4a8d09ca3762af61e59520943dc26494f8941b	3	AEH,AEHB,AEHK,AHB,APH,MM,OPT,VCK,VCT	0	2	5	12	Admin				0	8	2024-07-29 11:47:13	A4	1,1,1,1,1,1,1,1	professional	en_US	SuperAdmin	1	NULL	0	0	1	4
Edit	Copy	Delete DELETE FROM `www_users` WHERE `www_users`.`userid` = \'Ajay Deogan\'	102	Ajay Deogan	4063950836e5ddc9f88311e5dabfba26455a2b03	3		0	2	4	2	Ajay Deogan				0	8	2019-01-11 13:28:54	A4	1,1,1,1,1,1,1,1	professional	en_US	user	5	NULL	187	NULL	117	NULL
Edit	Copy	Delete DELETE FROM `www_users` WHERE `www_users`.`userid` = \'Akhilesh Kumar Mishra\'	65	Akhilesh Kumar Mishra	7c4a8d09ca3762af61e59520943dc26494f8941b	3	AEH	0	1	1	2	Akhilesh Kumar Mishra				0	8	2017-12-02 14:37:04	A4	1,1,1,1,1,1,1,1	professional	en_US	user	5	NULL	0	NULL	79	NULL
Edit	Copy	Delete DELETE FROM `www_users` WHERE `www_users`.`userid` = \'Amarnath gupta\'	169	Amarnath gupta	8aa861b40b7317fa9985bae1ba94a4fb	3	NULL	NULL	2	4	1	Amarnath gupta	3,4,5,6			NULL	8	2023-08-11 16:40:19	A4	1,1,1,1,1,1,1,1	professional	en_GB	user	5	NULL	290	NULL	188	NULL
Edit	Copy	Delete DELETE FROM `www_users` WHERE `www_users`.`userid` = \'amit Kumar\'	92	amit Kumar	e10adc3949ba59abbe56e057f20f883e	3	AEH	0	2	4	2	amit Kumar				0	8	2019-04-29 05:58:20	A4	1,1,1,1,1,1,1,1	professional	en_US	user	5	NULL	179	NULL	107	NULL
Edit	Copy	Delete DELETE FROM `www_users` WHERE `www_users`.`userid` = \'amit kumar verma\'	125	amit kumar verma	827ccb0eea8a706c4c34a16891f84e7b	3	AHB	0	18	50	16	amit kumar verma				0	8	2022-05-07 10:29:54	A4	1,1,1,1,1,1,1,1	professional	en_US	user	5	NULL	240	NULL	143	8
Edit	Copy	Delete DELETE FROM `www_users` WHERE `www_users`.`userid` = \'Amit Mishra\'	9	Amit Mishra	d13e0d356837e82638bfaa5005f8502c	3	APH	0	10	27	7	Amit Mishra				0	8	2024-07-29 06:51:40	A4	1,1,1,1,1,1,1,1	professional	en_US	user	5	NULL	14	0	23	2
Edit	Copy	Delete DELETE FROM `www_users` WHERE `www_users`.`userid` = \'Amit Pandey\'	64	Amit Pandey	e10adc3949ba59abbe56e057f20f883e	3	AEH	NULL	25	73	1	Amit Pandey	3,4,5,6			NULL	8	2018-03-30 14:07:24	A4	1,1,1,1,1,1,1,1	professional	en_GB	user	5	NULL	77	NULL	78	NULL
Edit	Copy	Delete DELETE FROM `www_users` WHERE `www_users`.`userid` = \'ANAMIKA SRIVASTAVA\'	135	ANAMIKA SRIVASTAVA	e10adc3949ba59abbe56e057f20f883e	3	AHB	0	1	1	2	ANAMIKA SRIVASTAVA				0	8	2023-06-23 12:15:15	A4	1,1,1,1,1,1,1,1	professional	en_US	user	5	NULL	254	NULL	153	NULL
Edit	Copy	Delete DELETE FROM `www_users` WHERE `www_users`.`userid` = \'Anand Upadhyay\'	18	Anand Upadhyay	e10adc3949ba59abbe56e057f20f883e	3	AEH	0	2	4	2	Anand Upadhyay				0	8	2022-03-15 04:12:24	A4	1,1,1,1,1,1,1,1	professional	en_US	user	5	NULL	49	0	32	NULL
Edit	Copy	Delete DELETE FROM `www_users` WHERE `www_users`.`userid` = \'anant prakash pandey\'	93	anant prakash pandey	7c4a8d09ca3762af61e59520943dc26494f8941b	3		0	15	41	2	anant prakash pandey				0	8	2018-09-17 12:37:48	A4	1,1,1,1,1,1,1,1	professional	en_US	user	5	NULL	89	NULL	108	NULL
Edit	Copy	Delete DELETE FROM `www_users` WHERE `www_users`.`userid` = \'anil kumar yadav\'	126	anil kumar yadav	a9b2318658f46376b511b0f6262fa38be184c880	3	AEHB	0	10	29	7	anil kumar yadav				0	8	2022-08-23 14:24:04	A4	1,1,1,1,1,1,1,1	professional	en_US	user	5	NULL	241	NULL	144	4
Edit	Copy	Delete DELETE FROM `www_users` WHERE `www_users`.`userid` = \'Anil Shrivastav\'	51	Anil Shrivastav	a2af486ce7125f6a0ee4524f435cb5e8	3	AHB	0	9	26	7	Anil Shrivastav				0	8	2024-04-10 11:44:00	A4	1,1,1,1,1,1,1,1	professional	en_US	user	5	NULL	147	0	65	8
Edit	Copy	Delete DELETE FROM `www_users` WHERE `www_users`.`userid` = \'Anita Pandey\'	75	Anita Pandey	7c4a8d09ca3762af61e59520943dc26494f8941b	3		0	5	14	2	Anita Pandey				0	8	2018-03-06 16:42:02	A4	1,1,1,1,1,1,1,1	professional	en_US	user	5	NULL	61	NULL	89	NULL
Edit	Copy	Delete DELETE FROM `www_users` WHERE `www_users`.`userid` = \'Anju Maurya\'	175	Anju Maurya	b2e45ee9b158d2add246f4366c57c81b	3	AEH	NULL	2	4	1	Anju Maurya	3,4,5,6			NULL	8	2024-01-02 11:51:31	A4	1,1,1,1,1,1,1,1	professional	en_GB	user	5	NULL	299	NULL	198	NULL
Edit	Copy	Delete DELETE FROM `www_users` WHERE `www_users`.`userid` = \'Ankur Tripathi\'	72	Ankur Tripathi	7c4a8d09ca3762af61e59520943dc26494f8941b	3	AEH	0	2	4	2	Ankur Tripathi				0	8	2018-04-05 08:55:01	A4	1,1,1,1,1,1,1,1	professional	en_US	user	5	NULL	0	NULL	86	NULL
Edit	Copy	Delete DELETE FROM `www_users` WHERE `www_users`.`userid` = \'Annu Dubey\'	59	Annu Dubey	7c4a8d09ca3762af61e59520943dc26494f8941b	3	AEHK	0	10	27	7	Annu Dubey				0	8	2020-01-25 12:25:50	A4	1,1,1,1,1,1,1,1	professional	en_US	user	5	NULL	0	0	73	5
Edit	Copy	Delete DELETE FROM `www_users` WHERE `www_users`.`userid` = \'ANOOP YADAV\'	143	ANOOP YADAV	8cb2237d0679ca88db6464eac60da96345513964	3		0	6	17	1	ANOOP YADAV				0	8	2023-07-22 06:41:51	A4	1,1,1,1,1,1,1,1	professional	en_US	user	5	NULL	263	NULL	161	NULL
Edit	Copy	Delete DELETE FROM `www_users` WHERE `www_users`.`userid` = \'Anshu Tripathi\'	37	Anshu Tripathi	7c4a8d09ca3762af61e59520943dc26494f8941b	3	AEH	0	2	4	2	Anshu Tripathi				0	8	2019-05-14 09:00:21	A4	1,1,1,1,1,1,1,1	professional	en_US	user	5	NULL	47	0	51	NULL
Edit	Copy	Delete DELETE FROM `www_users` WHERE `www_users`.`userid` = \'Ansuvi Singh\'	141	Ansuvi Singh	b2e45ee9b158d2add246f4366c57c81b	3	AEH	0	2	4	2	Ansuvi Singh				0	8	2022-01-22 09:43:15	A4	1,1,1,1,1,1,1,1	professional	en_US	user	5	NULL	261	NULL	159	NULL

Check all With selected:

Query results operations

Print view

Export

Display chart

Create view