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 `name` DESC 
[ Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
Full texts RewardType itemid chance MinNumber MaxNumber showmsg name Descending Ascending 1
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` = 2020015
金寶箱 2020015 5 100 100 0 黃昏之露
Edit Edit Copy Copy Delete Delete
DELETE FROM reward_items WHERE `reward_items`.`RewardType` = '活動獎勵' AND `reward_items`.`itemid` = 4302004
活動獎勵 4302004 99 1 1 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` = 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` = 2020013
金寶箱 2020013 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` = 5220000
活動獎勵 5220000 99 1 1 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 超級藥水
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` = 2001000
金寶箱 2001000 5 100 100 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` = 4302001
活動獎勵 4302001 99 1 1 0 血之寶石
Edit Edit Copy Copy Delete Delete
DELETE FROM reward_items WHERE `reward_items`.`RewardType` = '活動獎勵' AND `reward_items`.`itemid` = 5050000
活動獎勵 5050000 99 1 1 0 能力點數重配捲軸
Edit Edit Copy Copy Delete Delete
DELETE FROM reward_items WHERE `reward_items`.`RewardType` = '楓樹山丘' AND `reward_items`.`itemid` = 2022248
楓樹山丘 2022248 1 1 1 0 綠色口香糖
Edit Edit Copy Copy Delete Delete
DELETE FROM reward_items WHERE `reward_items`.`RewardType` = '楓樹山丘' AND `reward_items`.`itemid` = 2022249
楓樹山丘 2022249 1 1 1 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` = 2340000
金寶箱 2340000 1 1 1 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` = 5520001
金寶箱 5520001 1 1 1 0 白金剪刀
Edit Edit Copy Copy Delete Delete
DELETE FROM reward_items WHERE `reward_items`.`RewardType` = '活動獎勵' AND `reward_items`.`itemid` = 2450000
活動獎勵 2450000 50 1 1 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` = 2049401
金寶箱 2049401 1 1 1 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