competence-rs.com / localhost / herp / addmrn

Navigation panel
Navigation tree
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 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

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

Database: herp »

Table: addmrn

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 (9297 total, Query took 0.0042 seconds.) [id: 9299... - 9275...]

SELECT * FROM `addmrn` ORDER BY `id`  DESC

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

Filter rows:

			id 1	MRNNo	MRNVoucherDate	MRNDate	ReceivedAgainst	MaterialReceiptOnBasis	rmrs_no	StoreCode	site	StoreName	PO_WO_MTO	OrderDate	ReceivedFrom	DocumentType	BillNo	BillDate	GetPassNo	Inwardsdate	TimeIn	Timeout	LRdate	TotalWeight	Remarks	createdby	mrnstatus	site_name	totalqty	total_Item_Amount	pkg_perc	pkg_charges	vat_cst	vat_cst_val	sur_oct_per	sur_oct_amt	tot_freight	add_charges	grandtotal	round_off	order_no	Type	Cancel_Status	OrderFromSite	gatepassdate	companyID	loading	workorderno	workorderitem	userstype	Grn_Type	Po_category	Modified_date	duty_type	totalRecQty	totalBillQty	purch_ord_category	transaction_time	site_tranf_status	totalamount
Edit	Copy	Delete DELETE FROM `addmrn` WHERE `addmrn`.`id` = 9299	9299	APH/24-25//0219	2024-07-27	2024-07-29	PO	NULL	NULL	2	APH	NULL	NULL	NULL	271	Bill	89	NULL	6971	NULL	Day	11:35:43	2024-07-29	NULL	NULL	17	Pending	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	9851	DO	N	NULL	2024-07-29	3	NULL	NULL	NULL	NULL	Indirect	MT	0000-00-00	Consolidated	10200.00	10200.00	NULL	2024-07-29 11:37:03	NULL	NULL
Edit	Copy	Delete DELETE FROM `addmrn` WHERE `addmrn`.`id` = 9298	9298	APH/24-25//0218	2024-07-25	2024-07-29	PO	NULL	NULL	2	APH	NULL	NULL	NULL	7	Bill	IL24-00939	NULL	6972	NULL	Day	10:11:54	2024-07-29	NULL	NULL	17	Pending	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	9850	DO	N	NULL	2024-07-29	3	NULL	NULL	NULL	NULL	Indirect	MT	0000-00-00	Consolidated	700.00	700.00	NULL	2024-07-29 10:14:48	NULL	NULL
Edit	Copy	Delete DELETE FROM `addmrn` WHERE `addmrn`.`id` = 9297	9297	AEH/24-25//0304	2024-06-28	2024-07-27	PO	NULL	NULL	1	AEH	NULL	NULL	NULL	367	Bill	05,22,03	NULL	6650	NULL	Day	11:53:11	2024-07-27	NULL	NULL	111	Pending	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	9842	DO	N	NULL	2024-03-26	3	NULL	NULL	NULL	NULL	Indirect	MT	0000-00-00	Consolidated	16.00	16.00	NULL	2024-07-27 11:54:31	NULL	NULL
Edit	Copy	Delete DELETE FROM `addmrn` WHERE `addmrn`.`id` = 9296	9296	AEH/24-25//0303	2024-06-28	2024-07-27	PO	NULL	NULL	1	AEH	NULL	NULL	NULL	367	Bill	333	NULL	6650	NULL	Day	11:50:54	2024-07-27	NULL	NULL	111	Pending	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	9839	DO	N	NULL	2024-03-26	3	NULL	NULL	NULL	NULL	Indirect	MT	0000-00-00	Consolidated	19.00	19.00	NULL	2024-07-27 11:51:57	NULL	NULL
Edit	Copy	Delete DELETE FROM `addmrn` WHERE `addmrn`.`id` = 9295	9295	AEH/24-25//0302	2024-07-26	2024-07-27	PO	NULL	NULL	1	AEH	NULL	NULL	NULL	367	Bill	068,445,07	NULL	6650	NULL	Day	11:48:04	2024-07-27	NULL	NULL	111	Pending	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	9845	DO	N	NULL	2024-03-26	3	NULL	NULL	NULL	NULL	Indirect	MT	0000-00-00	Consolidated	4.00	4.00	NULL	2024-07-27 11:49:35	NULL	NULL
Edit	Copy	Delete DELETE FROM `addmrn` WHERE `addmrn`.`id` = 9294	9294	AEH/24-25//0301	2024-06-28	2024-07-27	PO	NULL	NULL	1	AEH	NULL	NULL	NULL	367	Bill	421	NULL	6650	NULL	Day	11:45:32	2024-07-27	NULL	NULL	111	Pending	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	9845	DO	N	NULL	2024-03-26	3	NULL	NULL	NULL	NULL	Indirect	MT	0000-00-00	Consolidated	5.00	5.00	NULL	2024-07-27 11:47:05	NULL	NULL
Edit	Copy	Delete DELETE FROM `addmrn` WHERE `addmrn`.`id` = 9293	9293	AEH/24-25//0300	2024-07-20	2024-07-27	PO	NULL	NULL	1	AEH	NULL	NULL	NULL	69	Bill	398	NULL	6964	NULL	Day	11:43:28	2024-07-27	NULL	NULL	111	Pending	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	9818	DO	N	NULL	2024-07-24	3	NULL	NULL	NULL	NULL	Indirect	MT	0000-00-00	Consolidated	6.00	6.00	NULL	2024-07-27 11:44:18	NULL	NULL
Edit	Copy	Delete DELETE FROM `addmrn` WHERE `addmrn`.`id` = 9292	9292	AEH/24-25//0299	2024-07-23	2024-07-27	PO	NULL	NULL	1	AEH	NULL	NULL	NULL	435	Bill	0077	NULL	6727	NULL	Day	11:40:19	2024-07-27	NULL	NULL	111	Pending	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	9832	DO	N	NULL	2024-03-19	3	NULL	NULL	NULL	NULL	Indirect	MT	0000-00-00	Consolidated	1.00	1.00	NULL	2024-07-27 11:42:14	NULL	NULL
Edit	Copy	Delete DELETE FROM `addmrn` WHERE `addmrn`.`id` = 9291	9291	APH/24-25//0217	2024-07-26	2024-07-27	PO	NULL	NULL	2	APH	NULL	NULL	NULL	16	Bill	A006978	NULL	6969	NULL	Day	09:44:28	2024-07-27	NULL	NULL	17	Pending	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	9847	DO	N	NULL	2024-07-27	3	NULL	NULL	NULL	NULL	Indirect	MT	0000-00-00	Consolidated	350.00	350.00	NULL	2024-07-27 09:51:18	NULL	NULL
Edit	Copy	Delete DELETE FROM `addmrn` WHERE `addmrn`.`id` = 9290	9290	AEH/24-25//0298	2024-07-16	2024-07-26	PO	NULL	NULL	1	AEH	NULL	NULL	NULL	442	Bill	319	NULL	MANI MANDI	NULL	Day	11:40:42	2024-07-26	NULL	NULL	111	Pending	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	9840	DO	N	NULL	2024-07-16	3	NULL	NULL	NULL	NULL	Indirect	MT	0000-00-00	Consolidated	1382.00	1382.00	NULL	2024-07-26 11:42:30	NULL	NULL
Edit	Copy	Delete DELETE FROM `addmrn` WHERE `addmrn`.`id` = 9289	9289	AEH/24-25//0297	2024-07-09	2024-07-26	PO	NULL	NULL	1	AEH	NULL	NULL	NULL	442	Bill	316	NULL	MANI MANDI	NULL	Day	11:37:25	2024-07-26	NULL	NULL	111	Pending	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	9836	DO	N	NULL	2024-07-09	3	NULL	NULL	NULL	NULL	Indirect	MT	0000-00-00	Consolidated	1531.50	1531.50	NULL	2024-07-26 11:39:13	NULL	NULL
Edit	Copy	Delete DELETE FROM `addmrn` WHERE `addmrn`.`id` = 9288	9288	AEH/24-25//0296	2024-06-27	2024-07-26	PO	NULL	NULL	1	AEH	NULL	NULL	NULL	442	Bill	313	NULL	MANI MANDI	NULL	Day	11:34:50	2024-07-26	NULL	NULL	111	Pending	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	9835	DO	N	NULL	2024-06-27	3	NULL	NULL	NULL	NULL	Indirect	MT	0000-00-00	Consolidated	2517.00	2517.00	NULL	2024-07-26 11:36:33	NULL	NULL
Edit	Copy	Delete DELETE FROM `addmrn` WHERE `addmrn`.`id` = 9287	9287	AEH/24-25//0295	2024-07-13	2024-07-26	PO	NULL	NULL	1	AEH	NULL	NULL	NULL	442	Bill	318	NULL	MANI MANDI	NULL	Day	11:30:20	2024-07-26	NULL	NULL	111	Pending	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	9838	DO	N	NULL	2024-07-13	3	NULL	NULL	NULL	NULL	Indirect	MT	0000-00-00	Consolidated	2303.00	2303.00	NULL	2024-07-26 11:31:36	NULL	NULL
Edit	Copy	Delete DELETE FROM `addmrn` WHERE `addmrn`.`id` = 9286	9286	AEH/24-25//0294	2024-07-10	2024-07-26	PO	NULL	NULL	1	AEH	NULL	NULL	NULL	442	Bill	317	NULL	MANI MANDI	NULL	Day	11:27:37	2024-07-26	NULL	NULL	111	Pending	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	9837	DO	N	NULL	2024-07-10	3	NULL	NULL	NULL	NULL	Indirect	MT	0000-00-00	Consolidated	2258.50	2258.50	NULL	2024-07-26 11:29:21	NULL	NULL
Edit	Copy	Delete DELETE FROM `addmrn` WHERE `addmrn`.`id` = 9285	9285	APH/24-25//0216	2024-07-22	2024-07-26	PO	NULL	NULL	2	APH	NULL	NULL	NULL	15	Challan	T001204	NULL	6967	NULL	Day	10:03:59	2024-07-26	NULL	NULL	17	Pending	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	9827	DO	N	NULL	2024-07-25	3	NULL	NULL	NULL	NULL	Indirect	MT	0000-00-00	Consolidated	4000.00	4000.00	NULL	2024-07-26 10:22:06	NULL	NULL
Edit	Copy	Delete DELETE FROM `addmrn` WHERE `addmrn`.`id` = 9284	9284	APH/24-25//0215	2024-07-23	2024-07-25	PO	NULL	NULL	2	APH	NULL	NULL	NULL	11	Bill	DDPL/2469/	NULL	6966	NULL	Day	02:55:42	2024-07-25	NULL	NULL	17	Pending	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	9825	DO	N	NULL	2024-07-25	3	NULL	NULL	NULL	NULL	Indirect	MT	0000-00-00	Consolidated	2010.00	2010.00	NULL	2024-07-25 14:58:03	NULL	NULL
Edit	Copy	Delete DELETE FROM `addmrn` WHERE `addmrn`.`id` = 9283	9283	APH/24-25//0214	2024-07-23	2024-07-25	PO	NULL	NULL	2	APH	NULL	NULL	NULL	11	Bill	DDPL/2468/	NULL	6966	NULL	Day	02:51:46	2024-07-25	NULL	NULL	17	Pending	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	9825	DO	N	NULL	2024-07-25	3	NULL	NULL	NULL	NULL	Indirect	MT	0000-00-00	Consolidated	300.00	300.00	NULL	2024-07-25 14:54:27	NULL	NULL
Edit	Copy	Delete DELETE FROM `addmrn` WHERE `addmrn`.`id` = 9282	9282	APH/24-25//0213	2024-07-25	2024-07-25	PO	NULL	NULL	3	APH	NULL	NULL	NULL	62	Bill	4336	NULL	6965	NULL	Day	12:00:25	2024-07-25	NULL	NULL	13	Pending	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	9834	DO	N	NULL	2024-07-25	3	NULL	NULL	NULL	NULL	Indirect	MT	0000-00-00	Consolidated	352.00	352.00	NULL	2024-07-25 12:06:50	NULL	NULL
Edit	Copy	Delete DELETE FROM `addmrn` WHERE `addmrn`.`id` = 9281	9281	APH/24-25//0212	2024-07-22	2024-07-24	PO	NULL	NULL	2	APH	NULL	NULL	NULL	10	Bill	JN02OP25-1	NULL	6963	NULL	Day	04:07:06	2024-07-24	NULL	NULL	17	Pending	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	9826	DO	N	NULL	2024-07-24	3	NULL	NULL	NULL	NULL	Indirect	MT	0000-00-00	Consolidated	250.00	250.00	NULL	2024-07-24 16:30:56	NULL	NULL
Edit	Copy	Delete DELETE FROM `addmrn` WHERE `addmrn`.`id` = 9280	9280	APH/24-25//0211	2024-07-22	2024-07-24	PO	NULL	NULL	2	APH	NULL	NULL	NULL	2	Bill	T24/1226	NULL	6962	NULL	Day	10:07:58	2024-07-24	NULL	NULL	17	Pending	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	9831	DO	N	NULL	2024-07-23	3	NULL	NULL	NULL	NULL	Indirect	MT	0000-00-00	Consolidated	840.00	840.00	NULL	2024-07-24 10:12:06	NULL	NULL
Edit	Copy	Delete DELETE FROM `addmrn` WHERE `addmrn`.`id` = 9279	9279	AEH/24-25//0293	2024-07-17	2024-07-23	PO	NULL	NULL	1	AEH	NULL	NULL	NULL	49	Bill	40	NULL	6955	NULL	Day	10:05:25	2024-07-23	NULL	NULL	111	Pending	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	9814	DO	N	NULL	2024-07-17	3	NULL	NULL	NULL	NULL	Indirect	MT	0000-00-00	Consolidated	5004.00	5004.00	NULL	2024-07-23 10:06:11	NULL	NULL
Edit	Copy	Delete DELETE FROM `addmrn` WHERE `addmrn`.`id` = 9278	9278	AEH/24-25//0292	2024-07-04	2024-07-23	PO	NULL	NULL	1	AEH	NULL	NULL	NULL	58	Bill	2219	NULL	6957	NULL	Day	10:03:04	2024-07-23	NULL	NULL	111	Pending	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	9784	DO	N	NULL	2024-07-19	3	NULL	NULL	NULL	NULL	Indirect	MT	0000-00-00	Consolidated	23.00	23.00	NULL	2024-07-23 10:03:58	NULL	NULL
Edit	Copy	Delete DELETE FROM `addmrn` WHERE `addmrn`.`id` = 9277	9277	APH/24-25//0210	2024-07-19	2024-07-22	PO	NULL	NULL	2	APH	NULL	NULL	NULL	2	Bill	T24/1198	NULL	6960	NULL	Day	10:09:09	2024-07-22	NULL	NULL	17	Pending	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	9816	DO	N	NULL	2024-07-20	3	NULL	NULL	NULL	NULL	Indirect	MT	0000-00-00	Consolidated	1300.00	1300.00	NULL	2024-07-22 10:11:07	NULL	NULL
Edit	Copy	Delete DELETE FROM `addmrn` WHERE `addmrn`.`id` = 9276	9276	APH/24-25//0209	2024-07-19	2024-07-22	PO	NULL	NULL	2	APH	NULL	NULL	NULL	2	Bill	T24/1197	NULL	6960	NULL	Day	10:05:52	2024-07-22	NULL	NULL	17	Pending	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	9815	DO	N	NULL	2024-07-20	3	NULL	NULL	NULL	NULL	Indirect	MT	0000-00-00	Consolidated	260.00	260.00	NULL	2024-07-22 10:07:35	NULL	NULL
Edit	Copy	Delete DELETE FROM `addmrn` WHERE `addmrn`.`id` = 9275	9275	APH/24-25//0208	2024-07-20	2024-07-20	PO	NULL	NULL	3	APH	NULL	NULL	NULL	62	Bill	4324	NULL	6958	NULL	Day	03:09:26	2024-07-20	NULL	NULL	13	Pending	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	9817	DO	N	NULL	2024-07-20	3	NULL	NULL	NULL	NULL	Indirect	MT	0000-00-00	Consolidated	9.00	9.00	NULL	2024-07-20 15:15:07	NULL	NULL

Check all With selected:

Filter rows:

Query results operations

Print view

Export

Display chart

Create view