110.227.191.169:8080 / 127.0.0.1 / progretiontracker / operato

There are no favourite tables.

Customise appearance of the navigation panel.

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.
Favourite tables Maximum number of favourite tables; set 0 to disable.
Navigation panel width Set to 0 to collapse navigation panel.

Customise the navigation tree.

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
Expand single database Whether to expand single database in the navigation tree automatically.

Servers display options.

Servers

Display servers selection Display server choice at the top of the navigation panel.
Display servers as a list Show server listing as a list instead of a drop down.

Databases display options.

Databases

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

Tables display options.

Tables

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 -

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

Customise browse mode.

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 (195 total, Query took 0.0033 seconds.) [timestamp: 2025-05-05 13:36:49.669004... - 2025-04-29 10:21:56.817708...]

SELECT * FROM `operato` ORDER BY `timestamp` DESC

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

Filter rows:

			srno	cktid	operatorname	contact	sdeposite	city	mrc	otc	plan	psdate	pedate	ploginid	lpassword	excilationmatrix	paymentstatus	npdate	timestamp 1
Edit	Copy	Delete DELETE FROM operato WHERE `operato`.`srno` = 27	27	27201045928	CITY BB		452010	indore	4000	0	500mbps	28-09-2022	2023-05-05	local			Recharg	2025-05-06	2025-05-05 13:36:49.669004
Edit	Copy	Delete DELETE FROM operato WHERE `operato`.`srno` = 48	48	48601045117	Nexgen fiber/jio	9229259995	4000	ujjain	1770	3000	300mbps	11-07-2022	2023-04-04	1368110928			Recharg	2025-06-01	2025-05-05 13:11:25.255111
Edit	Copy	Delete DELETE FROM operato WHERE `operato`.`srno` = 214	214	20473410173	Wishnet bb	96796 27888	734101	darjeeling	699	1675	100 MBPS	2024-05-25	0000-00-00	482219_123456	123456			2025-06-03	2025-05-05 12:22:48.643686
Edit	Copy	Delete DELETE FROM operato WHERE `operato`.`srno` = 190	190	19440005676	Rail wire	70000 36605	494001	Jagdalpur	1180	4500	100mbps	2024-05-06	0000-00-00	cg.avc.ishtyaqa/ishtyaq123	NA			2025-06-04	2025-05-05 12:17:34.320629
Edit	Copy	Delete DELETE FROM operato WHERE `operato`.`srno` = 200	200	20450331024	Mauli bb	8871262727/95952 59533	450331	Burhanpur	850	3000	100mbps	2024-05-17	0000-00-00	NA	NA			2025-06-02	2025-05-05 12:13:13.657515
Edit	Copy	Delete DELETE FROM operato WHERE `operato`.`srno` = 21	21	159012760922	knet broadband	Rajendra pandit 7008163255	0	ROURKELA	1061	0	100mbps	15-09-2022	2023-04-15	vikashyadavrkl	password		Recharg	2025-06-03	2025-05-05 12:05:59.796919
Edit	Copy	Delete DELETE FROM operato WHERE `operato`.`srno` = 171	171	45500129584	GN COMPUTER vi	8989129292/ 9827190909	455	DEWAS	1100	4500	200 Mbps	2024-03-29	0000-00-00	fbroca_1-5	12345		closed	2025-06-03	2025-05-05 11:57:42.435783
Edit	Copy	Delete DELETE FROM operato WHERE `operato`.`srno` = 20	20	92102710921	Alliance broadband	rockey 8443005138	0	chinsurah	767	0	100mbps	09-09-2022	0000-00-00	17264158575				2025-06-05	2025-05-05 11:53:27.542790
Edit	Copy	Delete DELETE FROM operato WHERE `operato`.`srno` = 216	216	74007053123	Alliance bb	98303 88446/OFFICE NUMBER-03325294574/1	700074	kolkatta	354	200	100 Mbps	2024-05-31	0000-00-00	17503156984	hr60_abd/3496			2025-06-05	2025-05-05 11:49:29.697793
Edit	Copy	Delete DELETE FROM operato WHERE `operato`.`srno` = 162	162	80012211507	JIO BB	18008969999	800007	patna	824	0	100 Mbps	2023-12-21	0000-00-00	6123159299				2025-05-26	2025-05-05 11:40:32.082273
Edit	Copy	Delete DELETE FROM operato WHERE `operato`.`srno` = 166	166	15700552421	JIO BB	18008969999	700055	kolkata	699	0	100 Mbps	2024-02-21	0000-00-00	3335014720	NA			2025-05-26	2025-05-05 11:37:53.986587
Edit	Copy	Delete DELETE FROM operato WHERE `operato`.`srno` = 204	204	11208340012	JIO BB	18008969999	8340001	Ranchi	825	0	100 MBPS	2024-05-21	0000-00-00	6513194267	NA			2025-05-25	2025-05-05 11:35:41.691960
Edit	Copy	Delete DELETE FROM operato WHERE `operato`.`srno` = 209	209	27085430152	Wave	9934660868	854301	purnia	799	4300	100 MBPS	2024-05-24	0000-00-00	NA	NA			2025-05-24	2025-05-05 11:32:08.259948
Edit	Copy	Delete DELETE FROM operato WHERE `operato`.`srno` = 206	206	24085430105	One bb	9934660868	854301	purnia	699	0	100 MBPS	2024-05-23	0000-00-00	NA	NA			2025-05-24	2025-05-05 11:31:36.448545
Edit	Copy	Delete DELETE FROM operato WHERE `operato`.`srno` = 115	115	71078405223	ACN b.b	8866110329/ 7086688444	781007	Guwahati	1297	3000	100 mbps	2023-05-24	0000-00-00	local	NA		recharge	2025-06-01	2025-05-05 11:29:42.607124
Edit	Copy	Delete DELETE FROM operato WHERE `operato`.`srno` = 177	177	85621704206	DAYS COMMUNICATION	94358 70136	785621	Guwahati	1500	4700	100 mbps	2024-04-06	0000-00-00	NA	NA			2025-06-01	2025-05-05 11:26:45.282166
Edit	Copy	Delete DELETE FROM operato WHERE `operato`.`srno` = 178	178	1862HDFC508	Days Communication	9435870136	785621	Guwahati	1300	3800	100mbps	2024-04-08	0000-00-00	Na	NA			2025-06-01	2025-05-05 11:26:15.078931
Edit	Copy	Delete DELETE FROM operato WHERE `operato`.`srno` = 185	185	1082270530	days communication	9435870136	781022	Guwahati	1000	3000	100 Mbps	2024-04-30	0000-00-00	NA	NA			2025-06-01	2025-05-05 11:25:47.405032
Edit	Copy	Delete DELETE FROM operato WHERE `operato`.`srno` = 187	187	77480522412	acn bb	9435870136	781022	Guwahati	1300	3000	100mbps	2024-05-04	0000-00-00	NA	NA			2025-06-01	2025-05-05 11:25:20.803480
Edit	Copy	Delete DELETE FROM operato WHERE `operato`.`srno` = 147	147	1005PVR7802	soft crop it(utpal)	9435870136/ 8749822449	781005	Guwahati	1500	4500	100 Mbps	2023-11-02	0000-00-00	local	userid-ud_pvrcitycenter			2025-06-01	2025-05-05 11:24:19.366094
Edit	Copy	Delete DELETE FROM operato WHERE `operato`.`srno` = 93	93	50017928238	airtel	9233003956	795001	imphal	943	1	100mbps	2023-01-28	2023-04-28	038513766392	03854058757		recharge	2025-05-27	2025-05-05 11:16:35.955924
Edit	Copy	Delete DELETE FROM operato WHERE `operato`.`srno` = 186	186	10048052410	Airtel	121	481001	Balaghat	943	0	100 mbps	2024-05-02	0000-00-00	0763218558349_wifi	NA			2025-06-01	2025-05-05 11:12:53.151784
Edit	Copy	Delete DELETE FROM operato WHERE `operato`.`srno` = 227	227	17017000915	Alliance	84449 46188/18001200300	700091	Bidhannagar	2950	3540	100mbps	2025-01-17	0000-00-00	ABC6453474	123456			2025-05-31	2025-05-05 11:04:02.768760
Edit	Copy	Delete DELETE FROM operato WHERE `operato`.`srno` = 55	55	11100578156	M NET bb	9859920525/ 9859900333/ 7086030101/	781005	GUAHATI	1593	4660	100mbps	11-11-2022	2023-04-13	local	NA		Recharg	2025-05-10	2025-04-29 10:25:55.326845
Edit	Copy	Delete DELETE FROM operato WHERE `operato`.`srno` = 196	196	21105202434	GTPL	7001448792/ 9775040301	700104	KOLKATTA	760	3200	100 MBPS	2024-05-10	0000-00-00	NA	NA			2025-05-12	2025-04-29 10:21:56.817708

Check all With selected:

Filter rows:

Query results operations

Copy to clipboard

Export

Display chart

Create view