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 `greigedemandrevise` ORDER BY `gdreqdate` ASC 
[ Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
Full texts rgdid gdid gdrevno gdjob buyid buycontract fabid gdprocess totalqty revgddate gddate gdreqdate Ascending Descending 1 gwidth fwidth cutwidth ggsm fgsm wrapyquality weftyquality warpcountprice weftcountprice market gdinspsystem gdnumbcolor spinst stid mmid mmdate srmmid srmmdate gmid gmdate enduseid ttenwarp ttenweft yarncolorno costappid costappdate
Edit Edit Copy Copy Delete Delete
DELETE FROM greigedemandrevise WHERE `greigedemandrevise`.`rgdid` = 1869
1869 3952 1 Li&Fung-3952/2013 60 Mr. Likhon 659 1 225000.00 2013-09-30 2013-08-21 0000-00-00 67.00 -1.00 51.00 0 NULL AC cw lycra core yarn 3.25 4.80 Export Export 2 NULL 3 58 2013-08-21 11 2013-08-21 4 2013-08-21 1 NULL NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM greigedemandrevise WHERE `greigedemandrevise`.`rgdid` = 1662
1662 3630 3 OBG-3630/2013 170 Mr.gias 203 1 107500.00 2013-08-03 2013-06-06 0000-00-00 61.00 57.00 56.00 0 NULL AC slub 3.25 4.00 Export Export 5 NULL 3 60 2013-06-06 8 2013-06-06 4 2013-06-06 1 NULL NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM greigedemandrevise WHERE `greigedemandrevise`.`rgdid` = 2766
2766 5426 2 LIANG-5426/2014 455 Mr.Farhad 1414 2 41840.00 2014-08-18 2014-06-18 0000-00-00 61.00 57.00 56.00 0 NULL AC(Home)Flanel AC(Home)Flanel 4.25 4.25 Export Export 2 NULL 3 18 2014-06-18 91 2014-06-18 95 2014-06-19 11 10N 10N NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM greigedemandrevise WHERE `greigedemandrevise`.`rgdid` = 1249
1249 3091 2 H&M-3091/2013 24 Mr.Bishwajit 692 1 150000.00 2013-03-18 2013-01-24 0000-00-00 61.00 57.00 56.00 0 NULL Combed AC 3.85 2.90 Export Export 1 NULL 3 18 2013-01-24 NULL NULL 4 2013-01-24 8 NULL NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM greigedemandrevise WHERE `greigedemandrevise`.`rgdid` = 1251
1251 3091 2 H&M-3091/2013 24 Mr.Bishwajit 692 1 150000.00 2013-03-19 2013-01-24 0000-00-00 61.00 57.00 56.00 0 NULL Combed AC 3.85 2.90 Export Export 1 NULL 3 18 2013-01-24 NULL NULL 4 2013-01-24 8 NULL NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM greigedemandrevise WHERE `greigedemandrevise`.`rgdid` = 6634
6634 12927 0 DUNNES-12927/2016 298 Mr. Ujjal 6943 2 2000.00 2016-11-20 2016-11-08 0000-00-00 61.00 57.00 56.00 0 NULL cw AC 3.95 2.20 Export Export 1 NULL 3 215 2016-11-08 94 2016-11-08 86 2016-11-09 9 20N 20N NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM greigedemandrevise WHERE `greigedemandrevise`.`rgdid` = 1519
1519 3630 1 OBG-3630/2013 170 Mr.gias 203 1 107500.00 2013-06-26 2013-06-06 0000-00-00 61.00 57.00 56.00 0 NULL AC slub 3.25 4.00 Export Export 5 NULL 3 60 2013-06-06 8 2013-06-06 4 2013-06-06 1 NULL NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM greigedemandrevise WHERE `greigedemandrevise`.`rgdid` = 1520
1520 3630 2 OBG-3630/2013 153 Mr.gias 203 1 107500.00 2013-06-26 2013-06-06 0000-00-00 61.00 57.00 56.00 0 NULL AC slub 3.25 4.00 Export Export 5 NULL 3 60 2013-06-06 8 2013-06-06 4 2013-06-06 1 NULL NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM greigedemandrevise WHERE `greigedemandrevise`.`rgdid` = 5618
5618 11057 1 SEARS-11057/201 540 mr. shorif 6295 2 8813.00 2016-04-28 2016-03-23 0000-00-00 67.00 52.00 50.00 130 NULL cw compact lycra core yarn 6.00 7.50 Export Export 2 NULL 3 158 2016-03-23 90 2016-03-24 95 2016-03-24 9 10N 10N NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM greigedemandrevise WHERE `greigedemandrevise`.`rgdid` = 1036
1036 1 0 KFS-1/2012 14 Lipu 6 1 5300.00 2013-01-15 2012-01-01 2012-01-30 61.00 57.50 56.00 0 NULL Combed Compact Combed compact 6.67 6.67 Export Export 1 NULL 3 5 2012-01-01 3 2012-01-01 2 2012-01-01 NULL NULL NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM greigedemandrevise WHERE `greigedemandrevise`.`rgdid` = 589
589 1 0 KFS-1/2012 14 Lipu 6 1 5300.00 2012-07-14 2012-01-01 2012-01-30 61.00 57.50 56.00 0 NULL Combed Compact Combed compact 6.67 6.67 Export Export 1 NULL 3 5 2012-01-01 3 2012-01-01 2 2012-01-01 NULL NULL NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM greigedemandrevise WHERE `greigedemandrevise`.`rgdid` = 590
590 2 0 HBC-2/2012 20 Mr. Shah Asikul Islam (George) 7 1 33372.00 2012-07-14 2012-01-02 2012-01-30 61.00 57.50 56.00 NULL NULL Combed Compact Combed Compact 5.30 5.30 Export Export 6 NULL 3 25 2012-01-02 8 2012-01-02 4 2012-01-03 NULL NULL NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM greigedemandrevise WHERE `greigedemandrevise`.`rgdid` = 184
184 41 0 H&M-41/2012 24 shawkat 27 1 300000.00 2012-04-05 2012-01-15 2012-01-30 61.00 58.00 56.00 NULL NULL CW compact CW compact 5.45 5.45 Export Export NULL NULL 3 36 2012-01-15 6 2012-01-15 4 2012-01-15 NULL NULL NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM greigedemandrevise WHERE `greigedemandrevise`.`rgdid` = 2492
2492 1 0 KFS-1/2012 14 Lipu 6 2 5400.00 2014-04-09 2012-01-01 2012-01-30 61.00 57.50 56.00 0 NULL Combed Compact Combed compact 6.67 6.67 Export Export 1 NULL 3 5 2012-01-01 3 2012-01-01 2 2012-01-01 8 NULL NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM greigedemandrevise WHERE `greigedemandrevise`.`rgdid` = 1004
1004 1 0 KFS-1/2012 14 Lipu 6 1 5300.00 2012-12-21 2012-01-01 2012-01-30 61.00 57.50 56.00 0 NULL Combed Compact Combed compact 6.67 6.67 Export Export 1 NULL 3 5 2012-01-01 3 2012-01-01 2 2012-01-01 NULL NULL NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM greigedemandrevise WHERE `greigedemandrevise`.`rgdid` = 524
524 20 0 CARREFOUR-20/2012 27 TOUFIQ 20 2 17220.00 2012-06-27 2012-01-08 2012-01-31 61.00 58.00 56.00 NULL NULL COMBED COMPACT COMBED COMPACT 7.50 7.50 Export Export 1 NULL 3 24 2012-01-08 7 2012-01-08 3 2012-01-08 NULL NULL NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM greigedemandrevise WHERE `greigedemandrevise`.`rgdid` = 334
334 52 0 Esprit-52/2012 22 ALi 40 1 10000.00 2012-05-08 2012-01-17 2012-01-31 61.00 58.00 56.00 0 NULL Combe compact Combe Compact 6.50 6.50 Export Export 2 NULL 3 30 2012-01-17 9 2012-01-17 4 2012-01-17 NULL NULL NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM greigedemandrevise WHERE `greigedemandrevise`.`rgdid` = 378
378 20 0 CARREFOUR-20/2012 27 TOUFIQ 20 2 17220.00 2012-05-16 2012-01-08 2012-01-31 61.00 58.00 56.00 NULL NULL COMBED COMPACT COMBED COMPACT 7.50 7.50 Export Export 1 NULL 3 24 2012-01-08 7 2012-01-08 3 2012-01-08 NULL NULL NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM greigedemandrevise WHERE `greigedemandrevise`.`rgdid` = 407
407 63 0 Next-63/2012 45 Rajin 48 1 200000.00 2012-05-23 2012-01-22 2012-01-31 61.00 58.00 56.00 0 NULL Ring combed comp Ring Combed Comp 4.85 4.35 Export Export 12 NULL 3 30 2012-01-22 NULL NULL 4 2012-01-22 NULL NULL NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM greigedemandrevise WHERE `greigedemandrevise`.`rgdid` = 332
332 22 0 H&M-22/2012 24 MOZAMMEL 11 1 100000.00 2012-05-08 2012-01-08 2012-02-10 61.00 58.00 56.00 NULL NULL COMBED COMPACT COMBED COMPACT 4.10 4.10 Export Export 10 NULL 3 24 2012-01-08 7 2012-01-08 3 2012-01-08 NULL NULL NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM greigedemandrevise WHERE `greigedemandrevise`.`rgdid` = 109
109 49 0 Richlu-49/2012 42 Toufiq 124 1 70000.00 2012-03-29 2012-01-17 2012-02-10 61.00 58.00 56.00 0 NULL AC AC 3.15 2.90 Export Export 5 NULL 3 20 2012-01-17 NULL NULL 3 2012-01-17 NULL NULL NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM greigedemandrevise WHERE `greigedemandrevise`.`rgdid` = 110
110 49 0 Richlu-49/2012 42 Toufiq 124 1 70000.00 2012-03-29 2012-01-17 2012-02-10 61.00 58.00 56.00 0 NULL AC AC 3.15 2.90 Export Export 5 NULL 3 20 2012-01-17 NULL NULL 3 2012-01-17 NULL NULL NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM greigedemandrevise WHERE `greigedemandrevise`.`rgdid` = 112
112 49 2 Richlu-49/2012 42 Toufiq 124 1 79125.00 2012-03-29 2012-01-17 2012-02-10 61.00 58.00 56.00 0 NULL AC AC 3.15 2.90 Export Export 5 NULL 3 20 2012-01-17 NULL NULL 3 2012-01-17 NULL NULL NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM greigedemandrevise WHERE `greigedemandrevise`.`rgdid` = 144
144 118 0 SSAL-118/2012 62 Mr. Sajed 67 1 1700.00 2012-03-31 2012-02-05 2012-02-10 61.00 58.00 56.00 NULL NULL AC AC 3.45 3.45 Export Export 2 NULL 3 5 2012-02-05 NULL NULL 2 2012-02-05 NULL NULL NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM greigedemandrevise WHERE `greigedemandrevise`.`rgdid` = 418
418 22 1 H&M-22/2012 24 MOZAMMEL 11 1 105000.00 2012-05-30 2012-01-08 2012-02-10 61.00 58.00 56.00 NULL NULL COMBED COMPACT COMBED COMPACT 4.10 4.10 Export Export 10 NULL 3 24 2012-01-08 7 2012-01-08 3 2012-01-08 NULL NULL 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