将文件拖动至此

SQL 上传 ( 0 ) x -

页面相关设置 点击以滚动到页面顶部
按 Ctrl+Enter 键执行查询 按 Enter 执行查询
递增排序
递减排序
命令:
调试 SQL
数量
运行顺序
用时
排序条件:
联合查询
不使用联合查询
崩溃 扩展 显示跟踪 隐藏跟踪 数量 : 用时 :
书签
刷新
添加
没有书签
添加书签
选项
恢复默认





崩溃 扩展 重新查询 编辑 解析 性能分析 书签 查询失败 数据库 : 查询时间 :
浏览模式
自定义浏览模式。
浏览模式
文档 仅使用图标、文字或都使用。 还原为默认值
文档 仅使用图标、文字或都使用。 还原为默认值
文档 设置是否给用户显示一个 "显示所有 (记录)" 的按钮。 还原为默认值
文档 浏览结果集时显示的行数。若结果集总行数超过该值,将会显示 "上一页" 和 "下一页" 的链接。 还原为默认值
文档 SMART - 即对 TIME、DATE、DATETIME 和 TIMESTAMP 类型的字段递减排序,其它字段递增。 还原为默认值
文档 高亮鼠标指针所在的行。 还原为默认值
文档 高亮选中的行。 还原为默认值
文档 还原为默认值
文档 还原为默认值
文档 每 X 单元格重复表头,要禁止此功能请设为 0 还原为默认值
文档 浏览非数字字段时最多显示的字数。 还原为默认值
文档 这些是编辑、复制和删除链接。 还原为默认值
文档 缺少唯一键时是否显示行链接。 还原为默认值
文档 默认用主键为表排序。 还原为默认值
文档 当浏览表时使用上次的排序方式。 还原为默认值
文档 显示选项 还原为默认值
SELECT * FROM `IOP_Stock_Final_Info`
编辑内嵌 ] [ 编辑 ] [ 解析 SQL ] [ 创建 PHP 代码 ] [ 刷新 ]
IOM No Rack No Color way Composition Weave Construction Fabric process Buyer Fabric finish Emarizing GSM Roll qty CURRENT STOCK QTY
56473/2021 1 Black & White check 72% BCI COTTON, 5% RECYCLED COTTON(PRE), 20% TENCE... 2/2 S TWILL 16X16+70D/84X70 YARN DYED AMERICAN EAGLE REGULAR SOFT CARBON PEACH 283 1 50
56473/2021 1 Pamela Plaid CW8 72% BCI COTTON, 5% RECYCLED COTTON(PRE), 20% TENCE... 2/2 S TWILL 16X16+70D/84X70 YARN DYED AMERICAN EAGLE REGULAR SOFT CARBON PEACH 290 1 30
60413/2021 1 Grey Check 97% COTTON & 3% SPANDEX 2/2 Z TWILL 30/2X16+70D/90X70 YARN DYED PM SOURCING LTD SOFT CARBON PEACH 210 1 10
61002/2021 1 Chambray (As per swatch) 65% POLYESTER & 35% BCI COTTON 1/1 PLAIN 45X45/110X76 YARN DYED H&M SOFT Non Peach 108 1 10
61572/2021 1 as per swatch 100% BCI COTTON TWILL 2/2 S TWILL 20X20/68X60 YARN DYED MARKS AND SPENCER SOFT BOTH SIDE BRUSH 165 1 10
63695/2022 1 WHITE 100% COTTON OXFORD CANVAS OXFORD CANVAS (40+40)X30/2/108X50 YARN DYED TIFFOSI REGULAR SOFT Non Peach 147 1 12
64339/2022 1 085220_MINI FLAG_FEDERAL BLUE 100% CONVENTIONAL COTTON 1/1 PLAIN 40X32/100X76 PIGMENT PRINT ON YARN DYED THE CHILDRENS PLACE INC/ SOFT Non Peach 112 1 50
64960/2022 1 S23SNM403A TRI BOLD STRIPE KAHKI 55% LINEN & 45% CONVENTIONAL COTTON 1/1 PLAIN 10X10/52X40 YARN DYED KOHLS REGULAR SOFT Non Peach 209 1 9
65026/2022 1 TAN DESERT 100% COTTON CANVAS 1/1 PLAIN 20X20/72X56 YARN DYED NONE REGULAR SOFT Non Peach 155 1 50
65754/2022 1 Chinchilla 17-1109 TCX 70% POLYESTER & 30% BCI COTTON 2/2 S TWILL 12/2X12/2/58X44 YARN DYED BEST SELLER LTD/ FACE SIDE BRUSH FACE SIDE BRUSH 457 1 15
65835/2022 1 Dark Sapphire YD 100% ORGANIC COTTON 2/2 Z TWILL 20X20/84X68 YARN DYED VF ASIA LTD/ SOFT BOTH SIDE BRUSH 190 1 30
65835/2022 1 Trellis YD 100% ORGANIC COTTON 2/2 Z TWILL 20X20/84X68 YARN DYED VF ASIA LTD/ SOFT BOTH SIDE BRUSH 184 1 20
65856/2022 1 Any color 80% BCI COTTON & 20% RECYCLED COTTON(PRE) 2/2 Z TWILL 10X10/48X44 YARN DYED H&M SOFT BOTH SIDE BRUSH 242 1 15
65856/2022 1 Any color 80% BCI COTTON & 20% RECYCLED COTTON(PRE) 2/2 Z TWILL 10X10/48X44 YARN DYED H&M SOFT BOTH SIDE BRUSH 239 1 10
65963/2022 1 Black/yellow 55% BCI COTTON & 45% VISCOSE 2/2 Z TWILL 21X21/80X60 YARN DYED WALMART REGULAR BOTH SIDE BRUSH 185 1 15
66213/2022 1 Slate Gray (16-5804 TCX) 100% BCI COTTON OXFORD (40/2+40/2)X18/90X40 YARN DYED C&A REGULAR PEACH FINISH 155 1 50
66395/2022 1 Green Stone Combo 100% BCI COTTON 2/2 S TWILL 16SX16S/56X44 YARN DYED WALMART SOFT FACE SIDE BRUSH 153 1 15
66395/2022 1 Rich Red Mimosa Combo 100% BCI COTTON 2/2 S TWILL 16SX16S/56X44 YARN DYED WALMART SOFT FACE SIDE BRUSH 150 1 10
66397/2022 1 Black Soot Combo 100% BCI COTTON 2/2 S TWILL 16SX16S/56X44 YARN DYED WALMART SOFT FACE SIDE BRUSH 152 1 10
66397/2022 1 Orange Brick Combo 100% BCI COTTON 2/2 S TWILL 16SX16S/56X44 YARN DYED WALMART SOFT FACE SIDE BRUSH 151 1 15
66576/2022 1 BLUE STRIPE//AIRO 100% BCI COTTON OXFORD (40+40)X20/2/100X48 YARN DYED RALPH LAUREN SOFT Non Peach 185 1 30
66576/2022 1 BLUE STRIPE //SOFT 100% BCI COTTON OXFORD (40+40)X20/2/100X48 YARN DYED RALPH LAUREN SOFT Non Peach 173 1 24
67998/2023 1 As per swatch 100% BCI COTTON 3/1 Z TWILL 16X16/56X56 YARN DYED VF ASIA LTD/ REGULAR BOTH SIDE BRUSH 161 1 24
54277/2020 1 Arnell Plaid(As swatch) 55% COTTON & 45% POLYESTER 2/2 Z TWILL (16+16)X(16+16)/66X58 YARN DYED RALPH LAUREN SOFT BOTH SIDE BRUSH 202 1 15
68077/2023 1 GD-24181 75% BCI COTTON & 25% RECYCLED COTTON (PRE) OXFORD (40+40)X30/2/100X50 YARN DYED LEFTIES SOFT Non Peach 136 1 9
查询结果操作 复制到剪贴板 复制到剪贴板 导出 导出 显示图表 显示图表 新建视图 新建视图
将此 SQL 查询加为书签 将此 SQL 查询加为书签