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 `fabric_analysis` ORDER BY `rnd_warp2_fabcompid` ASC 
[ Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
Full texts fabanid fab_an_code fab_rcv_date fab_dlv_date anbuyid mkt_person mkt_date fbfid emarid weaveid gdprocessid fabcompid warp_yarn1 warp1_fabcompid warp_yarn2 warp2_fabcompid warp_yarn3 warp3_fabcompid warp_yarn4 warp4_fabcompid weft_yarn1 weft1_fabcompid weft_yarn2 weft2_fabcompid weft_yarn3 weft3_fabcompid weft_yarn4 weft4_fabcompid ppi epi color_shade wash_status fab_crimper fab_crimper_weft an_fab_wt lycra_growth lycra_recovery lycra_elongation lycra_tear lycra_tensil slub_warp_length slub_warp_pause_lenght slub_warp_dia slub_weft_length slub_weft_pause_lenght slub_weft_dia filament_no_yarn_warp filament_no_yarn_weft entry_userid entry_date entry_comments check_userid check_date check_comments app_userid app_date app_comments rnd_warp_yarn1 rnd_warp1_fabcompid rnd_warp_yarn2 rnd_warp2_fabcompid Ascending Descending 1 rnd_warp_yarn3 rnd_warp3_fabcompid rnd_warp_yarn4 rnd_warp4_fabcompid rnd_weft_yarn1 rnd_weft1_fabcompid rnd_weft_yarn2 rnd_weft2_fabcompid rnd_weft_yarn3 rnd_weft3_fabcompid rnd_weft_yarn4 rnd_weft4_fabcompid rnd_epi rnd_ppi rnd_fabcompid rnd_an_fab_wt greige_width finish_width reed_space prizes rnd_userid rnd_upd_date ana_type iopmid
Edit Edit Copy Copy Delete Delete
DELETE FROM fabric_analysis WHERE `fabric_analysis`.`fabanid` = 2
2 2/2022 2022-10-30 2022-11-03 1581 379 2022-10-23 87 4 NULL 4 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL RFD B/W NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL REPEAT 62504
Edit Edit Copy Copy Delete Delete
DELETE FROM fabric_analysis WHERE `fabric_analysis`.`fabanid` = 10
10 10/2022 2022-10-24 2022-10-24 269 383 2022-10-24 1 12 142 1 2161 33.65 2094 NULL NULL NULL 23+70D 2110 NULL NULL NULL 81.00 160.00 NAVY A/W NULL NULL 232.00 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 78 2022-10-24 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NEW NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM fabric_analysis WHERE `fabric_analysis`.`fabanid` = 11
11 11/2022 2022-10-24 2022-10-24 1320 404 2022-10-24 87 2 141 1 2084 8.04 2094 NULL NULL NULL 8.20 2094 NULL NULL NULL 41.00 64.00 OFF WHITE A/W NULL NULL 318.00 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 78 2022-10-24 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NEW NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM fabric_analysis WHERE `fabric_analysis`.`fabanid` = 12
12 12/2022 2022-10-15 2022-10-15 6 333 2022-10-24 87 42 193 2 2096 16.02 2093 NULL NULL NULL 15.21 2093 NULL NULL NULL 45.00 54.00 Brown Check B/W NULL NULL 155.00 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 78 2022-10-24 NULL NULL NULL NULL NULL NULL
 
16 2093 NULL NULL NULL 16 2093 NULL NULL NULL 56.00 44.00 348 152.00 65.00 57 67.00 0.00 389 2022-10-24 NEW NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM fabric_analysis WHERE `fabric_analysis`.`fabanid` = 13
13 13/2022 2022-10-24 2022-10-24 1204 333 2022-10-24 87 4 159 1 39 36.72 39 NULL NULL NULL 37.19 39 NULL NULL NULL 70.00 140.00 Green A/W NULL NULL 145.00 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 78 2022-10-24 NULL NULL NULL NULL NULL NULL
 
30 37 NULL NULL NULL 30 37 NULL NULL NULL 120.00 62.00 2085 140.00 61.00 57 63.00 0.00 389 2022-10-25 NEW NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM fabric_analysis WHERE `fabric_analysis`.`fabanid` = 14
14 14/2022 2022-10-24 2022-10-25 170 388 2022-10-24 1 4 141 2 2084 17.48 2094 NULL NULL NULL 10.27 2094 NULL NULL NULL 50.00 84.00 As Swatch B/W NULL NULL 264.00 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 78 2022-10-24 NULL NULL NULL NULL NULL NULL
 
16 2094 NULL NULL NULL 10 2094 NULL NULL NULL 82.00 50.00 37 240.00 63.00 57 65.00 0.00 389 2022-10-24 NEW NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM fabric_analysis WHERE `fabric_analysis`.`fabanid` = 15
15 15/2022 2022-10-24 2022-10-25 170 388 2022-10-24 1 4 134 1 2084 16.28SL 2094 NULL NULL NULL 15.95 SL 2094 NULL NULL NULL 77.00 76.00 As Swatch B/W NULL NULL 267.00 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 78 2022-10-24 NULL NULL NULL NULL NULL NULL
 
16 sl 2094 NULL NULL NULL 16 sl 2094 NULL NULL NULL 74.00 74.00 37 230.00 65.00 57 67.00 0.00 389 2022-10-24 NEW NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM fabric_analysis WHERE `fabric_analysis`.`fabanid` = 16
16 16/2022 2022-10-24 2022-10-25 170 388 2022-10-24 1 4 142 1 2084 8.95 2094 NULL NULL NULL 10.77 2094 NULL NULL NULL 36.00 68.00 As Swatch A/W NULL NULL 293.00 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 78 2022-10-24 NULL NULL NULL NULL NULL NULL
 
7 2094 NULL NULL NULL 10 2094 NULL NULL NULL 60.00 36.00 37 285.00 61.00 57 63.00 0.00 389 2022-10-24 NEW NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM fabric_analysis WHERE `fabric_analysis`.`fabanid` = 17
17 17/2022 2022-10-24 2022-10-25 170 388 2022-10-24 1 4 142 1 2084 10.91 2094 NULL NULL NULL 7.45 2094 NULL NULL NULL 46.00 76.00 As Swatch A/W NULL NULL 335.00 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 78 2022-10-24 NULL NULL NULL NULL NULL NULL
 
10 2094 NULL NULL NULL 7 2094 NULL NULL NULL 70.00 46.00 37 310.00 61.00 57 63.00 0.00 389 2022-10-24 NEW NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM fabric_analysis WHERE `fabric_analysis`.`fabanid` = 18
18 18/2022 2022-10-24 2022-10-25 170 388 2022-10-24 1 4 141 1 2160 16.22 2094 NULL NULL NULL 11.54 2100 NULL NULL NULL 50.00 82.00 As Swatch A/W NULL NULL 244.00 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 78 2022-10-24 NULL NULL NULL NULL NULL NULL
 Warp blend 100% Cotton, Weft Cotton:Hemp 50:50
16 2094 NULL NULL NULL 10 2100 NULL NULL NULL 76.00 50.00 2160 230.00 63.00 57 65.00 0.00 389 2022-10-24 NEW NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM fabric_analysis WHERE `fabric_analysis`.`fabanid` = 19
19 19/2022 NULL NULL 2087 366 2022-10-24 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL REPEAT 66580
Edit Edit Copy Copy Delete Delete
DELETE FROM fabric_analysis WHERE `fabric_analysis`.`fabanid` = 20
20 20/2022 2024-10-20 2024-10-20 146 409 2022-10-24 1 4 159 2 40 5.31 2162 NULL NULL NULL 5.28 2162 NULL NULL NULL 24.00 30.00 Yarn Dyed A/W NULL NULL 260.00 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 78 2022-10-25
 
NULL NULL NULL NULL NULL
 
5 40 NULL NULL NULL 5 40 NULL NULL NULL 30.00 24.00 40 260.00 63.00 57 65.00 0.00 389 2022-10-25 NEW NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM fabric_analysis WHERE `fabric_analysis`.`fabanid` = 21
21 21/2022 2024-10-20 2024-10-20 146 409 2022-10-24 1 56 142 1 758 15.34 2094 NULL NULL NULL 6.65 2101 NULL NULL NULL 39.00 84.00 Solid A/W NULL NULL 306.00 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 78 2022-10-24 NULL NULL NULL NULL NULL NULL
 
14 2084 NULL NULL NULL 6 108 NULL NULL NULL 84.00 42.00 748 305.00 61.00 57 63.00 0.00 389 2022-10-25 NEW NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM fabric_analysis WHERE `fabric_analysis`.`fabanid` = 22
22 22/2022 2024-10-20 2024-10-20 146 409 2022-10-24 1 4 137 1 454 13.42 2093 NULL NULL NULL 12.45 2093 NULL NULL NULL 48.00 82.00 Solid A/W NULL NULL 268.00 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 78 2022-10-24 NULL NULL NULL NULL NULL NULL
 
12 511 NULL NULL NULL 12 511 NULL NULL NULL 84.00 50.00 511 262.00 61.00 57 63.00 0.00 389 2022-10-25 NEW NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM fabric_analysis WHERE `fabric_analysis`.`fabanid` = 23
23 23/2022 NULL NULL 2087 61 2022-10-24 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL REPEAT 65549
Edit Edit Copy Copy Delete Delete
DELETE FROM fabric_analysis WHERE `fabric_analysis`.`fabanid` = 24
24 24/2022 NULL NULL 2087 333 2022-10-24 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL REPEAT 53375
Edit Edit Copy Copy Delete Delete
DELETE FROM fabric_analysis WHERE `fabric_analysis`.`fabanid` = 25
25 25/2022 NULL NULL 2087 366 2022-10-24 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL REPEAT 66401
Edit Edit Copy Copy Delete Delete
DELETE FROM fabric_analysis WHERE `fabric_analysis`.`fabanid` = 26
26 26/2022 NULL NULL 2087 366 2022-10-24 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL REPEAT 67080
Edit Edit Copy Copy Delete Delete
DELETE FROM fabric_analysis WHERE `fabric_analysis`.`fabanid` = 27
27 27/2022 2022-10-24 2022-10-25 84 267 2022-10-24 87 4 138 1 2164 42.62 2094 NULL NULL NULL 88D+40D 2163 NULL NULL NULL 88.00 174.00 dark khaki B/W NULL NULL 152.00 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 78 2022-10-25
 
NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NEW NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM fabric_analysis WHERE `fabric_analysis`.`fabanid` = 28
28 28/2022 NULL NULL 2087 366 2022-10-24 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL REPEAT 67081
Edit Edit Copy Copy Delete Delete
DELETE FROM fabric_analysis WHERE `fabric_analysis`.`fabanid` = 29
29 29/2022 2022-10-24 2022-10-25 311 183 2022-10-24 5 2 137 1 1044 32.72 2094 NULL NULL NULL 21.6+70D 2110 NULL NULL NULL 76.00 177.00 Brown A/W NULL NULL 260.00 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 78 2022-10-25
 
NULL NULL NULL NULL NULL
 
32 2084 NULL NULL NULL 20+70D 2084 NULL NULL NULL 162.00 76.00 2084 230.00 71.00 56 74.50 0.00 389 2022-10-26 NEW NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM fabric_analysis WHERE `fabric_analysis`.`fabanid` = 30
30 30/2022 2022-10-24 2022-10-25 311 183 2022-10-24 5 4 142 1 1055 20.82 2094 NULL NULL NULL 21.0+70D 2110 NULL NULL NULL 53.00 158.00 Stone A/W NULL NULL 288.00 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 78 2022-10-25
 
NULL NULL NULL NULL NULL
 
20 2084 NULL NULL NULL 20+70D 1010 NULL NULL NULL 144.00 54.00 1052 257.00 71.00 54 74.50 0.00 389 2022-10-26 NEW NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM fabric_analysis WHERE `fabric_analysis`.`fabanid` = 31
31 31/2022 2022-10-24 2022-10-25 311 183 2022-10-24 5 2 137 1 2161 32.08 2094 NULL NULL NULL 21.67+70D 2110 NULL NULL NULL 76.00 170.00 OLIVE A/W NULL NULL 255.00 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 78 2022-10-25
 
NULL NULL NULL NULL NULL
 
32 2084 NULL NULL NULL 20+70D 1010 NULL NULL NULL 162.00 76.00 1052 230.00 71.00 56 74.50 0.00 389 2022-10-26 NEW NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM fabric_analysis WHERE `fabric_analysis`.`fabanid` = 32
32 32/2022 2022-10-24 2022-10-25 311 183 2022-10-24 5 2 137 1 1044 33.62 2094 NULL NULL NULL 20+70D 2110 NULL NULL NULL 76.00 177.00 BEIGE A/W NULL NULL 265.00 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 78 2022-10-25
 
NULL NULL NULL NULL NULL
 
32 2084 NULL NULL NULL 20+70D 1010 NULL NULL NULL 162.00 76.00 1052 230.00 71.00 56 74.50 0.00 389 2022-10-26 NEW NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM fabric_analysis WHERE `fabric_analysis`.`fabanid` = 33
33 33/2022 2022-10-24 2022-10-25 84 267 2022-10-24 87 4 137 1 511 19.74 2093 NULL NULL NULL 20.13 2093 NULL NULL NULL 54.00 111.00 navy B/W NULL NULL 198.00 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 78 2022-10-25
 
NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NEW NULL
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