119.148.37.236 / localhost / proxima_database_two / pirivcolordetail

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 (56590 total, Query took 0.1094 seconds.) [picqty: 1500000.00... - 303736.00...]

SELECT * FROM `pirivcolordetail` ORDER BY `picqty` DESC

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

Filter rows:

			picrivid	picrivdate	picid	piid	picdesc	picustomer	picstyle	piccolor	labdipref	labdipapp	picqty 1	picprice	coating	labdipappimg	pirivid
Edit	Copy	Delete DELETE FROM pirivcolordetail WHERE `pirivcolordetail`.`picrivid` = 66913	66913	NULL	68991	32429	NULL	NULL	Paul Flake Pants AKM 542	TBA	TBA	TBA	1500000.00	2.37	NULL	NULL	21633
Edit	Copy	Delete DELETE FROM pirivcolordetail WHERE `pirivcolordetail`.`picrivid` = 66355	66355	NULL	68992	32430	NULL	NULL	Only & Sons	TBA	TBA	TBA	600000.00	2.48	NULL	NULL	21439
Edit	Copy	Delete DELETE FROM pirivcolordetail WHERE `pirivcolordetail`.`picrivid` = 75153	75153	NULL	77825	36316	NULL	NULL	s/4911,4770,7659,5045,5091 SPR'24	RFD	RFD	RFD	584800.00	2.65	NULL	NULL	24029
Edit	Copy	Delete DELETE FROM pirivcolordetail WHERE `pirivcolordetail`.`picrivid` = 25344	25344	0000-00-00	17041	7696		NULL	00310344	Blue AOP	As Per Sample	TBA	427997.00	1.40	NULL	NULL	7455
Edit	Copy	Delete DELETE FROM pirivcolordetail WHERE `pirivcolordetail`.`picrivid` = 14313	14313	0000-00-00	8362	3719		NULL	STYLE-A	TAUPE	NULL	NULL	411000.00	2.42	NULL	NULL	4411
Edit	Copy	Delete DELETE FROM pirivcolordetail WHERE `pirivcolordetail`.`picrivid` = 25345	25345	0000-00-00	17042	7697		NULL	00310344	Optical White	As Per Sample	TBA	374819.00	1.25	NULL	NULL	7456
Edit	Copy	Delete DELETE FROM pirivcolordetail WHERE `pirivcolordetail`.`picrivid` = 8264	8264	0000-00-00	6415	2820		NULL	8197-001	RFD	NULL	NULL	358375.00	2.45	NULL	NULL	2481
Edit	Copy	Delete DELETE FROM pirivcolordetail WHERE `pirivcolordetail`.`picrivid` = 8106	8106	0000-00-00	6415	2820		NULL	8197-001	RFD	NULL	NULL	352500.00	2.45	NULL	NULL	2431
Edit	Copy	Delete DELETE FROM pirivcolordetail WHERE `pirivcolordetail`.`picrivid` = 34817	34817	0000-00-00	27910	12760		NULL	322748	B-Pink Carnation	IOM-17200/16,D-10985	1st submitted Handloom	351176.00	1.28	NULL	NULL	10298
Edit	Copy	Delete DELETE FROM pirivcolordetail WHERE `pirivcolordetail`.`picrivid` = 35078	35078	0000-00-00	27910	12760		NULL	278196	B-Pink Carnation	IOM-17200/16,D-10985	1st submitted Handloom	351176.00	1.28	NULL	NULL	10357
Edit	Copy	Delete DELETE FROM pirivcolordetail WHERE `pirivcolordetail`.`picrivid` = 14314	14314	0000-00-00	8363	3720		NULL	STYLE-B	RFD	RFD	RFD	349000.00	2.13	NULL	NULL	4412
Edit	Copy	Delete DELETE FROM pirivcolordetail WHERE `pirivcolordetail`.`picrivid` = 12756	12756	0000-00-00	8363	3720		NULL	STYLE-B	RFD	NULL	NULL	349000.00	2.14	NULL	NULL	3923
Edit	Copy	Delete DELETE FROM pirivcolordetail WHERE `pirivcolordetail`.`picrivid` = 34816	34816	0000-00-00	27909	12760		NULL	322748	A- Jesten Red	IOM-16654/16, D-10850	1st submitted Handloom	322898.00	1.28	NULL	NULL	10298
Edit	Copy	Delete DELETE FROM pirivcolordetail WHERE `pirivcolordetail`.`picrivid` = 35077	35077	0000-00-00	27909	12760		NULL	278196	A- Jesten Red	IOM-16654/16, D-10850	1st submitted Handloom	322898.00	1.28	NULL	NULL	10357
Edit	Copy	Delete DELETE FROM pirivcolordetail WHERE `pirivcolordetail`.`picrivid` = 19200	19200	0000-00-00	10756	4758		NULL	94226	OPTICAL WHITE	IOM#3160/13	AS PER SWATCH	320000.00	2.20	NULL	NULL	5628
Edit	Copy	Delete DELETE FROM pirivcolordetail WHERE `pirivcolordetail`.`picrivid` = 79166	79166	NULL	82636	38660	NULL	NULL	BR35100137415 (WORKWEAR SHIRT JACKET)	BLACK SOOT	23-12-6123	Option A Approved	307355.00	1.75	NULL	NULL	25296
Edit	Copy	Delete DELETE FROM pirivcolordetail WHERE `pirivcolordetail`.`picrivid` = 79044	79044	NULL	82636	38660	NULL	NULL	BR35100137415 (WORKWEAR SHIRT JACKET)	BLACK SOOT	NULL	NULL	307355.00	1.75	NULL	NULL	25265
Edit	Copy	Delete DELETE FROM pirivcolordetail WHERE `pirivcolordetail`.`picrivid` = 20385	20385	0000-00-00	11513	5082		NULL	28373	Cordovan(19-1726 TCX)	LZ-13-12-4057	C	306870.00	2.20	NULL	NULL	5944
Edit	Copy	Delete DELETE FROM pirivcolordetail WHERE `pirivcolordetail`.`picrivid` = 20523	20523	0000-00-00	11513	5082		NULL	28373	Cordovan(19-1726 TCX)	LZ-13-12-4057	C	306870.00	2.20	NULL	NULL	5994
Edit	Copy	Delete DELETE FROM pirivcolordetail WHERE `pirivcolordetail`.`picrivid` = 65775	65775	NULL	68052	32033	NULL	NULL	HOODED SHIRT JACKET	Coral Sun Multi	N/A	As Per LDE	306434.00	1.95	NULL	NULL	21292
Edit	Copy	Delete DELETE FROM pirivcolordetail WHERE `pirivcolordetail`.`picrivid` = 64791	64791	NULL	68052	32033	NULL	NULL	HOODED SHIRT JACKET	Coral Sun Multi	N/A	As Per LDE	306434.00	1.95	NULL	NULL	21026
Edit	Copy	Delete DELETE FROM pirivcolordetail WHERE `pirivcolordetail`.`picrivid` = 64750	64750	NULL	68052	32033	NULL	NULL	HOODED SHIRT JACKET	Coral Sun Multi	N/A	As Per LDE	306434.00	1.95	NULL	NULL	21005
Edit	Copy	Delete DELETE FROM pirivcolordetail WHERE `pirivcolordetail`.`picrivid` = 20244	20244	0000-00-00	11513	5082		NULL	28373	Cordovan(19-1726 TCX)	NULL	NULL	304700.00	2.20	NULL	NULL	5911
Edit	Copy	Delete DELETE FROM pirivcolordetail WHERE `pirivcolordetail`.`picrivid` = 64339	64339	NULL	68052	32033	NULL	NULL	HOODED SHIRT JACKET	Coral Sun Multi	N/A	NULL	303736.00	1.95	NULL	NULL	20874
Edit	Copy	Delete DELETE FROM pirivcolordetail WHERE `pirivcolordetail`.`picrivid` = 64639	64639	NULL	68052	32033	NULL	NULL	HOODED SHIRT JACKET	Coral Sun Multi	N/A	As Per LDE	303736.00	1.95	NULL	NULL	20968

Check all With selected:

Filter rows:

Query results operations

Copy to clipboard

Export

Display chart

Create view