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`
Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
Full texts RewardType itemid chance MinNumber MaxNumber showmsg name
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` = 2022567
楓樹山丘 2022567 1 1 1 0 一片鮮奶油蛋糕
Edit Edit Copy Copy Delete Delete
DELETE FROM reward_items WHERE `reward_items`.`RewardType` = '活動獎勵' AND `reward_items`.`itemid` = 2022530
活動獎勵 2022530 55 1 1 0 幸福寶物卡
Edit Edit Copy Copy Delete Delete
DELETE FROM reward_items WHERE `reward_items`.`RewardType` = '活動獎勵' AND `reward_items`.`itemid` = 2250000
活動獎勵 2250000 70 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` = 4302001
活動獎勵 4302001 99 1 1 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` = 4302023
活動獎勵 4302023 99 1 1 0 椅子抽獎卷
Edit Edit Copy Copy Delete Delete
DELETE FROM reward_items WHERE `reward_items`.`RewardType` = '活動獎勵' AND `reward_items`.`itemid` = 4302025
活動獎勵 4302025 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` = 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` = 2000005
金寶箱 2000005 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` = 2001513
金寶箱 2001513 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` = 2002000
金寶箱 2002000 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` = 2020013
金寶箱 2020013 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` = 2020015
金寶箱 2020015 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` = 2022191
金寶箱 2022191 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 鬆餅
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