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 `iomhangerinfo` ORDER BY `fab_com_new` DESC 
[ Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
Full texts ihid fbstid custcode hdate huser weight hwidth wtime wtemp hqty hqtym remarks gwid dg_ref gmt_ref fab_com_new Descending Ascending 1 orddid hncom_date hncom_user remarks_ncom gwid_com bfwelongation afwelongation bfwgrowth afwgrowth
Edit Edit Copy Copy Delete Delete
DELETE FROM iomhangerinfo WHERE `iomhangerinfo`.`ihid` = 223824
223824 152457 NULL NULL NULL B/W 297 GSM (- +5%) 55" 25 MIN 45°C 20 2.00 DEV001 25 NULL NULL 98% RECYCLED POLYESTER(POST) & 2% SPANDEX NULL 2023-05-21 261 Development 25 NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM iomhangerinfo WHERE `iomhangerinfo`.`ihid` = 223491
223491 153499 CARHART NULL NULL BW 268 GSM (+- 5%) 56" N/A N/A 5 2.00 COO1 12 NULL NULL 98% COTTON ,2% SPANDEX NULL NULL NULL NULL 12 NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM iomhangerinfo WHERE `iomhangerinfo`.`ihid` = 219885
219885 150127 NULL NULL NULL BW 236 GSM (+- 5%) 54" N/A N/A 30 10.00 DEVE01 12 NULL NULL 98% COTTON & 2% SAPNDEX NULL 2023-06-06 261 Kontoor 25 NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM iomhangerinfo WHERE `iomhangerinfo`.`ihid` = 222268
222268 152170 NULL NULL NULL B/W 250 GSM (+-5%) 56" 60 MIN 70°C 20 2.00 BRIX,COL:NAVY BLUE,ENZYME & SOFTENER 18 NULL NULL 98% BCI COTTON & 2% SPANDEX NULL NULL NULL NULL 18 NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM iomhangerinfo WHERE `iomhangerinfo`.`ihid` = 222377
222377 144439 NULL NULL NULL B/W 262 GSM (+-5%) 52" 25 MIN 45°C 20 2.00 MS07 25 NULL NULL 98% BCI COTTON & 2% SPANDEX NULL 2023-05-21 261 MS07 25 NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM iomhangerinfo WHERE `iomhangerinfo`.`ihid` = 224579
224579 162984 NEXT UK 2023-06-17 431 B/W 233 GSM (- +5%) 53" 25 MIN 45°C 4 2.00 NT01 25 NULL NULL 97% RECYCLED POLYESTER(POST) & 3% SPANDEX 192699 2023-07-04 261 Development 9 NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM iomhangerinfo WHERE `iomhangerinfo`.`ihid` = 218624
218624 127784 NULL NULL NULL B/W 146 GSM (+-5%) 57" 30 MIN 50°C 20 5.00 DEV001 25 NULL NULL 95% BCI COTTON & 5% RECYCLED COTTON (PRE) NULL NULL NULL NULL 25 NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM iomhangerinfo WHERE `iomhangerinfo`.`ihid` = 219653
219653 149603 NULL NULL NULL B/W 130 GSM (+-5%) 57" 10 MIN 40°C 20 2.00 C001 9 NULL NULL 95% BCI COTTON & 5% RECYCLED COTTON (PRE) NULL NULL NULL NULL 9 NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM iomhangerinfo WHERE `iomhangerinfo`.`ihid` = 213514
213514 142277 NULL NULL NULL B/W 204 GSM (+ -% ) 51" N/A N/A 50 10.00 OPTIMUM SOURCING INTL LTD. 12 NULL NULL 95% BCI COTTON & 5% RECYCLED COTTON (PRE) NULL 2023-07-05 261 Development 25 NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM iomhangerinfo WHERE `iomhangerinfo`.`ihid` = 220181
220181 149204 NULL NULL NULL B/W 110 GSM (+-5%) 57" 10 MIN 40°C 20 2.00 NONE 9 NULL NULL 95% BCI COTTON & 5% RECYCLED COTTON (PRE) NULL NULL NULL NULL 9 NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM iomhangerinfo WHERE `iomhangerinfo`.`ihid` = 219158
219158 147221 NULL NULL NULL B/W 121 GSM (+-5%) 57" 10 MIN 40°C 20 5.00 TOM02 9 NULL NULL 95% BCI COTTON & 5% RECYCLED COTTON (PRE) NULL NULL NULL NULL 9 NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM iomhangerinfo WHERE `iomhangerinfo`.`ihid` = 220192
220192 150117 NULL NULL NULL B/W 135 GSM (+-5%) 57" 10 MIN 40°C 20 2.00 NT01 9 NULL NULL 95% BCI COTTON & 5% RECYCLED COTTON (PRE) NULL NULL NULL NULL 9 NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM iomhangerinfo WHERE `iomhangerinfo`.`ihid` = 220960
220960 150634 NULL NULL NULL B/W 138 GSM (+-5%) 57" 10 MIN 40°C 20 2.00 GJ 9 NULL NULL 95% BCI COTTON & 5% RECYCLED COTTON (PRE) NULL NULL NULL NULL 9 NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM iomhangerinfo WHERE `iomhangerinfo`.`ihid` = 219183
219183 140963 NULL NULL NULL B/W 123 GSM (+-5%) 57" 10 MIN 40°C 20 5.00 VRG 9 NULL NULL 95% BCI COTTON & 5% RECYCLED COTTON (PRE) NULL NULL NULL NULL 9 NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM iomhangerinfo WHERE `iomhangerinfo`.`ihid` = 218941
218941 148765 NULL NULL NULL B/W 135 GSM (+-5%) 58" 30 MIN 50°C 20 5.00 NT01 25 NULL NULL 95% BCI COTTON & 5% RECYCLED COTTON (PRE) NULL NULL NULL NULL 25 NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM iomhangerinfo WHERE `iomhangerinfo`.`ihid` = 219724
219724 136205 NULL NULL NULL B/W 133 GSM (+-5%) 57" 10 MIN 40°C 20 2.00 NT01 9 NULL NULL 95% BCI COTTON & 5% RECYCLED COTTON (PRE) NULL NULL NULL NULL 9 NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM iomhangerinfo WHERE `iomhangerinfo`.`ihid` = 219725
219725 148307 NULL NULL NULL B/W 120 GSM (+-5%) 57" 10 MIN 40°C 20 2.00 H001 9 NULL NULL 95% BCI COTTON & 5% RECYCLED COTTON (PRE) NULL NULL NULL NULL 9 NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM iomhangerinfo WHERE `iomhangerinfo`.`ihid` = 224079
224079 161652 CARTERS 2023-05-21 431 B/W 112 GSM (- +5%) 57" 10 MIN 40°C 8 2.00 CAR01 9 NULL NULL 95% BCI COTTON & 5% RECYCLED COTTON (PRE) 192672 2023-07-16 261 Development 9 NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM iomhangerinfo WHERE `iomhangerinfo`.`ihid` = 221009
221009 150387 NULL NULL NULL B/W 136 GSM (+-5%) 57" 25 MIN 45°C 20 2.00 LI & FUNG 25 NULL NULL 95% BCI COTTON & 5% RECYCLED COTTON (PRE) NULL NULL NULL NULL 25 NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM iomhangerinfo WHERE `iomhangerinfo`.`ihid` = 218709
218709 138862 NULL NULL NULL B/W 123 GSM (+-5%) 57" 30 MIN 40°C 20 5.00 VRG .SA 9 NULL NULL 95% BCI COTTON & 5% RECYCLED COTTON (PRE) NULL NULL NULL NULL 9 NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM iomhangerinfo WHERE `iomhangerinfo`.`ihid` = 218710
218710 142532 NULL NULL NULL B/W 130 GSM (+-5%) 57" 10 MIN 40°C 20 5.00 KL10 9 NULL NULL 95% BCI COTTON & 5% RECYCLED COTTON (PRE) NULL NULL NULL NULL 9 NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM iomhangerinfo WHERE `iomhangerinfo`.`ihid` = 222551
222551 147663 NULL NULL NULL B/W 123 GSM (+-5%) 57" N/A N/A 20 2.00 CAR01 12 NULL NULL 95% BCI COTTON & 5% RECYCLED COTTON (PRE) NULL NULL NULL NULL 12 NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM iomhangerinfo WHERE `iomhangerinfo`.`ihid` = 218712
218712 145787 NULL NULL NULL B/W 126 GSM (+-5%) 57" 10 MIN 40°C 20 5.00 H001 9 NULL NULL 95% BCI COTTON & 5% RECYCLED COTTON (PRE) NULL NULL NULL NULL 9 NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM iomhangerinfo WHERE `iomhangerinfo`.`ihid` = 222553
222553 139245 NULL NULL NULL B/W 138 GSM (+-5%) 57" N/A N/A 20 2.00 C001 12 NULL NULL 95% BCI COTTON & 5% RECYCLED COTTON (PRE) NULL NULL NULL NULL 12 NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM iomhangerinfo WHERE `iomhangerinfo`.`ihid` = 218714
218714 146741 NULL NULL NULL B/W 119 GSM (+-5%) 57" 10 MIN 40°C 20 5.00 H001 9 NULL NULL 95% BCI COTTON & 5% RECYCLED COTTON (PRE) NULL NULL NULL NULL 9 NULL NULL NULL 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