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 `greigercv` ORDER BY `grecvnot` DESC 
[ Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
Full texts grid gsid ppid pocid fabid userid plmid rcv_challan_no wmid ysupid entrydate greigelotno yarnlotno receive_date gr_prod_date receive_time grcvqty grecvnot Descending Ascending 1
Edit Edit Copy Copy Delete Delete
DELETE FROM greigercv WHERE `greigercv`.`grid` = 19301
19301 10560 7714 14253 847 144 12090 NULL 6 1 2014-12-20 NILL NILL 2014-12-20 NULL 22:00:00 1445.00 `
Edit Edit Copy Copy Delete Delete
DELETE FROM greigercv WHERE `greigercv`.`grid` = 42563
42563 29899 NULL NULL NULL 180 33694 NULL 7 1 2017-03-29 nill 04 2017-03-28 NULL 06:30:00 454.00 `
Edit Edit Copy Copy Delete Delete
DELETE FROM greigercv WHERE `greigercv`.`grid` = 14628
14628 6793 5550 9721 783 74 7474 NULL 5 9 2014-05-20 Nill Nill 2014-05-20 NULL 18:00:00 8051.00 y/d
Edit Edit Copy Copy Delete Delete
DELETE FROM greigercv WHERE `greigercv`.`grid` = 14595
14595 4283 4818 8101 61 73 4807 NULL 4 1 2014-05-19 Nill 15/13 2014-05-18 NULL 06:00:00 245.00 y/d
Edit Edit Copy Copy Delete Delete
DELETE FROM greigercv WHERE `greigercv`.`grid` = 14657
14657 6327 5502 9650 163 76 6912 NULL 6 4 2014-05-21 Nill Nill 2014-05-21 NULL 14:00:00 404.00 y/d
Edit Edit Copy Copy Delete Delete
DELETE FROM greigercv WHERE `greigercv`.`grid` = 14591
14591 6526 5680 10010 1414 73 7109 NULL 6 9 2014-05-19 Nill Nill 2014-05-19 NULL 06:01:00 16787.00 Y/D
Edit Edit Copy Copy Delete Delete
DELETE FROM greigercv WHERE `greigercv`.`grid` = 14593
14593 6788 5550 9720 783 74 7473 NULL 5 9 2014-05-19 Nill Nill 2014-05-18 NULL 20:00:00 8024.00 y/d
Edit Edit Copy Copy Delete Delete
DELETE FROM greigercv WHERE `greigercv`.`grid` = 14596
14596 6789 5501 9934 1516 73 7477 NULL 4 1 2014-05-19 Nill 15/13 2014-05-18 NULL 06:00:00 245.00 y/d
Edit Edit Copy Copy Delete Delete
DELETE FROM greigercv WHERE `greigercv`.`grid` = 14592
14592 6527 5680 10009 1414 73 7108 NULL 6 9 2014-05-19 Nill Nill 2014-05-19 NULL 07:01:00 6430.00 Y/D
Edit Edit Copy Copy Delete Delete
DELETE FROM greigercv WHERE `greigercv`.`grid` = 14627
14627 6788 5550 9720 783 74 7473 NULL 5 9 2014-05-20 Nill Nill 2014-05-20 NULL 18:00:00 8011.00 y/d
Edit Edit Copy Copy Delete Delete
DELETE FROM greigercv WHERE `greigercv`.`grid` = 20359
20359 11445 NULL NULL NULL 74 12730 NULL 6 1 2015-01-22 nill nill 2015-01-21 NULL 18:00:00 5518.00 Wo/11680-Change-12507
Edit Edit Copy Copy Delete Delete
DELETE FROM greigercv WHERE `greigercv`.`grid` = 18300
18300 9717 7126 13032 23 74 10580 NULL 11 9 2014-11-19 Nill 20 2014-11-18 NULL 18:00:00 18283.00 Wo-10666 Transfer Wo-10667
Edit Edit Copy Copy Delete Delete
DELETE FROM greigercv WHERE `greigercv`.`grid` = 32367
32367 21353 NULL NULL NULL 193 24267 NULL 13 1 2016-04-25 nill nill 2016-04-21 NULL 10:30:00 5230.00 w/o change
Edit Edit Copy Copy Delete Delete
DELETE FROM greigercv WHERE `greigercv`.`grid` = 32366
32366 21352 NULL NULL NULL 193 24269 NULL 13 1 2016-04-25 nill nill 2016-04-21 NULL 10:30:00 13570.00 w/o change
Edit Edit Copy Copy Delete Delete
DELETE FROM greigercv WHERE `greigercv`.`grid` = 20052
20052 11184 NULL NULL NULL 127 12549 NULL 10 1 2015-01-10 nill 350/350 2014-12-27 NULL 17:00:00 2508.00 Transfer others W/O
Edit Edit Copy Copy Delete Delete
DELETE FROM greigercv WHERE `greigercv`.`grid` = 20050
20050 11184 NULL NULL NULL 127 12549 NULL 10 1 2015-01-10 nill 350/350 2014-12-27 NULL 17:00:00 3662.00 Transfer others W/O
Edit Edit Copy Copy Delete Delete
DELETE FROM greigercv WHERE `greigercv`.`grid` = 23315
23315 13781 NULL NULL NULL 1 15406 NULL 4 1 2015-06-05 00 00 2015-06-05 NULL 13:01:00 0.50 tr from wo no 14948
Edit Edit Copy Copy Delete Delete
DELETE FROM greigercv WHERE `greigercv`.`grid` = 16221
16221 8014 6485 11568 11 74 8875 NULL 5 1 2014-08-30 NILL 26+26 2014-08-30 NULL 09:00:00 1541.00 Spinning mill nill
Edit Edit Copy Copy Delete Delete
DELETE FROM greigercv WHERE `greigercv`.`grid` = 16220
16220 8013 6510 11639 31 74 8870 NULL 13 1 2014-08-30 NILL 26/12 2014-08-30 NULL 09:00:00 14593.00 Spinning mill nill
Edit Edit Copy Copy Delete Delete
DELETE FROM greigercv WHERE `greigercv`.`grid` = 15510
15510 7455 5640 9941 1505 73 8108 NULL 4 2 2014-07-14 Nill 34/32 2014-07-13 NULL 19:00:00 315.00 shortfall
Edit Edit Copy Copy Delete Delete
DELETE FROM greigercv WHERE `greigercv`.`grid` = 15740
15740 7618 5880 10364 789 73 8206 NULL 4 1 2014-08-04 Nill Nill 2014-07-26 NULL 20:00:00 240.00 shortfall
Edit Edit Copy Copy Delete Delete
DELETE FROM greigercv WHERE `greigercv`.`grid` = 15738
15738 7617 5982 10582 1414 73 8233 NULL 4 8 2014-08-04 Nill Nill 2014-07-26 NULL 20:00:00 598.00 shortfall
Edit Edit Copy Copy Delete Delete
DELETE FROM greigercv WHERE `greigercv`.`grid` = 15568
15568 7499 5876 10356 12 73 8232 NULL 4 9 2014-07-17 Nill 11/14 2014-07-16 NULL 20:00:00 372.00 shortfall
Edit Edit Copy Copy Delete Delete
DELETE FROM greigercv WHERE `greigercv`.`grid` = 15150
15150 7186 5695 10039 1813 73 7850 NULL 4 2 2014-06-18 NILL 7+22/7 2014-06-18 NULL 18:00:00 194.00 Shortfall
Edit Edit Copy Copy Delete Delete
DELETE FROM greigercv WHERE `greigercv`.`grid` = 15546
15546 7484 6057 10725 731 73 8205 NULL 6 1 2014-07-16 Nill 19/19 2014-07-15 NULL 20:00:00 238.00 shortfall
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