119.148.37.236 / localhost / proxima_database_two / inputbatcherdetail

There are no favorite tables.

New
information_schema
mysql
performance_schema
phpmyadmin
proxima_database
- proxima_database
- proxima_database_two
sajola_mms
test

Customize 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.
Favorite tables Maximum number of favorite tables; set 0 to disable.
Navigation panel width Set to 0 to collapse navigation panel.

Customize 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

Customize 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 (447630 total, Query took 0.7608 seconds.) [inputnote: `... - 4710...]

SELECT * FROM `inputbatcherdetail` ORDER BY `inputnote` DESC

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

Filter rows:

Sort by key:

			inbid	dsrid	dsbid	pocid	plmid	prid	rcid	inbacherqty	intranqty	rcsubid	indate	intime	userid	tnote	rpnum	inshift	inputnote 1	inentrydate	dinrid	dinid
Edit	Copy	Delete DELETE FROM inputbatcherdetail WHERE `inputbatcherdetail`.`inbid` = 174414	174414	NULL	NULL	NULL	15889	6	41517	5570.00	NULL	NULL	2015-08-04	08:35:00	163	NULL	1	A	`	2015-08-04 11:09:04	NULL	NULL
Edit	Copy	Delete DELETE FROM inputbatcherdetail WHERE `inputbatcherdetail`.`inbid` = 170144	170144	NULL	NULL	NULL	16167	6	40868	1673.00	NULL	NULL	2015-07-13	00:40:00	143	NULL	1	C	`	2015-07-14 05:18:04	NULL	NULL
Edit	Copy	Delete DELETE FROM inputbatcherdetail WHERE `inputbatcherdetail`.`inbid` = 368782	368782	NULL	NULL	NULL	29683	6	68454	3700.00	NULL	NULL	2016-11-17	05:30:00	150	NULL	1	C	`	2016-11-18 06:54:28	NULL	NULL
Edit	Copy	Delete DELETE FROM inputbatcherdetail WHERE `inputbatcherdetail`.`inbid` = 389729	389729	NULL	NULL	NULL	29536	6	71252	4050.00	NULL	NULL	2016-12-26	05:00:00	150	NULL	1	C	`	2016-12-27 08:33:58	NULL	NULL
Edit	Copy	Delete DELETE FROM inputbatcherdetail WHERE `inputbatcherdetail`.`inbid` = 210905	210905	NULL	NULL	NULL	18332	6	46717	2530.00	NULL	NULL	2015-11-06	19:25:00	74	NULL	1	B	`	2015-11-06 20:43:15	NULL	NULL
Edit	Copy	Delete DELETE FROM inputbatcherdetail WHERE `inputbatcherdetail`.`inbid` = 202282	202282	NULL	NULL	NULL	18664	6	45514	400.00	NULL	NULL	2015-10-17	00:00:00	74	NULL	1	C	`	2015-10-18 01:01:04	NULL	NULL
Edit	Copy	Delete DELETE FROM inputbatcherdetail WHERE `inputbatcherdetail`.`inbid` = 136109	136109	NULL	NULL	NULL	13690	6	36233	4700.00	NULL	NULL	2015-03-19	11:50:00	163	NULL	1	A	`	2015-03-19 13:42:51	NULL	NULL
Edit	Copy	Delete DELETE FROM inputbatcherdetail WHERE `inputbatcherdetail`.`inbid` = 76538	76538	NULL	NULL	10191	8044	6	23260	129.00	NULL	NULL	2014-06-29	11:20:00	73	NULL	1	A	Shortfall	2014-06-29 11:20:00	NULL	NULL
Edit	Copy	Delete DELETE FROM inputbatcherdetail WHERE `inputbatcherdetail`.`inbid` = 114897	114897	NULL	NULL	NULL	12034	6	32321	1275.00	NULL	NULL	2014-12-31	17:15:00	151	NULL	1	B	only Desize	2014-12-31 17:15:00	NULL	NULL
Edit	Copy	Delete DELETE FROM inputbatcherdetail WHERE `inputbatcherdetail`.`inbid` = 78609	78609	NULL	NULL	10876	8132	6	23699	2800.00	NULL	NULL	2014-07-06	08:00:00	74	NULL	1	A	griege receive date- 30/06/2014	2014-07-06 08:00:00	NULL	NULL
Edit	Copy	Delete DELETE FROM inputbatcherdetail WHERE `inputbatcherdetail`.`inbid` = 363571	363571	NULL	NULL	NULL	26516	6	67762	295.00	NULL	NULL	2016-11-07	07:00:00	164	NULL	1	A	Excess Issue	2016-11-08 11:57:57	NULL	NULL
Edit	Copy	Delete DELETE FROM inputbatcherdetail WHERE `inputbatcherdetail`.`inbid` = 308968	308968	NULL	NULL	NULL	24735	6	60294	4574.00	NULL	NULL	2016-06-16	17:50:00	164	NULL	1	B	Excess Issue	2016-06-21 14:18:34	NULL	NULL
Edit	Copy	Delete DELETE FROM inputbatcherdetail WHERE `inputbatcherdetail`.`inbid` = 309311	309311	NULL	NULL	NULL	24639	6	60358	594.00	NULL	NULL	2016-06-22	11:36:00	211	NULL	1	A	Excess	2016-06-22 12:46:34	NULL	NULL
Edit	Copy	Delete DELETE FROM inputbatcherdetail WHERE `inputbatcherdetail`.`inbid` = 151793	151793	NULL	NULL	NULL	14637	6	38306	3312.00	NULL	NULL	2015-05-07	03:25:00	164	NULL	1	C	CHANGE LOT 686/618	2015-05-08 04:58:12	NULL	NULL
Edit	Copy	Delete DELETE FROM inputbatcherdetail WHERE `inputbatcherdetail`.`inbid` = 243234	243234	NULL	NULL	NULL	20248	6	51156	490.00	NULL	NULL	2016-01-11	22:20:00	196	NULL	1	C	94	2016-01-12 02:24:16	NULL	NULL
Edit	Copy	Delete DELETE FROM inputbatcherdetail WHERE `inputbatcherdetail`.`inbid` = 384565	384565	NULL	NULL	NULL	31154	6	70568	662.00	NULL	NULL	2016-12-17	12:55:00	76	NULL	1	A	662	2016-12-18 08:37:38	NULL	NULL
Edit	Copy	Delete DELETE FROM inputbatcherdetail WHERE `inputbatcherdetail`.`inbid` = 357795	357795	NULL	NULL	NULL	28384	6	67016	1536.00	NULL	NULL	2016-10-28	08:00:00	150	NULL	1	A	61	2016-10-28 11:34:14	NULL	NULL
Edit	Copy	Delete DELETE FROM inputbatcherdetail WHERE `inputbatcherdetail`.`inbid` = 101541	101541	NULL	NULL	13031	10579	6	29077	4000.00	NULL	NULL	2014-11-12	21:30:00	74	NULL	1	B	61	2014-11-12 21:30:00	NULL	NULL
Edit	Copy	Delete DELETE FROM inputbatcherdetail WHERE `inputbatcherdetail`.`inbid` = 80265	80265	NULL	NULL	10988	8197	6	24070	6055.00	NULL	NULL	2014-07-19	23:40:00	75	NULL	1	C	6055	2014-07-19 23:40:00	NULL	NULL
Edit	Copy	Delete DELETE FROM inputbatcherdetail WHERE `inputbatcherdetail`.`inbid` = 420462	420462	NULL	NULL	NULL	32707	6	74972	5980.00	NULL	NULL	2017-02-28	15:55:00	74	NULL	1	B	5980	2017-02-28 21:22:42	NULL	NULL
Edit	Copy	Delete DELETE FROM inputbatcherdetail WHERE `inputbatcherdetail`.`inbid` = 233105	233105	NULL	NULL	NULL	20405	6	49813	5100.00	NULL	NULL	2015-12-23	18:00:00	180	NULL	1	B	5100	2015-12-23 23:12:06	NULL	NULL
Edit	Copy	Delete DELETE FROM inputbatcherdetail WHERE `inputbatcherdetail`.`inbid` = 441820	441820	NULL	NULL	NULL	34313	6	77644	5053.00	NULL	NULL	2017-04-20	12:15:00	232	NULL	1	A	5053	2017-04-20 15:30:25	NULL	NULL
Edit	Copy	Delete DELETE FROM inputbatcherdetail WHERE `inputbatcherdetail`.`inbid` = 222861	222861	NULL	NULL	NULL	19484	6	48422	4800.00	NULL	NULL	2015-12-01	05:01:00	143	NULL	1	C	4800	2015-12-02 06:35:32	NULL	NULL
Edit	Copy	Delete DELETE FROM inputbatcherdetail WHERE `inputbatcherdetail`.`inbid` = 434130	434130	NULL	NULL	NULL	33962	6	76671	4790.00	NULL	NULL	2017-04-01	22:00:00	180	NULL	1	C	4790	2017-04-02 01:44:56	NULL	NULL
Edit	Copy	Delete DELETE FROM inputbatcherdetail WHERE `inputbatcherdetail`.`inbid` = 101306	101306	NULL	NULL	12669	10053	6	29030	330.00	NULL	NULL	2014-11-12	07:20:00	147	NULL	1	A	4710	2014-11-12 07:20:00	NULL	NULL

Check all With selected:

Filter rows:

Sort by key:

Query results operations

Copy to clipboard

Export

Display chart

Create view