101.50.88.246:8021 / 127.0.0.1 / cafe / tbl_purchases

`mysql`.`user`
`chief`.`page_permissions`
`mysql`.`db`
`information_schema`.`SCHEMATA`
`information_schema`.`CHARACTER_SETS`
`performance_schema`.`events_waits_history_long`
`information_schema`.`COLLATIONS`
`warehouse`.`tmp_warehousepurchaserclosing`
`information_schema`.`INNODB_TABLESPACES_ENCRYPTION`
`cafelahore`.`tbl_services_calculations`
`warehouselhr`.`warehousesupplierscategories`
`information_schema`.`TABLE_PRIVILEGES`
`warehouse`.`warehousepurchaserclosing`
`information_schema`.`TABLESPACES`
`information_schema`.`KEY_COLUMN_USAGE`
`warehouse`.`warehousesuppliers`
`warehouse`.`tmp_warehousestockout`
`chief`.`warehouseproducts`
`cafe`.`tbl_section_sale`
`assetslhr`.`tbl_admin`
`cafelahore`.`tbl_stock_dairy`
`mysql`.`help_relation`
`cafe`.`tbl_cus_payments`
`chief`.`warehousepurchaserclosing`
`mysql`.`servers`
 `mysql`.`time_zone_transition`
 `mysql`.`help_topic`
 `mysql`.`help_relation`
 `mysql`.`global_priv`
 `mysql`.`db`
 `mysql`.`roles_mapping`

  
New
cm9vdA==.YXNzZXRzcm9vdA==.YXNzZXRz0
assets
cm9vdA==.YXNzZXRzbGhycm9vdA==.YXNzZXRzbGhy0
assetslhr
cm9vdA==.YmlzdHJvcm9vdA==.YmlzdHJv0
bistro
cm9vdA==.Y2FmZQ==cm9vdA==.Y2FmZQ==0
cafe
cm9vdA==.Y2FmZWxhaG9yZQ==cm9vdA==.Y2FmZWxhaG9yZQ==0
cafelahore
cm9vdA==.Y2hpZWY=cm9vdA==.Y2hpZWY=0
chief
cm9vdA==.ZG9jcm9vdA==.ZG9j0
doc
cm9vdA==.Z3Vscm9vdA==.Z3Vs0
gul
cm9vdA==.aW5mb3JtYXRpb25fc2NoZW1hcm9vdA==.aW5mb3JtYXRpb25fc2NoZW1h0
information_schema
cm9vdA==.bGFob29ycm9vdA==.bGFob29y0
lahoor
cm9vdA==.bXlzcWw=cm9vdA==.bXlzcWw=0
mysql
cm9vdA==.b2xkcm9vdA==.b2xk0
old
cm9vdA==.cGVyZm9ybWFuY2Vfc2NoZW1hcm9vdA==.cGVyZm9ybWFuY2Vfc2NoZW1h0
performance_schema
cm9vdA==.cGhwbXlhZG1pbg==cm9vdA==.cGhwbXlhZG1pbg==0
phpmyadmin
cm9vdA==.cml2ZXJ2aWV3Y2FyZA==cm9vdA==.cml2ZXJ2aWV3Y2FyZA==0
riverviewcard
cm9vdA==.dGVzdA==cm9vdA==.dGVzdA==0
test
cm9vdA==.dW1lcg==cm9vdA==.dW1lcg==0
umer
cm9vdA==.d2FyZWhvdXNlcm9vdA==.d2FyZWhvdXNl0
warehouse
cm9vdA==.d2FyZWhvdXNlbGhycm9vdA==.d2FyZWhvdXNlbGhy0
warehouselhr

Navigation panel
Navigation tree
Servers
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 panel width Set to 0 to collapse navigation panel.

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

Servers

Servers display options.

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

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: 127.0.0.1 »

Database: cafe »

Table: tbl_purchases

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 (11796 total, Query took 0.0028 seconds.) [post_date: 2025-12-31... - 2025-03-15...]

