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 `drop_data`
Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
Full texts id world dropperid itemid minimum_quantity maximum_quantity questid chance reborn expiration ignoredropbuff hourdrop
Edit Edit Copy Copy Delete Delete
DELETE FROM drop_data WHERE `drop_data`.`id` = 603374
603374 0 9300040 4001051 1 1 0 1000000 0 -1 0 0
Edit Edit Copy Copy Delete Delete
DELETE FROM drop_data WHERE `drop_data`.`id` = 11815
11815 0 6230100 4031213 1 1 2097 200000 0 -1 0 0
Edit Edit Copy Copy Delete Delete
DELETE FROM drop_data WHERE `drop_data`.`id` = 11816
11816 0 7130100 4031214 1 1 2097 200000 0 -1 0 0
Edit Edit Copy Copy Delete Delete
DELETE FROM drop_data WHERE `drop_data`.`id` = 11817
11817 0 7220001 4031793 1 1 3647 999999 0 -1 0 0
Edit Edit Copy Copy Delete Delete
DELETE FROM drop_data WHERE `drop_data`.`id` = 11818
11818 0 7130101 4031215 1 1 2097 200000 0 -1 0 0
Edit Edit Copy Copy Delete Delete
DELETE FROM drop_data WHERE `drop_data`.`id` = 11819
11819 0 210100 4031273 1 1 2104 500000 0 -1 0 0
Edit Edit Copy Copy Delete Delete
DELETE FROM drop_data WHERE `drop_data`.`id` = 11820
11820 0 2220100 2022016 1 1 8164 100000 0 -1 0 0
Edit Edit Copy Copy Delete Delete
DELETE FROM drop_data WHERE `drop_data`.`id` = 11821
11821 0 2130100 4031153 1 1 2070 10000 0 -1 0 0
Edit Edit Copy Copy Delete Delete
DELETE FROM drop_data WHERE `drop_data`.`id` = 11822
11822 0 2230106 4031268 1 1 3629 30000 0 -1 0 0
Edit Edit Copy Copy Delete Delete
DELETE FROM drop_data WHERE `drop_data`.`id` = 11823
11823 0 2230105 4031259 1 1 3080 30000 0 -1 0 0
Edit Edit Copy Copy Delete Delete
DELETE FROM drop_data WHERE `drop_data`.`id` = 11824
11824 0 2230106 4031260 1 1 3080 30000 0 -1 0 0
Edit Edit Copy Copy Delete Delete
DELETE FROM drop_data WHERE `drop_data`.`id` = 11825
11825 0 2230108 4031261 1 1 3080 30000 0 -1 0 0
Edit Edit Copy Copy Delete Delete
DELETE FROM drop_data WHERE `drop_data`.`id` = 11826
11826 0 2230200 4031262 1 1 3081 30000 0 -1 0 0
Edit Edit Copy Copy Delete Delete
DELETE FROM drop_data WHERE `drop_data`.`id` = 11827
11827 0 3230104 4031263 1 1 3081 30000 0 -1 0 0
Edit Edit Copy Copy Delete Delete
DELETE FROM drop_data WHERE `drop_data`.`id` = 11828
11828 0 2230109 4031264 1 1 3081 30000 0 -1 0 0
Edit Edit Copy Copy Delete Delete
DELETE FROM drop_data WHERE `drop_data`.`id` = 11829
11829 0 4230200 4031265 1 1 3082 30000 0 -1 0 0
Edit Edit Copy Copy Delete Delete
DELETE FROM drop_data WHERE `drop_data`.`id` = 11830
11830 0 4230123 4031266 1 1 3082 30000 0 -1 0 0
Edit Edit Copy Copy Delete Delete
DELETE FROM drop_data WHERE `drop_data`.`id` = 11831
11831 0 4230124 4031267 1 1 3082 30000 0 -1 0 0
Edit Edit Copy Copy Delete Delete
DELETE FROM drop_data WHERE `drop_data`.`id` = 11832
11832 0 4230116 4031103 1 1 3414 100000 0 -1 0 0
Edit Edit Copy Copy Delete Delete
DELETE FROM drop_data WHERE `drop_data`.`id` = 11833
11833 0 4230117 4031104 1 1 3414 100000 0 -1 0 0
Edit Edit Copy Copy Delete Delete
DELETE FROM drop_data WHERE `drop_data`.`id` = 11834
11834 0 4230118 4031105 1 1 3414 100000 0 -1 0 0
Edit Edit Copy Copy Delete Delete
DELETE FROM drop_data WHERE `drop_data`.`id` = 11835
11835 0 4240000 4031106 1 1 3414 100000 0 -1 0 0
Edit Edit Copy Copy Delete Delete
DELETE FROM drop_data WHERE `drop_data`.`id` = 11836
11836 0 7130400 4031232 1 1 3611 1000000 0 -1 0 0
Edit Edit Copy Copy Delete Delete
DELETE FROM drop_data WHERE `drop_data`.`id` = 11837
11837 0 7130401 4031233 1 1 3611 1000000 0 -1 0 0
Edit Edit Copy Copy Delete Delete
DELETE FROM drop_data WHERE `drop_data`.`id` = 11838
11838 0 7130402 4031234 1 1 3611 1000000 0 -1 0 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