110.227.191.169:8080 / 127.0.0.1 / progretiontracker / porecord1

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 (382 total, Query took 0.0036 seconds.) [srno: 1384... - 1360...]

SELECT * FROM `porecord1` ORDER BY `srno` DESC

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

Filter rows:

			srno 1	po_id	cktid	pono	podate	validityinmonth	mrcvalue	otcvalue	gst	gstvalue	company	po_receive_date	invoiceno	inv_id	poimage	timestamp
Edit	Copy	Delete DELETE FROM porecord1 WHERE `porecord1`.`srno` = 1384	1384	6808aed8590a1	20007152587	SO/25-26/0364	2025-04-23	12	1800	0	3888	25488	IAHMA Technology	2025-04-23	IA/25-26/IN025	680c7dceea9f0		2025-04-26 12:01:42.967436
Edit	Copy	Delete DELETE FROM porecord1 WHERE `porecord1`.`srno` = 1383	1383	680724c4bfdaf	28015032024	SO/25-26/0282	2025-04-21	12	1600	0	3456	22656	arcad saolution and services	2025-04-21	AR/25-26/IN0035	680b178781535		2025-04-25 10:33:03.533012
Edit	Copy	Delete DELETE FROM porecord1 WHERE `porecord1`.`srno` = 1382	1382	680724504ed12	11705202470	SO/25-26/0275	2025-04-21	12	1600	0	3456	22656	arcad saolution and services	2025-04-21	AR/25-26/IN0024	6808c98474882		2025-04-23 16:35:40.482477
Edit	Copy	Delete DELETE FROM porecord1 WHERE `porecord1`.`srno` = 1381	1381	680723e27f965	1031085964	SO/25-26/0288	2025-04-21	12	1600	0	3456	22656	arcad saolution and services	2025-04-21	AR/25-26/IN0023	6808c56f4b534		2025-04-23 16:18:15.314094
Edit	Copy	Delete DELETE FROM porecord1 WHERE `porecord1`.`srno` = 1380	1380	6807239fd12b6	11722102205	SO/25-26/0289	2025-04-21	12	1600	0	3456	22656	arcad saolution and services	2025-04-21	AR/25-26/IN0025	6808d07e212b9		2025-04-23 17:05:26.141954
Edit	Copy	Delete DELETE FROM porecord1 WHERE `porecord1`.`srno` = 1379	1379	6807234c723bd	19009320514	SO/25-26/0250	2025-04-21	12	1600	0	3456	22656	arcad saolution and services	2025-04-21	AR/25-26/IN0028	6809cf5e9fced		2025-04-24 11:12:54.660268
Edit	Copy	Delete DELETE FROM porecord1 WHERE `porecord1`.`srno` = 1378	1378	680722f4bd341	71078405223	SO/25-26/0237	2025-04-21	12	1900	0	4104	26904	arcad saolution and services	2025-04-21	AR/25-26/IN0036	680b241655980		2025-04-25 11:26:38.357140
Edit	Copy	Delete DELETE FROM porecord1 WHERE `porecord1`.`srno` = 1377	1377	68072299af80b	21105202434	SO/25-26/0286	2025-04-21	12	1600	0	3456	22656	arcad saolution and services	2025-04-21	AR/25-26/IN0032	680b5aa97d614		2025-04-25 15:19:29.519397
Edit	Copy	Delete DELETE FROM porecord1 WHERE `porecord1`.`srno` = 1376	1376	6807223a64c71	27070016524	SO/25-26/0284	2025-04-21	12	1600	0	3456	22656	arcad saolution and services	2025-04-21	AR/25-26/IN0034	6809f4388bac2		2025-04-24 13:50:08.577996
Edit	Copy	Delete DELETE FROM porecord1 WHERE `porecord1`.`srno` = 1375	1375	680721d009e64	74007053123	SO/25-26/0285	2025-04-21	12	1600	0	3456	22656	arcad saolution and services	2025-04-21	AR/25-26/IN0037	680b295b4fac7		2025-04-25 11:49:07.331985
Edit	Copy	Delete DELETE FROM porecord1 WHERE `porecord1`.`srno` = 1374	1374	680720a19ab03	39270520242	SO/25-26/0280	2025-04-21	12	1600	0	3456	22656	arcad saolution and services	2025-04-21	AR/25-26/IN0022	6808bfce73041		2025-04-23 15:54:14.474551
Edit	Copy	Delete DELETE FROM porecord1 WHERE `porecord1`.`srno` = 1373	1373	68071def944cd	12108052024	SO/25-26/0281	2025-04-21	12	1600	0	3456	22656	arcad saolution and services	2025-04-21	AR/25-26/IN0026	6809c40311fcd		2025-04-24 10:24:27.079706
Edit	Copy	Delete DELETE FROM porecord1 WHERE `porecord1`.`srno` = 1372	1372	68071d6596810	20539000724	SO/25-26/0279	2025-04-21	12	1600	0	3456	22656	arcad saolution and services	2025-04-21	AR/25-26/IN0031	6809e573afdc9		2025-04-24 12:47:07.725469
Edit	Copy	Delete DELETE FROM porecord1 WHERE `porecord1`.`srno` = 1371	1371	68071d074cc8c	12834001234	SO/25-26/0276	2025-04-21	12	1600	0	3456	22656	arcad saolution and services	2025-04-21	AR/25-26/IN0027	6809c8e243c34		2025-04-24 10:45:14.283039
Edit	Copy	Delete DELETE FROM porecord1 WHERE `porecord1`.`srno` = 1370	1370	68071cabe442a	20473410173	SO/25-26/0287	2025-04-21	12	1600	0	3456	22656	arcad saolution and services	2025-04-21	AR/25-26/IN0030	6809e1b9e3965		2025-04-24 12:31:13.937776
Edit	Copy	Delete DELETE FROM porecord1 WHERE `porecord1`.`srno` = 1369	1369	68067b1503be7	20244921015	SO/25-26/0267	2025-04-21	12	1600	0	3456	22656	arcad saolution and services	2025-04-21	AR/25-26/IN0029	6809dbc8171bb		2025-04-24 12:05:52.100117
Edit	Copy	Delete DELETE FROM porecord1 WHERE `porecord1`.`srno` = 1368	1368		24085430105	SO/25-26/0283	2025-04-21	12	1600	0	3456	22656	arcad saolution and services	2025-04-21	AR/25-26/IN0033	6809ef66a5123		2025-04-24 13:29:34.681618
Edit	Copy	Delete DELETE FROM porecord1 WHERE `porecord1`.`srno` = 1367	1367		62030382703	SO/25-26/0265	2025-04-21	12	2550	0	5508	36108	IAHMA Technology	2025-04-21	IA/25-26/IN024	680c7a43d8406		2025-04-26 11:46:35.892623
Edit	Copy	Delete DELETE FROM porecord1 WHERE `porecord1`.`srno` = 1366	1366		18001104051	SO/25-26/0261	2025-04-21	12	1600	0	3456	22656	IAHMA Technology	2025-04-21	IA/25-26/IN023	680c778515f4a		2025-04-26 11:34:53.096443
Edit	Copy	Delete DELETE FROM porecord1 WHERE `porecord1`.`srno` = 1365	1365		27085430152	SO/25-26/0255	2025-04-21	12	1600	0	3456	22656	IAHMA Technology	2025-04-21	IA/25-26/IN022	680c7551f384e		2025-04-26 11:25:30.004605
Edit	Copy	Delete DELETE FROM porecord1 WHERE `porecord1`.`srno` = 1364	1364		28080150324	SO/25-26/0254	2025-04-21	12	1600	0	3456	22656	IAHMA Technology	2025-04-21	IA/25-26/IN021	680c7057621e9		2025-04-26 11:04:15.408086
Edit	Copy	Delete DELETE FROM porecord1 WHERE `porecord1`.`srno` = 1363	1363		13806085420	SO/25-26/0253	2025-04-21	12	1600	0	3456	22656	IAHMA Technology	2025-04-21	IA/25-26/IN020	680c6ca26d8dc		2025-04-26 10:48:26.455345
Edit	Copy	Delete DELETE FROM porecord1 WHERE `porecord1`.`srno` = 1362	1362		50390025231	SO/25-26/0252	2025-04-21	12	1600	0	3456	22656	IAHMA Technology	2025-04-21	IA/25-26/IN019	680c68e7072d6		2025-04-26 10:32:31.035544
Edit	Copy	Delete DELETE FROM porecord1 WHERE `porecord1`.`srno` = 1361	1361		13902705112	SO/25-26/0251	2025-04-21	12	1600	0	3456	22656	IAHMA Technology	2025-04-21	IA/25-26/IN018	680c656943496		2025-04-26 10:17:37.283460
Edit	Copy	Delete DELETE FROM porecord1 WHERE `porecord1`.`srno` = 1360	1360		12090019524	SO/25-26/0298	2025-04-21	12	1600	0	3456	22656	IAHMA Technology	2025-04-21	IA/25-26/IN017	680b6c0426301		2025-04-25 16:33:32.161780

Check all With selected:

Filter rows:

Query results operations

Copy to clipboard

Export

Display chart

Create view