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 `menuproduct` ORDER BY `mpname` DESC 
[ Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
Full texts mpid mcid mpname Descending Ascending 1 mplink mpnotes mppops
Edit Edit Copy Copy Delete Delete
DELETE FROM menuproduct WHERE `menuproduct`.`mpid` = 146
146 16 Yarn Price yarnpricedetial.php Yarn Price Detail N
Edit Edit Copy Copy Delete Delete
DELETE FROM menuproduct WHERE `menuproduct`.`mpid` = 121
121 14 Weekly PI Space wkspbook.php Weekly PI Space Lock N
Edit Edit Copy Copy Delete Delete
DELETE FROM menuproduct WHERE `menuproduct`.`mpid` = 101
101 13 Weaving Mill Details weavemilldetails.php Weaving Mill Details N
Edit Edit Copy Copy Delete Delete
DELETE FROM menuproduct WHERE `menuproduct`.`mpid` = 89
89 6 W/O Detail planexplore.php Eplore Planning N
Edit Edit Copy Copy Delete Delete
DELETE FROM menuproduct WHERE `menuproduct`.`mpid` = 181
181 1 Visit Report visitreport.php Visitor Report N
Edit Edit Copy Copy Delete Delete
DELETE FROM menuproduct WHERE `menuproduct`.`mpid` = 60
60 13 User System userdata.php User Management N
Edit Edit Copy Copy Delete Delete
DELETE FROM menuproduct WHERE `menuproduct`.`mpid` = 166
166 13 User Management usrmgt.php User Permission N
Edit Edit Copy Copy Delete Delete
DELETE FROM menuproduct WHERE `menuproduct`.`mpid` = 107
107 13 Unit Wise PI Approval unitpirange.php Unit Wise Monthly PI Approval N
Edit Edit Copy Copy Delete Delete
DELETE FROM menuproduct WHERE `menuproduct`.`mpid` = 94
94 13 Unit Management unitdetails.php Unit Details N
Edit Edit Copy Copy Delete Delete
DELETE FROM menuproduct WHERE `menuproduct`.`mpid` = 165
165 6 TNA znz_tna/tna_process.php Time and Action Plan N
Edit Edit Copy Copy Delete Delete
DELETE FROM menuproduct WHERE `menuproduct`.`mpid` = 113
113 14 Team Capacity spgdetail.php Monthly Teamwise Capacity N
Edit Edit Copy Copy Delete Delete
DELETE FROM menuproduct WHERE `menuproduct`.`mpid` = 180
180 4 Split PI Info ./piinfo_block_info_split.php Split PI Info N
Edit Edit Copy Copy Delete Delete
DELETE FROM menuproduct WHERE `menuproduct`.`mpid` = 97
97 13 Spinning Unit Information yarnsupplierinfo.php Spinning Unit Information N
Edit Edit Copy Copy Delete Delete
DELETE FROM menuproduct WHERE `menuproduct`.`mpid` = 151
151 14 Space Lock PO spbookpo.php PO Wise Space Book N
Edit Edit Copy Copy Delete Delete
DELETE FROM menuproduct WHERE `menuproduct`.`mpid` = 28
28 14 Space Lock PI spbook.php PI Wise Space Book N
Edit Edit Copy Copy Delete Delete
DELETE FROM menuproduct WHERE `menuproduct`.`mpid` = 162
162 15 Search IOM iom_search.php IOM Search N
Edit Edit Copy Copy Delete Delete
DELETE FROM menuproduct WHERE `menuproduct`.`mpid` = 169
169 2 Search GD All greigedemand_searches_m.php Date Wise GD Search N
Edit Edit Copy Copy Delete Delete
DELETE FROM menuproduct WHERE `menuproduct`.`mpid` = 168
168 2 Search GD greigedemand_searches.php Date Wise GD Search N
Edit Edit Copy Copy Delete Delete
DELETE FROM menuproduct WHERE `menuproduct`.`mpid` = 175
175 15 Search Barcode Sticker iop_hanger_details.php Search Barcode Sticker N
Edit Edit Copy Copy Delete Delete
DELETE FROM menuproduct WHERE `menuproduct`.`mpid` = 136
136 15 Sample Request Group Report iomordergroup.php Sample Request Group Report N
Edit Edit Copy Copy Delete Delete
DELETE FROM menuproduct WHERE `menuproduct`.`mpid` = 135
135 15 Sample Request Followup(New) iomorderfollowup.php Sample Request Followup(New) N
Edit Edit Copy Copy Delete Delete
DELETE FROM menuproduct WHERE `menuproduct`.`mpid` = 132
132 15 Sample Request Approve(OLD) iomorderindexold.php Sample Request Approve(OLD) N
Edit Edit Copy Copy Delete Delete
DELETE FROM menuproduct WHERE `menuproduct`.`mpid` = 126
126 15 Sample Request Approve (NEW) iomorderindex.php Sample Request Approve (NEW) N
Edit Edit Copy Copy Delete Delete
DELETE FROM menuproduct WHERE `menuproduct`.`mpid` = 129
129 15 Sample Request (OLD) iomorderold.php Sample Request (OLD) N
Edit Edit Copy Copy Delete Delete
DELETE FROM menuproduct WHERE `menuproduct`.`mpid` = 120
120 15 Sample Request (NEW) iomorder.php Sample Request (NEW) N
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