110.227.191.169:8080 / 127.0.0.1 / progretiontracker / porenew

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

SELECT * FROM `porenew`

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

Filter rows:

			srno	cktid	po_id	idate_old	idate_new	pono_old	pono_new	timestamp
Edit	Copy	Delete DELETE FROM porenew WHERE `porenew`.`srno` = 1	1	15710156776_B		2022-07-23	2023-07-23	SO/22-23/1960	SO/23-24/1932	2023-08-24 11:38:46.185230
Edit	Copy	Delete DELETE FROM porenew WHERE `porenew`.`srno` = 2	2	291313710815		2022-07-27	2023-07-27	SO/22-23/2461	SO/23-24/2757	0000-00-00 00:00:00.000000
Edit	Copy	Delete DELETE FROM porenew WHERE `porenew`.`srno` = 3	3	235123800816		2022-08-23	2023-08-23	SO/22-23/2454	SO/23-24/2732	0000-00-00 00:00:00.000000
Edit	Copy	Delete DELETE FROM porenew WHERE `porenew`.`srno` = 4	4	20069700917		2022-09-02	2023-09-02	SO/22-23/2738	SO/23-24/2774	0000-00-00 00:00:00.000000
Edit	Copy	Delete DELETE FROM porenew WHERE `porenew`.`srno` = 5	5	15710156776_C		2022-07-23	2023-07-23	SO/22-23/2166	SO/23-24/2723	2023-08-24 14:47:53.759756
Edit	Copy	Delete DELETE FROM porenew WHERE `porenew`.`srno` = 6	6	15710156776		2022-06-06	2023-06-06	SO/22-23/1492	SO/23-24/1537	0000-00-00 00:00:00.000000
Edit	Copy	Delete DELETE FROM porenew WHERE `porenew`.`srno` = 7	7	INDI1000014892		2022-06-28	2023-06-28	SO/22-23/1600	SO/23-24/1565	0000-00-00 00:00:00.000000
Edit	Copy	Delete DELETE FROM porenew WHERE `porenew`.`srno` = 8	8	13009170080010		2022-08-13	2023-08-13	SO/22-23/2060	SO/23-24/1933	0000-00-00 00:00:00.000000
Edit	Copy	Delete DELETE FROM porenew WHERE `porenew`.`srno` = 9	9	15710156776_A		2022-07-29	2023-07-29	SO/22-23/1954	SO/23-24/1929	0000-00-00 00:00:00.000000
Edit	Copy	Delete DELETE FROM porenew WHERE `porenew`.`srno` = 10	10	1732167108009		2022-08-15	2023-08-15	SO/22-23/1956	SO/23-24/1930	0000-00-00 00:00:00.000000
Edit	Copy	Delete DELETE FROM porenew WHERE `porenew`.`srno` = 11	11	15407031022		2022-07-27	2023-07-27	SO/22-23/1958	SO/23-24/1931	0000-00-00 00:00:00.000000
Edit	Copy	Delete DELETE FROM porenew WHERE `porenew`.`srno` = 12	12	12509		2022-06-30	2023-06-30	SO/22-23/1598	SO/23-24/1562	0000-00-00 00:00:00.000000
Edit	Copy	Delete DELETE FROM porenew WHERE `porenew`.`srno` = 15	15	16001820813		2022-08-31	2023-08-31	SO/22-23/2202	SO/23-24/2725	2023-08-28 19:24:03.363951
Edit	Copy	Delete DELETE FROM porenew WHERE `porenew`.`srno` = 16	16	27201045928		2022-09-28	2023-09-28	SO/22-23/2710	SO/23-24/2769	2023-08-28 19:38:34.374571
Edit	Copy	Delete DELETE FROM porenew WHERE `porenew`.`srno` = 17	17	92102710921		2022-09-09	2023-09-09	SO/22-23/2874	SO/23-24/3364	2023-09-02 14:35:23.431526
Edit	Copy	Delete DELETE FROM porenew WHERE `porenew`.`srno` = 18	18	91007750920		2022-09-09	2023-09-09	SO/22-23/2849	SO/23-24/3289	2023-09-02 14:47:13.350156
Edit	Copy	Delete DELETE FROM porenew WHERE `porenew`.`srno` = 19	19	81001830918		2022-09-08	2023-09-08	SO/22-23/2856	SO/23-24/3290	2023-09-02 14:49:27.349673
Edit	Copy	Delete DELETE FROM porenew WHERE `porenew`.`srno` = 20	20	159012760922		2022-09-15	2023-09-15	SO/22-23/2890	SO/23-24/3304	2023-09-02 14:52:05.001655
Edit	Copy	Delete DELETE FROM porenew WHERE `porenew`.`srno` = 21	21	196010450924		2022-09-19	2023-09-19	SO/22-23/2995	SO/23-24/3330	2023-09-02 14:54:16.624909
Edit	Copy	Delete DELETE FROM porenew WHERE `porenew`.`srno` = 22	22	29101778930		2022-09-28	2023-09-28	SO/22-23/3174	SO/23-24/3343	2023-09-02 14:58:08.282306
Edit	Copy	Delete DELETE FROM porenew WHERE `porenew`.`srno` = 23	23	24000170631		2022-09-27	2023-09-27	SO/22-23/2863	SO/23-24/3363	2023-12-19 16:18:32.582435
Edit	Copy	Delete DELETE FROM porenew WHERE `porenew`.`srno` = 24	24	93017112269		2023-12-09	2023-10-31	SO/22-23/3297	SO/23-24/3727	2023-10-05 11:28:56.000001
Edit	Copy	Delete DELETE FROM porenew WHERE `porenew`.`srno` = 25	25	17402471040		2022-10-15	2023-10-15	SO/22-23/3403	SO/23-24/3744	2023-10-05 11:38:55.179232
Edit	Copy	Delete DELETE FROM porenew WHERE `porenew`.`srno` = 26	26	19211461042		2022-10-18	2023-10-18	SO/22-23/3397	SO/23-24/3741	2023-10-05 11:42:18.090779
Edit	Copy	Delete DELETE FROM porenew WHERE `porenew`.`srno` = 27	27	142001481038		2022-10-14	2023-10-14	SO/22-23/3395	SO/23-24/3740	2023-10-05 11:46:20.964910

Check all With selected:

Filter rows:

Query results operations

Copy to clipboard

Export

Display chart

Create view