Drop files here

SQL upload ( 0 ) x -

Page-related settings Click on the bar to scroll to top of page
Press Ctrl+Enter to execute query Press Enter to execute query
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse Expand Show trace Hide trace Count : Time taken :
Bookmarks
Refresh
Add
No bookmarks
Add bookmark
Options
Set default





Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database : Queried time :
Browse mode
Customize browse mode.
Browse mode
Documentation Use only icons, only text or both. Restore default value
Documentation Use only icons, only text or both. Restore default value
Documentation Whether a user should be displayed a "show all (rows)" button. Restore default value
Documentation Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown. Restore default value
Documentation SMART - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise. Restore default value
Documentation Highlight row pointed by the mouse cursor. Restore default value
Documentation Highlight selected rows. Restore default value
Documentation Restore default value
Documentation Restore default value
Documentation Repeat the headers every X cells, 0 deactivates this feature. Restore default value
Documentation Maximum number of characters shown in any non-numeric column on browse view. Restore default value
Documentation These are Edit, Copy and Delete links. Restore default value
Documentation Whether to show row links even in the absence of a unique key. Restore default value
Documentation Default sort order for tables with a primary key. Restore default value
Documentation When browsing tables, the sorting of each table is remembered. Restore default value
Documentation For display Options Restore default value
SELECT * FROM `fabricdetail` ORDER BY `fabid` DESC 
[ Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
Full texts fabid Descending Ascending 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 Edit Copy Copy Delete 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 Edit Copy Copy Delete 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 Edit Copy Copy Delete 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 Edit Copy Copy Delete 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 Edit Copy Copy Delete 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 Edit Copy Copy Delete 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 Edit Copy Copy Delete 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 Edit Copy Copy Delete 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 Edit Copy Copy Delete 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 Edit Copy Copy Delete 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 Edit Copy Copy Delete 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 Edit Copy Copy Delete 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 Edit Copy Copy Delete 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 Edit Copy Copy Delete 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 Edit Copy Copy Delete 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 Edit Copy Copy Delete 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 Edit Copy Copy Delete 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 Edit Copy Copy Delete 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 Edit Copy Copy Delete 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 Edit Copy Copy Delete 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 Edit Copy Copy Delete 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 Edit Copy Copy Delete 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 Edit Copy Copy Delete 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 Edit Copy Copy Delete 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 Edit Copy Copy Delete 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
With selected: With selected:
Query results operations Copy to clipboard Copy to clipboard Export Export Display chart Display chart Create view Create view
Bookmark this SQL query Bookmark this SQL query