119.148.37.236 / localhost / proxima_database_two / greigercv

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 (43710 total, Query took 0.0818 seconds.) [grecvnot: `... - SHORTFALL...]

SELECT * FROM `greigercv` ORDER BY `grecvnot` DESC

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

Filter rows:

Sort by key:

			grid	gsid	ppid	pocid	fabid	userid	plmid	rcv_challan_no	wmid	ysupid	entrydate	greigelotno	yarnlotno	receive_date	gr_prod_date	receive_time	grcvqty	grecvnot 1
Edit	Copy	Delete DELETE FROM greigercv WHERE `greigercv`.`grid` = 19301	19301	10560	7714	14253	847	144	12090	NULL	6	1	2014-12-20	NILL	NILL	2014-12-20	NULL	22:00:00	1445.00	`
Edit	Copy	Delete DELETE FROM greigercv WHERE `greigercv`.`grid` = 42563	42563	29899	NULL	NULL	NULL	180	33694	NULL	7	1	2017-03-29	nill	04	2017-03-28	NULL	06:30:00	454.00	`
Edit	Copy	Delete DELETE FROM greigercv WHERE `greigercv`.`grid` = 14628	14628	6793	5550	9721	783	74	7474	NULL	5	9	2014-05-20	Nill	Nill	2014-05-20	NULL	18:00:00	8051.00	y/d
Edit	Copy	Delete DELETE FROM greigercv WHERE `greigercv`.`grid` = 14595	14595	4283	4818	8101	61	73	4807	NULL	4	1	2014-05-19	Nill	15/13	2014-05-18	NULL	06:00:00	245.00	y/d
Edit	Copy	Delete DELETE FROM greigercv WHERE `greigercv`.`grid` = 14657	14657	6327	5502	9650	163	76	6912	NULL	6	4	2014-05-21	Nill	Nill	2014-05-21	NULL	14:00:00	404.00	y/d
Edit	Copy	Delete DELETE FROM greigercv WHERE `greigercv`.`grid` = 14591	14591	6526	5680	10010	1414	73	7109	NULL	6	9	2014-05-19	Nill	Nill	2014-05-19	NULL	06:01:00	16787.00	Y/D
Edit	Copy	Delete DELETE FROM greigercv WHERE `greigercv`.`grid` = 14593	14593	6788	5550	9720	783	74	7473	NULL	5	9	2014-05-19	Nill	Nill	2014-05-18	NULL	20:00:00	8024.00	y/d
Edit	Copy	Delete DELETE FROM greigercv WHERE `greigercv`.`grid` = 14596	14596	6789	5501	9934	1516	73	7477	NULL	4	1	2014-05-19	Nill	15/13	2014-05-18	NULL	06:00:00	245.00	y/d
Edit	Copy	Delete DELETE FROM greigercv WHERE `greigercv`.`grid` = 14592	14592	6527	5680	10009	1414	73	7108	NULL	6	9	2014-05-19	Nill	Nill	2014-05-19	NULL	07:01:00	6430.00	Y/D
Edit	Copy	Delete DELETE FROM greigercv WHERE `greigercv`.`grid` = 14627	14627	6788	5550	9720	783	74	7473	NULL	5	9	2014-05-20	Nill	Nill	2014-05-20	NULL	18:00:00	8011.00	y/d
Edit	Copy	Delete DELETE FROM greigercv WHERE `greigercv`.`grid` = 20359	20359	11445	NULL	NULL	NULL	74	12730	NULL	6	1	2015-01-22	nill	nill	2015-01-21	NULL	18:00:00	5518.00	Wo/11680-Change-12507
Edit	Copy	Delete DELETE FROM greigercv WHERE `greigercv`.`grid` = 18300	18300	9717	7126	13032	23	74	10580	NULL	11	9	2014-11-19	Nill	20	2014-11-18	NULL	18:00:00	18283.00	Wo-10666 Transfer Wo-10667
Edit	Copy	Delete DELETE FROM greigercv WHERE `greigercv`.`grid` = 32367	32367	21353	NULL	NULL	NULL	193	24267	NULL	13	1	2016-04-25	nill	nill	2016-04-21	NULL	10:30:00	5230.00	w/o change
Edit	Copy	Delete DELETE FROM greigercv WHERE `greigercv`.`grid` = 32366	32366	21352	NULL	NULL	NULL	193	24269	NULL	13	1	2016-04-25	nill	nill	2016-04-21	NULL	10:30:00	13570.00	w/o change
Edit	Copy	Delete DELETE FROM greigercv WHERE `greigercv`.`grid` = 20052	20052	11184	NULL	NULL	NULL	127	12549	NULL	10	1	2015-01-10	nill	350/350	2014-12-27	NULL	17:00:00	2508.00	Transfer others W/O
Edit	Copy	Delete DELETE FROM greigercv WHERE `greigercv`.`grid` = 20050	20050	11184	NULL	NULL	NULL	127	12549	NULL	10	1	2015-01-10	nill	350/350	2014-12-27	NULL	17:00:00	3662.00	Transfer others W/O
Edit	Copy	Delete DELETE FROM greigercv WHERE `greigercv`.`grid` = 23315	23315	13781	NULL	NULL	NULL	1	15406	NULL	4	1	2015-06-05	00	00	2015-06-05	NULL	13:01:00	0.50	tr from wo no 14948
Edit	Copy	Delete DELETE FROM greigercv WHERE `greigercv`.`grid` = 16221	16221	8014	6485	11568	11	74	8875	NULL	5	1	2014-08-30	NILL	26+26	2014-08-30	NULL	09:00:00	1541.00	Spinning mill nill
Edit	Copy	Delete DELETE FROM greigercv WHERE `greigercv`.`grid` = 16220	16220	8013	6510	11639	31	74	8870	NULL	13	1	2014-08-30	NILL	26/12	2014-08-30	NULL	09:00:00	14593.00	Spinning mill nill
Edit	Copy	Delete DELETE FROM greigercv WHERE `greigercv`.`grid` = 15510	15510	7455	5640	9941	1505	73	8108	NULL	4	2	2014-07-14	Nill	34/32	2014-07-13	NULL	19:00:00	315.00	shortfall
Edit	Copy	Delete DELETE FROM greigercv WHERE `greigercv`.`grid` = 15740	15740	7618	5880	10364	789	73	8206	NULL	4	1	2014-08-04	Nill	Nill	2014-07-26	NULL	20:00:00	240.00	shortfall
Edit	Copy	Delete DELETE FROM greigercv WHERE `greigercv`.`grid` = 15738	15738	7617	5982	10582	1414	73	8233	NULL	4	8	2014-08-04	Nill	Nill	2014-07-26	NULL	20:00:00	598.00	shortfall
Edit	Copy	Delete DELETE FROM greigercv WHERE `greigercv`.`grid` = 15568	15568	7499	5876	10356	12	73	8232	NULL	4	9	2014-07-17	Nill	11/14	2014-07-16	NULL	20:00:00	372.00	shortfall
Edit	Copy	Delete DELETE FROM greigercv WHERE `greigercv`.`grid` = 15150	15150	7186	5695	10039	1813	73	7850	NULL	4	2	2014-06-18	NILL	7+22/7	2014-06-18	NULL	18:00:00	194.00	Shortfall
Edit	Copy	Delete DELETE FROM greigercv WHERE `greigercv`.`grid` = 15546	15546	7484	6057	10725	731	73	8205	NULL	6	1	2014-07-16	Nill	19/19	2014-07-15	NULL	20:00:00	238.00	shortfall

Check all With selected:

Filter rows:

Sort by key:

Query results operations

Copy to clipboard

Export

Display chart

Create view