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 `greigedemand` ORDER BY `elongation` ASC 
[ Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
Full texts gdid gdjob buyid buycontract fabid gdprocess totalqty gddate gdreqdate gwidth fwidth cutwidth ggsm fgsm wrapyquality weftyquality warpcountprice weftcountprice market gdinspsystem gdnumbcolor spinst stid mmid mmdate srmmid srmmdate gmid gmdate gdrevno enduseid addqty refno refdate pappid pappdate spappid spappdate ttenwarp ttenweft yarncolorno costappid costappdate iomref unitid pisellprice gdsid ownerid acholder weft_yarnid warp_yarnid epi gepi ppi gdproceed_by gd_proceed_date ctnper subid sub_buyid sub_brid fab_cost emarid elongation Ascending Descending 1 growth recovery tensile_warp tensile_weft
Edit Edit Copy Copy Delete Delete
DELETE FROM greigedemand WHERE `greigedemand`.`gdid` = 256
256 H&M-256/2012 24 Jhony 168 1 1850.00 2012-03-05 2012-03-22 61.00 58.00 56.00 0 199 AC AC 3.50 3.50 Export Export 1 <p><strong><span style="font-size: medium;">GD nee... 5 21 2012-03-05 NULL NULL 2 2012-03-05 2 NULL 0.00 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 2 NULL 0 NULL 2 NULL NULL NULL NULL NULL NULL NULL NULL NULL 30 54 0.00 NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM greigedemand WHERE `greigedemand`.`gdid` = 512
512 Yagi-512/2012 54 Raju 168 1 0.00 2012-04-16 2012-05-05 0.00 0.00 0.00 0 0 0 0 0.00 0.00 Export Export 0 <p><strong><span style="font-size: medium;">Cancel... 5 35 2012-04-16 10 2012-04-16 3 2012-04-17 1 7 0.00 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 5 NULL 0 003504100010040800030405 3 NULL NULL NULL NULL NULL NULL NULL NULL NULL 30 54 0.00 NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM greigedemand WHERE `greigedemand`.`gdid` = 768
768 LW-768/2012 214 Mr. Rashed 49 1 8600.00 2012-07-09 2012-07-15 61.00 57.00 56.00 160 170 30 30 4.30 4.30 Export Export 3 NULL 5 13 2012-07-09 NULL NULL 4 2012-07-10 NULL 1 0.00 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 2 NULL 0 NULL 4 NULL NULL NULL NULL NULL NULL NULL NULL NULL 30 54 0.00 NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM greigedemand WHERE `greigedemand`.`gdid` = 1280
1280 HEMA-1280/2012 129 MR. MATIN 62 2 4650.00 2012-11-04 2012-11-30 61.00 57.00 56.00 0 215 20 20 5.26 5.26 Export Export 5 <p>PLEASE FOLLOW IOM # 2488/2012 NOMAN TEXTILE ,DA... 5 32 2012-11-04 NULL NULL 4 2012-11-04 NULL 3 0.00 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 2 NULL 0 NULL 4 NULL NULL NULL NULL NULL NULL NULL NULL NULL 30 54 0.00 NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM greigedemand WHERE `greigedemand`.`gdid` = 3072
3072 LS-3072/2013 21 sajjad 642 2 4400.00 2013-01-19 2013-02-28 63.00 57.00 56.00 170 170 CW Compact AC 6.67 5.25 Export Export 1 <p style="text-align: center;"><span style="font-s... 5 26 2013-01-19 NULL NULL 3 2013-01-19 NULL 9 8.00 2012/11/YP-12024 2012-11-19 43 2013-01-19 00:00:00 49 2013-01-20 NULL NULL NULL NULL NULL NULL 1 NULL 0 NULL 3 NULL NULL NULL NULL NULL NULL NULL NULL NULL 30 54 0.00 NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM greigedemand WHERE `greigedemand`.`gdid` = 3328
3328 H&M-3328/2013 24 Mr. Sazzad 308 2 60942.00 2013-03-19 2013-04-03 62.00 58.00 56.00 0 130 KW (Ring) KW (Ring) 6.41 6.41 Export Export 1 <p>1. Please MaintainH&amp;M standard strictly.</p... 5 36 2013-03-19 6 2013-03-20 4 2013-03-20 NULL 10 8.00 2012/11/YP/12024 2012-11-19 43 2013-03-21 00:00:00 66 2013-03-23 NULL NULL NULL NULL NULL NULL 5 NULL 0 003604100006041100040405 4 NULL NULL NULL NULL NULL NULL NULL NULL NULL 30 54 0.00 NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM greigedemand WHERE `greigedemand`.`gdid` = 3584
3584 Newlook-3584/2013 239 Morshed 27 3 9280.00 2013-05-27 2013-08-31 64.00 58.00 56.00 0 0 40 40 4.95 4.95 Export Export 2 <p><span style="font-size: medium;"><span style="b... 5 16 2013-05-27 10 2013-05-27 4 2013-05-28 1 4 12.00 NG/YP-13027 2013-06-09 43 2013-08-29 00:00:00 66 2013-08-29 NULL NULL NULL NULL NULL NULL 3 NULL 0 001604090010040800040405 4 NULL NULL NULL NULL NULL NULL NULL NULL NULL 30 54 0.00 NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM greigedemand WHERE `greigedemand`.`gdid` = 3840
3840 Brandex-3840/2013 53 Mr. Ranga 154 1 44494.00 2013-07-26 2013-08-10 61.00 58.00 56.00 0 275 AC AC 3.05 2.80 Export Export 1 <h3><span style="font-family: Verdana;"><span styl... 5 22 2013-07-26 7 2013-07-26 3 2013-07-26 1 10 8.00 NG/YP-13027 2013-06-09 43 2013-08-01 00:00:00 66 2013-08-01 NULL NULL NULL NULL NULL NULL 5 NULL 0 002204090007040700030405 3 NULL NULL NULL NULL NULL NULL NULL NULL NULL 30 54 0.00 NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM greigedemand WHERE `greigedemand`.`gdid` = 4096
4096 ALBION-4096/2013 376 Mr. Clare 902 2 4088.00 2013-09-12 2013-09-26 61.00 57.00 56.00 0 190 30/CW 30/CW 6.36 6.36 Export Export 1 NULL 5 22 2013-09-12 7 2013-09-12 3 2013-09-12 NULL 10 3.00 NG/YP-13027 2013-06-09 43 2013-09-13 00:00:00 66 2013-09-14 NULL NULL NULL NULL NULL NULL 5 NULL 0 002204090007040700030405 3 NULL NULL NULL NULL NULL NULL NULL NULL NULL 30 54 0.00 NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM greigedemand WHERE `greigedemand`.`gdid` = 4352
4352 RUDDER-4352/2013 387 Mr.Monti 977 1 19680.00 2013-10-24 2013-11-12 61.00 57.00 56.00 245 245 AC AC 3.10 2.90 Export Export 6 <p><strong><span style="font-size: medium;"><span ... 5 88 2013-10-24 90 2013-10-24 95 2013-10-24 2 9 12.00 NG/YP-13029 2013-09-25 43 2013-10-31 00:00:00 66 2013-10-31 NULL NULL NULL NULL NULL NULL 5 NULL 0 003504090010040700040404 95 NULL NULL NULL NULL NULL NULL NULL NULL NULL 30 54 0.00 NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM greigedemand WHERE `greigedemand`.`gdid` = 4608
4608 Esprit-4608/2013 22 MR. NAIMUL 201 4 8612.00 2013-12-07 2013-12-31 61.00 57.00 56.00 0 300 AUTO CORO AUTO CORO 2.95 2.70 Export Export 1 <p><span style="font-size: large;"><span style="ba... 5 102 2013-12-07 93 2013-12-07 95 2013-12-07 1 10 4.00 NG/YP-13029 2013-09-25 43 2013-12-10 00:00:00 111 2013-12-11 NULL NULL NULL NULL NULL NULL 5 NULL 0 003004080009040600040404 95 NULL NULL NULL NULL NULL NULL NULL NULL NULL 30 54 0.00 NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM greigedemand WHERE `greigedemand`.`gdid` = 4864
4864 PULL& BEAR-4864/2014 131 Mr. Iqbal 484 4 14200.00 2014-02-15 2014-03-05 65.00 54.00 53.00 0 330 AC Lycra Core Yarn 3.10 5.10 Export Export 1 <p><strong><span style="font-size: large;"><span s... 5 101 2014-02-15 92 2014-02-17 86 2014-02-17 1 1 12.00 NG/YP-1403 2014-01-11 117 2014-02-24 00:00:00 111 2014-02-24 NULL NULL NULL NULL NULL NULL 5 NULL 0 002004070007040600030404 86 NULL NULL NULL NULL NULL NULL NULL NULL NULL 30 54 0.00 NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM greigedemand WHERE `greigedemand`.`gdid` = 5120
5120 H&M-5120/2014 24 Saif 1087 2 6200.00 2014-04-09 2014-04-20 61.00 57.00 56.00 0 132 CW Compact KW Compact 5.90 5.30 Export Export 1 <p>1. Please maintain H&amp;M standard strictly.</... 5 103 2014-04-09 98 2014-04-09 95 2014-04-09 NULL 9 3.00 NG/YP/1403 2014-01-11 117 2014-04-09 00:00:00 125 2014-04-10 10 10 NULL NULL NULL NULL 5 NULL 0 003604090006040600040404 95 NULL NULL NULL NULL NULL NULL NULL NULL NULL 30 54 0.00 NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM greigedemand WHERE `greigedemand`.`gdid` = 5376
5376 Berne-5376/2014 84 mr. shohidul 155 1 6000.00 2014-06-05 2014-06-08 61.00 57.00 56.00 0 350 AC ( fashion ) ac (  fashion) 2.55 2.35 Export Export 2 <p>dear Mr. Roman .</p>
<p>pls issue greige fabri...
5 25 2014-06-05 94 2014-06-06 95 2014-06-06 NULL 10 12.00 NG/YP-1403 2014-01-11 117 2014-06-07 00:00:00 125 2014-06-09 20 15 N NULL NULL NULL NULL 5 NULL 0 002504090008040600040404 95 NULL NULL NULL NULL NULL NULL NULL NULL NULL 30 54 0.00 NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM greigedemand WHERE `greigedemand`.`gdid` = 5632
5632 TOP-5632/2014 15 Mr. mehedi 730 1 11299.00 2014-07-24 2014-08-10 61.00 57.00 56.00 0 170 KW (Fashion) KW (Fashion) 3.70 3.70 Export Export 3 NULL 5 101 2014-07-24 92 2014-07-24 86 2014-07-25 NULL 10 10.00 NG/YP-1406 2014-06-16 117 2014-07-25 00:00:00 125 2014-08-02 12 12 NULL NULL NULL NULL 5 NULL 0 002004070007040600030404 86 NULL NULL NULL NULL NULL NULL NULL NULL NULL 30 54 0.00 NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM greigedemand WHERE `greigedemand`.`gdid` = 5888
5888 ALCOTT-5888/2014 537 Anu 1903 3 8408.00 2014-08-24 2014-09-05 67.00 52.00 51.00 350 350 10 Slub 12 KW Lycra CoreYarn 4.40 2.70 Export Export 2 NULL 5 89 2014-08-24 93 2014-08-25 95 2014-08-25 NULL 14 15.00 NULL NULL 117 2014-08-25 00:00:00 NULL NULL 18 N 350 n 18n 350 n NULL NULL NULL NULL 5 NULL 0 001604060009040600040404 95 NULL NULL NULL NULL NULL NULL NULL NULL NULL 30 54 0.00 NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM greigedemand WHERE `greigedemand`.`gdid` = 6144
6144 Esprit-6144/2014 22 MR. TONMOY 415 2 540.00 2014-09-17 2014-09-30 61.00 57.00 56.00 0 195 KW COMPACT (FASHION) KW COMPACT (FASHION) 5.00 5.00 Export Export 3 <p><span style="font-size: large;"><strong>NO NEED... 5 102 2014-09-17 93 2014-09-17 95 2014-09-17 NULL 10 25.00 NG/YP-1409 2014-09-07 117 2014-09-18 00:00:00 125 2014-10-09 10N 10N NULL NULL NULL NULL 5 NULL 0 003004080009040600040404 95 NULL NULL NULL NULL NULL NULL NULL NULL NULL 30 54 0.00 NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM greigedemand WHERE `greigedemand`.`gdid` = 6400
6400 BestSeller-6400/2014 115 MR. PONIR/ MR. NAJIBUR 1925 3 4080.00 2014-10-21 2014-10-30 61.00 57.00 56.00 0 241 KW ( fashion ) KW ( fashion) 3.05 2.90 Export Export 4 <p>PLS FOLLOW SAME AS QUALITY REG GD NO 6200/2014 ... 5 25 2014-10-21 94 2014-10-21 95 2014-10-22 NULL 10 20.00 NG/YP-1411 2014-10-14 117 2014-10-22 00:00:00 125 2014-10-27 16 N 16 N NULL NULL NULL NULL 5 NULL 0 002504090008040600040404 95 NULL NULL NULL NULL NULL NULL NULL NULL NULL 30 54 0.00 NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM greigedemand WHERE `greigedemand`.`gdid` = 6656
6656 H&M-6656/2014 24 Mosharraf 1778 2 61450.00 2014-11-14 2014-11-30 61.00 57.00 56.00 0 132 CW (Fashion) CW (Fashion) 5.15 5.15 Export Export 1 <p>1. Please maintain H&amp;M standard strictly.</... 5 103 2014-11-14 98 2014-11-14 95 2014-11-15 NULL 9 5.00 NULL NULL 117 2014-11-15 00:00:00 NULL NULL 20 20 NULL NULL NULL NULL 5 NULL 0 003604090006040600040404 95 NULL NULL NULL NULL NULL NULL NULL NULL NULL 30 54 0.00 NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM greigedemand WHERE `greigedemand`.`gdid` = 6912
6912 SEARS-6912/2014 540 Vijay 1005 2 13590.00 2014-12-18 2015-01-05 61.00 58.00 56.00 145 145 20 KW Fashion 20 KW Fashion 3.25 3.25 Export Export 1 <h1><span style="background-color: rgb(255, 255, 0... 5 89 2014-12-18 93 2014-12-18 95 2014-12-18 NULL 9 5.00 NULL NULL 117 2014-12-19 00:00:00 NULL NULL 12 n 350 12 n 350 NULL NULL NULL NULL 5 NULL 0 001604060009040600040404 95 NULL NULL NULL NULL NULL NULL NULL NULL NULL 30 54 0.00 NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM greigedemand WHERE `greigedemand`.`gdid` = 7168
7168 Tema-7168/2015 40 Mr. Jony 2850 2 8960.00 2015-01-20 2015-02-05 61.00 57.00 56.00 0 140 AC (Fashion) AC (Fashion) 4.05 4.05 Export Export 1 NULL 5 101 2015-01-20 92 2015-01-21 86 2015-01-21 NULL 9 5.00 NULL NULL 117 2015-01-21 00:00:00 NULL NULL 20 20 NULL NULL NULL NULL 5 NULL 0 002004070007040600030404 86 NULL NULL NULL NULL NULL NULL NULL NULL NULL 30 54 0.00 NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM greigedemand WHERE `greigedemand`.`gdid` = 7424
7424 GYMBOREE-7424/2015 520 Liton 163 2 1100.00 2015-02-23 2015-03-25 61.00 57.00 56.00 125 125 40 CW Fashion 40 CW Fashion 5.55 5.25 Export Export 1 NULL 5 89 2015-02-23 93 2015-02-24 95 2015-02-24 NULL 7 10.00 NULL NULL 117 2015-02-24 00:00:00 NULL NULL 14 n 350 kg 14 N 350 KG NULL NULL NULL NULL 5 NULL 0 001604060009040600040404 95 NULL NULL NULL NULL NULL NULL NULL NULL NULL 30 54 0.00 NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM greigedemand WHERE `greigedemand`.`gdid` = 7680
7680 Miles-7680/2015 114 Ms Rumi 142 1 1103.00 2015-03-20 2015-04-10 63.00 57.00 56.00 0 110 40/CW 40/CW 4.00 4.00 Export Export 2 NULL 5 100 2015-03-20 97 2015-03-20 86 2015-03-21 NULL 13 35.00 NULL NULL 117 2015-03-21 00:00:00 NULL NULL 10/N 10/N NULL NULL NULL NULL 5 NULL 0 002204080041040500030404 86 NULL NULL NULL NULL NULL NULL NULL NULL NULL 30 54 0.00 NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM greigedemand WHERE `greigedemand`.`gdid` = 7936
7936 H&M-7936/2015 24 Rokib 27 1 200000.00 2015-04-21 2015-05-31 61.00 57.00 56.00 0 122 CW (Fashion) CW (Fashion) 4.00 4.00 Export Export 7 <p>1. Pls maintain H&amp;M&nbsp;standard strictly.... 5 103 2015-04-21 98 2015-04-21 95 2015-04-21 NULL 12 4.00 NULL NULL 117 2015-04-22 00:00:00 NULL NULL 15 15 NULL NULL NULL NULL 5 NULL 0 003604090006040600040404 95 NULL NULL NULL NULL NULL NULL NULL NULL NULL 30 54 0.00 NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM greigedemand WHERE `greigedemand`.`gdid` = 8192
8192 H&M-8192/2015 24 Mr. Azir 27 1 28900.00 2015-05-26 2015-06-01 61.00 57.00 56.00 0 115 CW(Fashion) CW(Fashion) 4.00 4.00 Export Export 1 NULL 5 162 2015-05-26 98 2015-05-27 95 2015-05-27 NULL 7 4.00 NULL NULL 117 2015-05-27 00:00:00 NULL NULL 15 15 NULL NULL NULL NULL 5 NULL 0 005904090006040600040404 95 NULL NULL NULL NULL NULL NULL NULL NULL NULL 30 54 0.00 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