SELECT * FROM `tbl_purchases` ORDER BY `post_date` DESC

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

Filter rows:

			id_no	id	hash	supplier_id	cr	dr	details	transport	type	post_date 1	post_time	status	Method	PaidBy	last_updated
Edit	Copy	Delete DELETE FROM `tbl_purchases` WHERE `tbl_purchases`.`id_no` = 10274	10274	10273	605ff764c617d3cd28dbbdd72be8f9a2	14	123426	123416	10273	127	Pending	2025-12-31	07:00:10	1	From Restaurant Bank	From Restaurant Bank
Edit	Copy	Delete DELETE FROM `tbl_purchases` WHERE `tbl_purchases`.`id_no` = 10273	10273	10272	0584ce565c824b7b7f50282d9a19945b	6	3100	3090	10272	0	Pending	2025-12-31	06:53:21	1	From Restaurant Bank	From Restaurant Bank
Edit	Copy	Delete DELETE FROM `tbl_purchases` WHERE `tbl_purchases`.`id_no` = 10275	10275	10274	3988c7f88ebcb58c6ce932b957b6f332	19	42510	42500	10274	0	Pending	2025-12-06	07:35:21	1	From Restaurant Bank	From Restaurant Bank
Edit	Copy	Delete DELETE FROM `tbl_purchases` WHERE `tbl_purchases`.`id_no` = 11798	11798	11797	8c19f571e251e61cb8dd3612f26d5ecf	17	18008	0	11797	0	Pending	2025-03-16	08:31:19	1		Pending
Edit	Copy	Delete DELETE FROM `tbl_purchases` WHERE `tbl_purchases`.`id_no` = 11797	11797	11796	da8ce53cf0240070ce6c69c48cd588ee	37	3960	0	11796	0	Pending	2025-03-16	08:29:33	1		Pending
Edit	Copy	Delete DELETE FROM `tbl_purchases` WHERE `tbl_purchases`.`id_no` = 11796	11796	11795	f9028faec74be6ec9b852b0a542e2f39	80	5920	0	11795	0	Pending	2025-03-16	08:29:03	1		Pending
Edit	Copy	Delete DELETE FROM `tbl_purchases` WHERE `tbl_purchases`.`id_no` = 11795	11795	11794	d2ed45a52bc0edfa11c2064e9edee8bf	9	64080	0	11794	0	Pending	2025-03-16	08:26:38	1		Pending
Edit	Copy	Delete DELETE FROM `tbl_purchases` WHERE `tbl_purchases`.`id_no` = 11794	11794	11793	a1140a3d0df1c81e24ae954d935e8926	3	35400	0	11793	0	Pending	2025-03-16	08:23:08	1		Pending
Edit	Copy	Delete DELETE FROM `tbl_purchases` WHERE `tbl_purchases`.`id_no` = 11793	11793	11792	f899139df5e1059396431415e770c6dd	28	5430	5430	11792	0	Paid	2025-03-16	08:22:34	1		From Restaurant Cash
Edit	Copy	Delete DELETE FROM `tbl_purchases` WHERE `tbl_purchases`.`id_no` = 11792	11792	11791	e46de7e1bcaaced9a54f1e9d0d2f800d	89	4624	4624	11791	0	Paid	2025-03-16	08:22:02	1		From Restaurant Cash
Edit	Copy	Delete DELETE FROM `tbl_purchases` WHERE `tbl_purchases`.`id_no` = 11791	11791	11790	9188905e74c28e489b44e954ec0b9bca	1	3020	3020	11790	0	Paid	2025-03-16	08:21:34	1		From Restaurant Cash
Edit	Copy	Delete DELETE FROM `tbl_purchases` WHERE `tbl_purchases`.`id_no` = 11790	11790	11789	766ebcd59621e305170616ba3d3dac32	28	1190	1190	11789	0	Paid	2025-03-16	08:20:39	1		From Restaurant Cash
Edit	Copy	Delete DELETE FROM `tbl_purchases` WHERE `tbl_purchases`.`id_no` = 11789	11789	11788	cbb6a3b884f4f88b3a8e3d44c636cbd8	28	820	820	11788	0	Paid	2025-03-16	08:19:39	1		From Restaurant Cash
Edit	Copy	Delete DELETE FROM `tbl_purchases` WHERE `tbl_purchases`.`id_no` = 11788	11788	11787	45c48cce2e2d7fbdea1afc51c7c6ad26	32	550	550	11787	0	Paid	2025-03-16	08:19:08	1		From Restaurant Cash
Edit	Copy	Delete DELETE FROM `tbl_purchases` WHERE `tbl_purchases`.`id_no` = 11787	11787	11786	5737034557ef5b8c02c0e46513b98f90	34	4140	4140	11786	0	Paid	2025-03-16	08:18:46	1		From Restaurant Cash
Edit	Copy	Delete DELETE FROM `tbl_purchases` WHERE `tbl_purchases`.`id_no` = 11786	11786	11785	dc82d632c9fcecb0778afbc7924494a6	28	600	600	11785	0	Paid	2025-03-16	08:18:12	1		From Restaurant Cash
Edit	Copy	Delete DELETE FROM `tbl_purchases` WHERE `tbl_purchases`.`id_no` = 11785	11785	11784	9f53d83ec0691550f7d2507d57f4f5a2	30	1080	0	11784	0	Pending	2025-03-16	08:17:44	1		Pending
Edit	Copy	Delete DELETE FROM `tbl_purchases` WHERE `tbl_purchases`.`id_no` = 11784	11784	11783	17c276c8e723eb46aef576537e9d56d0	30	1080	0	11783	0	Pending	2025-03-16	08:17:23	1		Pending
Edit	Copy	Delete DELETE FROM `tbl_purchases` WHERE `tbl_purchases`.`id_no` = 11783	11783	11782	d09bf41544a3365a46c9077ebb5e35c3	30	1080	0	11782	0	Pending	2025-03-16	08:17:00	1		Pending
Edit	Copy	Delete DELETE FROM `tbl_purchases` WHERE `tbl_purchases`.`id_no` = 11782	11782	11781	c3992e9a68c5ae12bd18488bc579b30d	30	1080	0	11781	0	Pending	2025-03-16	08:16:25	1		Pending
Edit	Copy	Delete DELETE FROM `tbl_purchases` WHERE `tbl_purchases`.`id_no` = 11781	11781	11780	f2201f5191c4e92cc5af043eebfd0946	32	1080	0	11780	0	Pending	2025-03-16	08:15:45	1		Pending
Edit	Copy	Delete DELETE FROM `tbl_purchases` WHERE `tbl_purchases`.`id_no` = 11780	11780	11779	7c590f01490190db0ed02a5070e20f01	17	15214	0	11779	0	Pending	2025-03-15	05:44:52	1		Pending
Edit	Copy	Delete DELETE FROM `tbl_purchases` WHERE `tbl_purchases`.`id_no` = 11779	11779	11778	192fc044e74dffea144f9ac5dc9f3395	28	10760	0	11778	0	Pending	2025-03-15	05:39:00	1		Pending
Edit	Copy	Delete DELETE FROM `tbl_purchases` WHERE `tbl_purchases`.`id_no` = 11778	11778	11777	81e74d678581a3bb7a720b019f4f1a93	80	4950	0	11777	0	Pending	2025-03-15	05:37:49	1		Pending
Edit	Copy	Delete DELETE FROM `tbl_purchases` WHERE `tbl_purchases`.`id_no` = 11777	11777	11776	24b16fede9a67c9251d3e7c7161c83ac	80	7600	0	11776	0	Pending	2025-03-15	05:36:47	1		Pending

Check all With selected:

Filter rows:

Query results operations