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 `reward_items` ORDER BY `RewardType` DESC 
Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
Full texts RewardType Descending Ascending 1 itemid chance MinNumber MaxNumber showmsg name
Edit Edit Copy Copy Delete Delete
DELETE FROM reward_items WHERE `reward_items`.`RewardType` = '金寶箱' AND `reward_items`.`itemid` = 5570000
金寶箱 5570000 1 1 1 0 黃金鐵鎚
Edit Edit Copy Copy Delete Delete
DELETE FROM reward_items WHERE `reward_items`.`RewardType` = '金寶箱' AND `reward_items`.`itemid` = 5520001
金寶箱 5520001 1 1 1 0 白金剪刀
Edit Edit Copy Copy Delete Delete
DELETE FROM reward_items WHERE `reward_items`.`RewardType` = '金寶箱' AND `reward_items`.`itemid` = 5064000
金寶箱 5064000 1 1 1 0 裝備保護卷軸
Edit Edit Copy Copy Delete Delete
DELETE FROM reward_items WHERE `reward_items`.`RewardType` = '金寶箱' AND `reward_items`.`itemid` = 5062001
金寶箱 5062001 1 1 1 0 超級奇幻方塊
Edit Edit Copy Copy Delete Delete
DELETE FROM reward_items WHERE `reward_items`.`RewardType` = '金寶箱' AND `reward_items`.`itemid` = 2340000
金寶箱 2340000 1 1 1 0 祝福卷軸
Edit Edit Copy Copy Delete Delete
DELETE FROM reward_items WHERE `reward_items`.`RewardType` = '金寶箱' AND `reward_items`.`itemid` = 2250002
金寶箱 2250002 1 1 1 0 一億楓票
Edit Edit Copy Copy Delete Delete
DELETE FROM reward_items WHERE `reward_items`.`RewardType` = '金寶箱' AND `reward_items`.`itemid` = 2250001
金寶箱 2250001 1 1 1 0 一千萬楓票
Edit Edit Copy Copy Delete Delete
DELETE FROM reward_items WHERE `reward_items`.`RewardType` = '金寶箱' AND `reward_items`.`itemid` = 2049401
金寶箱 2049401 1 1 1 0 特殊潛在能力卷
Edit Edit Copy Copy Delete Delete
DELETE FROM reward_items WHERE `reward_items`.`RewardType` = '金寶箱' AND `reward_items`.`itemid` = 2049400
金寶箱 2049400 1 1 1 0 高級潛在能力卷
Edit Edit Copy Copy Delete Delete
DELETE FROM reward_items WHERE `reward_items`.`RewardType` = '金寶箱' AND `reward_items`.`itemid` = 2049300
金寶箱 2049300 1 1 1 0 高級強化卷
Edit Edit Copy Copy Delete Delete
DELETE FROM reward_items WHERE `reward_items`.`RewardType` = '金寶箱' AND `reward_items`.`itemid` = 2049116
金寶箱 2049116 1 1 1 0 驚訝的混沌卷
Edit Edit Copy Copy Delete Delete
DELETE FROM reward_items WHERE `reward_items`.`RewardType` = '金寶箱' AND `reward_items`.`itemid` = 2030000
金寶箱 2030000 5 100 100 0 回家卷軸
Edit Edit Copy Copy Delete Delete
DELETE FROM reward_items WHERE `reward_items`.`RewardType` = '金寶箱' AND `reward_items`.`itemid` = 2022192
金寶箱 2022192 5 100 100 0 鬆餅
Edit Edit Copy Copy Delete Delete
DELETE FROM reward_items WHERE `reward_items`.`RewardType` = '金寶箱' AND `reward_items`.`itemid` = 2022191
金寶箱 2022191 5 100 100 0 頂級披薩
Edit Edit Copy Copy Delete Delete
DELETE FROM reward_items WHERE `reward_items`.`RewardType` = '金寶箱' AND `reward_items`.`itemid` = 2022003
金寶箱 2022003 5 100 100 0 烤鰻魚
Edit Edit Copy Copy Delete Delete
DELETE FROM reward_items WHERE `reward_items`.`RewardType` = '金寶箱' AND `reward_items`.`itemid` = 2020015
金寶箱 2020015 5 100 100 0 黃昏之露
Edit Edit Copy Copy Delete Delete
DELETE FROM reward_items WHERE `reward_items`.`RewardType` = '金寶箱' AND `reward_items`.`itemid` = 2020014
金寶箱 2020014 5 100 100 0 清晨之露
Edit Edit Copy Copy Delete Delete
DELETE FROM reward_items WHERE `reward_items`.`RewardType` = '金寶箱' AND `reward_items`.`itemid` = 2020013
金寶箱 2020013 5 100 100 0 馴鹿奶
Edit Edit Copy Copy Delete Delete
DELETE FROM reward_items WHERE `reward_items`.`RewardType` = '金寶箱' AND `reward_items`.`itemid` = 2020012
金寶箱 2020012 5 100 100 0 乳酪
Edit Edit Copy Copy Delete Delete
DELETE FROM reward_items WHERE `reward_items`.`RewardType` = '金寶箱' AND `reward_items`.`itemid` = 2002000
金寶箱 2002000 5 100 100 0 礦泉水
Edit Edit Copy Copy Delete Delete
DELETE FROM reward_items WHERE `reward_items`.`RewardType` = '金寶箱' AND `reward_items`.`itemid` = 2001514
金寶箱 2001514 5 100 100 0 紅豆刨冰
Edit Edit Copy Copy Delete Delete
DELETE FROM reward_items WHERE `reward_items`.`RewardType` = '金寶箱' AND `reward_items`.`itemid` = 2001513
金寶箱 2001513 5 100 100 0 棒冰棒
Edit Edit Copy Copy Delete Delete
DELETE FROM reward_items WHERE `reward_items`.`RewardType` = '金寶箱' AND `reward_items`.`itemid` = 2001000
金寶箱 2001000 5 100 100 0 西瓜
Edit Edit Copy Copy Delete Delete
DELETE FROM reward_items WHERE `reward_items`.`RewardType` = '金寶箱' AND `reward_items`.`itemid` = 2000005
金寶箱 2000005 5 100 100 0 特殊藥水
Edit Edit Copy Copy Delete Delete
DELETE FROM reward_items WHERE `reward_items`.`RewardType` = '金寶箱' AND `reward_items`.`itemid` = 2000004
金寶箱 2000004 5 100 100 0 超級藥水
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