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
Customise 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 `io_file`
[ Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
Full texts fileID
自增id
name
文件名
size
文件大小
ioType
io的id
path
文件路径
hashSimple
文件简易hash(不全覆盖);hashSimple
hashMd5
文件hash, md5
linkCount
引用次数;0则定期删除
createTime
创建时间
modifyTime
最后修改时间
Edit Edit Copy Copy Delete Delete
DELETE FROM io_file WHERE `io_file`.`fileID` = 1
1 trello.oexe 230 1 {io:1}/202605/18/TfQADEC5Ciros 1ac5449ad712ef6c7864346a9e3bb84e230 1ac5449ad712ef6c7864346a9e3bb84e 1 1779087092 1779087092
Edit Edit Copy Copy Delete Delete
DELETE FROM io_file WHERE `io_file`.`fileID` = 2
2 icloud.oexe 234 1 {io:1}/202605/18/bpJZFEC5Cirvv edb2be08480b4c4d5a37c72c899bf1a4234 edb2be08480b4c4d5a37c72c899bf1a4 1 1779087092 1779087092
Edit Edit Copy Copy Delete Delete
DELETE FROM io_file WHERE `io_file`.`fileID` = 3
3 resr.txt 0 3 {io:3}/202605/18/xpG28EC5Drb6I d41d8cd98f00b204e9800998ecf8427e0 d41d8cd98f00b204e9800998ecf8427e 0 1779088999 1779089430
Edit Edit Copy Copy Delete Delete
DELETE FROM io_file WHERE `io_file`.`fileID` = 4
4 inbound8509975479795705518.jpg 3985292 3 {io:3}/202605/18/zqHdfEC5EI-lJ a9888f3391d5dee3c6a9fd552018e4213985292 697fcee36a06a942d56022623f3f5114 1 1779089774 1779089774
Edit Edit Copy Copy Delete Delete
DELETE FROM io_file WHERE `io_file`.`fileID` = 5
5 cover_a9888f3391d5dee3c6a9fd552018e4213985292_250.... 22775 1 {io:1}/202605/18/zc85gEC5EcIv8 cabce0bf84b5003b8b5803f20a6a867822775 96fcab17f9bd118c202a7e056da83ba9 2 1779090276 1779090277
Edit Edit Copy Copy Delete Delete
DELETE FROM io_file WHERE `io_file`.`fileID` = 6
6 cover_a9888f3391d5dee3c6a9fd552018e4213985292_1200... 435924 1 {io:1}/202605/18/7ZPxDEC5EcJTA 0e9622d1ade6989506b1e2ed118206b8435924 3e94112c99b0e055f9a7ae787652262d 1 1779090276 1779090276
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