110.227.191.169:8080 / 127.0.0.1 / progretiontracker / paymentreceive

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 (657 total, Query took 0.0015 seconds.) [srno: 658... - 634...]

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

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

Filter rows:

			srno 1	cktid	invoiceno	payment_receive	gst_receive	total_receive	tdsdeduction	balanceamount	receivingdate	pono	timestamp
Edit	Copy	Delete DELETE FROM paymentreceive WHERE `paymentreceive`.`srno` = 658	658	19009320514	AR/25-26/IN0028	4752	864	5616	48	0	2025-05-02	SO/25-26/0250	2025-05-05 15:58:23.709755
Edit	Copy	Delete DELETE FROM paymentreceive WHERE `paymentreceive`.`srno` = 657	657	12108052024	AR/25-26/IN0026	4752	864	5616	48	0	2025-05-02	SO/25-26/0281	2025-05-05 15:57:38.230813
Edit	Copy	Delete DELETE FROM paymentreceive WHERE `paymentreceive`.`srno` = 656	656	11722102205	AR/25-26/IN0025	4752	864	5616	48	0	2025-05-02	SO/25-26/0289	2025-05-05 15:56:56.333627
Edit	Copy	Delete DELETE FROM paymentreceive WHERE `paymentreceive`.`srno` = 655	655	11705202470	AR/25-26/IN0024	4752	864	5616	48	0	2025-05-02	SO/25-26/0275	2025-05-05 15:56:01.815269
Edit	Copy	Delete DELETE FROM paymentreceive WHERE `paymentreceive`.`srno` = 654	654	39270520242	AR/25-26/IN0022	4752	864	5616	48	0	2025-05-02	SO/25-26/0280	2025-05-05 15:54:57.029889
Edit	Copy	Delete DELETE FROM paymentreceive WHERE `paymentreceive`.`srno` = 653	653	81001830918	AR/25-26/IN0039	5643	1026	6669	57	0	2025-05-02	SO/24-25/4230	2025-05-05 15:54:18.539761
Edit	Copy	Delete DELETE FROM paymentreceive WHERE `paymentreceive`.`srno` = 652	652	20244921015	AR/25-26/IN0029	4752	864	5616	48	0	2025-05-02	SO/25-26/0267	2025-05-05 15:53:07.473590
Edit	Copy	Delete DELETE FROM paymentreceive WHERE `paymentreceive`.`srno` = 651	651	71078405223	AR/25-26/IN0036	5643	1026	6669	57	0	2025-05-02	SO/25-26/0237	2025-05-05 15:52:30.853388
Edit	Copy	Delete DELETE FROM paymentreceive WHERE `paymentreceive`.`srno` = 650	650	74007053123	AR/25-26/IN0037	4752	864	5616	48	0	2025-05-02	SO/25-26/0285	2025-05-05 15:51:47.584883
Edit	Copy	Delete DELETE FROM paymentreceive WHERE `paymentreceive`.`srno` = 649	649	28015032024	AR/25-26/IN0035	4752	864	5616	48	0	2025-05-02	SO/25-26/0282	2025-05-05 15:51:11.287518
Edit	Copy	Delete DELETE FROM paymentreceive WHERE `paymentreceive`.`srno` = 648	648	24085430105	AR/25-26/IN0033	4752	864	5616	48	0	2025-05-02	SO/25-26/0283	2025-05-05 15:50:30.586277
Edit	Copy	Delete DELETE FROM paymentreceive WHERE `paymentreceive`.`srno` = 647	647	27070016524	AR/25-26/IN0034	4752	864	5616	48	0	2025-05-02	SO/25-26/0284	2025-05-05 15:49:38.109341
Edit	Copy	Delete DELETE FROM paymentreceive WHERE `paymentreceive`.`srno` = 646	646	20539000724	AR/25-26/IN0031	4752	864	5616	48	0	2025-05-02	SO/25-26/0279	2025-05-05 15:48:34.906917
Edit	Copy	Delete DELETE FROM paymentreceive WHERE `paymentreceive`.`srno` = 645	645	21105202434	AR/25-26/IN0032	4752	864	5616	48	0	2025-05-02	SO/25-26/0286	2025-05-05 15:47:38.561236
Edit	Copy	Delete DELETE FROM paymentreceive WHERE `paymentreceive`.`srno` = 644	644	20473410173	AR/25-26/IN0030	4752	864	5616	48	0	2025-05-02	SO/25-26/0287	2025-05-05 15:41:07.247061
Edit	Copy	Delete DELETE FROM paymentreceive WHERE `paymentreceive`.`srno` = 643	643	12834001234	AR/25-26/IN0027	4752	864	5616	48	0	2025-05-02	SO/25-26/0276	2025-05-05 15:39:57.265708
Edit	Copy	Delete DELETE FROM paymentreceive WHERE `paymentreceive`.`srno` = 642	642	1740018360	AR/25-26/IN0017	4602	837	5439	48	0	2025-05-02	SO/24-25/3136	2025-05-05 15:39:02.890678
Edit	Copy	Delete DELETE FROM paymentreceive WHERE `paymentreceive`.`srno` = 641	641	60104511531	IA/25-26/IN011	7722	1404	9126	78	0	2025-05-02	SO/24-25/3068	2025-05-04 13:11:13.085371
Edit	Copy	Delete DELETE FROM paymentreceive WHERE `paymentreceive`.`srno` = 640	640	12005938158	IA/25-26/IN014	7722	1404	9126	78	0	2025-05-02	SO/24-25/3067	2025-05-04 13:10:17.441666
Edit	Copy	Delete DELETE FROM paymentreceive WHERE `paymentreceive`.`srno` = 639	639	22480381157	IA/25-26/IN013	5643	1026	6669	57	0	2025-05-02	SO/24-25/3065	2025-05-04 13:09:26.459331
Edit	Copy	Delete DELETE FROM paymentreceive WHERE `paymentreceive`.`srno` = 638	638	20450331024	IA/25-26/IN015	4752	864	5616	48	0	2025-05-02	SO/25-26/0246	2025-05-04 13:08:10.182880
Edit	Copy	Delete DELETE FROM paymentreceive WHERE `paymentreceive`.`srno` = 637	637	40018328052	IA/25-26/IN012	4752	864	5616	48	0	2025-05-02	SO/24-25/3063	2025-05-04 13:07:27.906402
Edit	Copy	Delete DELETE FROM paymentreceive WHERE `paymentreceive`.`srno` = 636	636	11208340012	IA/25-26/IN016	4752	864	5616	48	0	2025-05-02	SO/25-26/0247	2025-05-04 13:06:38.382912
Edit	Copy	Delete DELETE FROM paymentreceive WHERE `paymentreceive`.`srno` = 635	635	12090019524	IA/25-26/IN017	4752	864	5616	48	0	2025-05-02	SO/25-26/0298	2025-05-04 13:05:50.978703
Edit	Copy	Delete DELETE FROM paymentreceive WHERE `paymentreceive`.`srno` = 634	634	50390025231	IA/25-26/IN019	4752	864	5616	48	0	2025-05-02	SO/25-26/0252	2025-05-04 13:05:01.984862

Check all With selected:

Filter rows:

Query results operations

Copy to clipboard

Export

Display chart

Create view