119.148.37.236 / localhost / proxima_database_two / fabricdetail

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 (31798 total, Query took 0.0008 seconds.) [fabid: 31799... - 31775...]

SELECT * FROM `fabricdetail` ORDER BY `fabid` DESC

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

Filter rows:

			fabid 1	artcode	composition	weave	construction	totalends	reedcount	reedspech	pick	warpcount	weftcount	wtofwarp	wtofweft	linearweight	gsm	oz	width	salvedge	fabstatus A-Active, C-Cancle, H-Hold
Edit	Copy	Delete DELETE FROM fabricdetail WHERE `fabricdetail`.`fabid` = 31799	31799	ORT181211456	100% ORGANIC COTTON	3/1 S TWILL	18X12/114X56	NULL	NULL	NULL	NULL	18	12	NULL	NULL	NULL	275	8.11	61	NULL	H
Edit	Copy	Delete DELETE FROM fabricdetail WHERE `fabricdetail`.`fabid` = 31798	31798	ORD2020216470	100% ORGANIC COTTON	DOBBY	20X20/2/164X70	NULL	NULL	NULL	NULL	20	10	NULL	NULL	NULL	360	10.61	61	NULL	H
Edit	Copy	Delete DELETE FROM fabricdetail WHERE `fabricdetail`.`fabid` = 31797	31797	ORD161611672	100% ORGANIC COTTON	DOBBY	16X16/116X72	NULL	NULL	NULL	NULL	16	16	NULL	NULL	NULL	278	8.20	61	NULL	H
Edit	Copy	Delete DELETE FROM fabricdetail WHERE `fabricdetail`.`fabid` = 31796	31796	SLC883434	100% CONVENTIONAL COTTON SLUB	1/1 PLAIN	8SX8S/34X34	NULL	NULL	NULL	NULL	8	8	NULL	NULL	NULL	210	6.19	61	NULL	H
Edit	Copy	Delete DELETE FROM fabricdetail WHERE `fabricdetail`.`fabid` = 31795	31795	OC771027628	100% CONVENTIONAL COTTON	OXFORD	(7+7)X10/2/76X28	NULL	NULL	NULL	NULL	7	5	NULL	NULL	NULL	405	11.94	61	NULL	H
Edit	Copy	Delete DELETE FROM fabricdetail WHERE `fabricdetail`.`fabid` = 31794	31794	L10107844(BCI)	55% BCI COTTON & 45% LINEN	DOBBY	10X10/78X44	NULL	NULL	NULL	NULL	10	10	NULL	NULL	NULL	286	8.43	61	NULL	H
Edit	Copy	Delete DELETE FROM fabricdetail WHERE `fabricdetail`.`fabid` = 31793	31793	RECPLCT161610256(BCI)	65% RECYCLED POLYESTER (POST) & 35% BCI COTTON	2/2 Z TWILL	16X16/102X56	NULL	NULL	NULL	NULL	16	16	NULL	NULL	NULL	220	9.43	61	NULL	H
Edit	Copy	Delete DELETE FROM fabricdetail WHERE `fabricdetail`.`fabid` = 31792	31792	T161612062(BCI)	100% BCI COTTON	3/1 S TWILL	16X16/120X62	NULL	NULL	NULL	NULL	16	16	NULL	NULL	NULL	224	6.60	61	NULL	H
Edit	Copy	Delete DELETE FROM fabricdetail WHERE `fabricdetail`.`fabid` = 31791	31791	T16169264(BCI)	100% BCI COTTON	2/2 Z TWILL	16X16/92X64	NULL	NULL	NULL	NULL	16	16	NULL	NULL	NULL	235	6.93	61	NULL	H
Edit	Copy	Delete DELETE FROM fabricdetail WHERE `fabricdetail`.`fabid` = 31790	31790	T4024024024029680(BCI)	100% BCI COTTON	2/2 Z TWILL	(40/2 GRINDLE+40/2 GRINDLE)X(40/2 GRINDLE+40/2 GRI...	NULL	NULL	NULL	NULL	20	20	NULL	NULL	NULL	205	6.04	61	NULL	H
Edit	Copy	Delete DELETE FROM fabricdetail WHERE `fabricdetail`.`fabid` = 31789	31789	RECTENCEL102216666(BCI)	83% BCI COTTON & 17% TENCEL (EXCEL)	DOBBY	10/2X21/66X66	NULL	NULL	NULL	NULL	5	21	NULL	NULL	NULL	320	9.43	61	NULL	H
Edit	Copy	Delete DELETE FROM fabricdetail WHERE `fabricdetail`.`fabid` = 31788	31788	D72724630(BCI)	100% BCI COTTON	DOBBY	7/2X7/2/46X30	NULL	NULL	NULL	NULL	4	4	NULL	NULL	NULL	480	14.15	61	NULL	H
Edit	Copy	Delete DELETE FROM fabricdetail WHERE `fabricdetail`.`fabid` = 31787	31787	D1068042(BCI)	100% BCI COTTON	DOBBY	10X6/80X42	NULL	NULL	NULL	NULL	10	6	NULL	NULL	NULL	325	9.58	61	NULL	H
Edit	Copy	Delete DELETE FROM fabricdetail WHERE `fabricdetail`.`fabid` = 31786	31786	ST910707468(BCI)	98% BCI COTTON & 2% SPANDEX	3/1 Z TWILL	9X10+70/74X68	NULL	NULL	NULL	NULL	9	10	NULL	NULL	NULL	415	12.24	67	NULL	H
Edit	Copy	Delete DELETE FROM fabricdetail WHERE `fabricdetail`.`fabid` = 31785	31785	ORT404011080(21Z)	100% ORGANIC COTTON	2/1 Z TWILL	40X40/110X80	NULL	NULL	NULL	NULL	40	40	NULL	NULL	NULL	112	3.30	61	NULL	H
Edit	Copy	Delete DELETE FROM fabricdetail WHERE `fabricdetail`.`fabid` = 31784	31784	D7105846	100% CONVENTIONAL COTTON	DOBBY	7X10/58X46	NULL	NULL	NULL	NULL	7	10	NULL	NULL	NULL	300	8.84	61	NULL	H
Edit	Copy	Delete DELETE FROM fabricdetail WHERE `fabricdetail`.`fabid` = 31783	31783	SORD201270129680	98% ORGANIC COTTON & 2% SPANDEX	DOBBY	20X(12+70D)+12/96X80	NULL	NULL	NULL	NULL	20	12	NULL	NULL	NULL	282	8.31	67	NULL	H
Edit	Copy	Delete DELETE FROM fabricdetail WHERE `fabricdetail`.`fabid` = 31782	31782	L16165640	53% LINEN & 47% CONVENTIONAL COTTON	1/1 PLAIN	16X16/56X40	NULL	NULL	NULL	NULL	16	16	NULL	NULL	NULL	152	4.48	61	NULL	H
Edit	Copy	Delete DELETE FROM fabricdetail WHERE `fabricdetail`.`fabid` = 31781	31781	P505012464	100% CONVENTIONAL COTTON	1/1 PLAIN	50X50/124X64	NULL	NULL	NULL	NULL	50	50	NULL	NULL	NULL	92	2.71	61	NULL	H
Edit	Copy	Delete DELETE FROM fabricdetail WHERE `fabricdetail`.`fabid` = 31780	31780	P404012662	100% CONVENTIONAL COTTON	1/1 PLAIN	40X40/126X62	NULL	NULL	NULL	NULL	40	40	NULL	NULL	NULL	115	3.39	61	NULL	H
Edit	Copy	Delete DELETE FROM fabricdetail WHERE `fabricdetail`.`fabid` = 31779	31779	SLC7107104834	100% CONVENTIONAL COTTON SLUB	1/1 PLAIN	(7+10S)X(7+10S)/48X34	NULL	NULL	NULL	NULL	7	10	NULL	NULL	NULL	235	6.93	61	NULL	H
Edit	Copy	Delete DELETE FROM fabricdetail WHERE `fabricdetail`.`fabid` = 31778	31778	ORT302014472	100% ORGANIC COTTON	2/1 S TWILL	30X20/144X72	NULL	NULL	NULL	NULL	30	20	NULL	NULL	NULL	202	5.95	61	NULL	H
Edit	Copy	Delete DELETE FROM fabricdetail WHERE `fabricdetail`.`fabid` = 31777	31777	V6060144130(BCI)	100% BCI COTTON	1/1 PLAIN	60X60/144X130	NULL	NULL	NULL	NULL	60	60	NULL	NULL	NULL	113	3.33	61	TUCKED-IN	H
Edit	Copy	Delete DELETE FROM fabricdetail WHERE `fabricdetail`.`fabid` = 31776	31776	SORD3024701615694	98% ORGANIC COTTON & 2% SPANDEX	DOBBY	30X(24+70D)+16/156X94	NULL	NULL	NULL	NULL	30	24	NULL	NULL	NULL	250	7.37	67	NULL	H
Edit	Copy	Delete DELETE FROM fabricdetail WHERE `fabricdetail`.`fabid` = 31775	31775	ST40407018070(BCI)	98% BCI COTTON & 2% SPANDEX	2/1 S TWILL	40X40+70D/180X70	NULL	NULL	NULL	NULL	40	40	NULL	NULL	NULL	162	4.77	67	NULL	H

Check all With selected:

Filter rows:

Query results operations

Copy to clipboard

Export

Display chart

Create view