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 `mdl_files`
Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
Full texts id contenthash pathnamehash contextid component filearea itemid filepath filename userid filesize mimetype status source author license timecreated timemodified sortorder referencefileid
Edit Edit Copy Copy Delete Delete
DELETE FROM mdl_files WHERE `mdl_files`.`id` = 1
1 5f8e911d0da441e36f47c5c46f4393269211ca56 508e674d49c30d4fde325fe6c7f6fd3d56b247e1 1 assignfeedback_editpdf stamps 0 / smile.png 2 1085 image/png 0 NULL NULL NULL 1775857405 1775857405 0 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM mdl_files WHERE `mdl_files`.`id` = 2
2 da39a3ee5e6b4b0d3255bfef95601890afd80709 70b7cdade7b4e27d4e83f0cdaad10d6a3c0cccb5 1 assignfeedback_editpdf stamps 0 / . 2 0 NULL 0 NULL NULL NULL 1775857405 1775857405 0 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM mdl_files WHERE `mdl_files`.`id` = 3
3 75c101cb8cb34ea573cd25ac38f8157b1de901b8 68317eab56c67d32aeaee5acf509a0c4aa828b6b 1 assignfeedback_editpdf stamps 0 / sad.png 2 966 image/png 0 NULL NULL NULL 1775857405 1775857405 0 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM mdl_files WHERE `mdl_files`.`id` = 4
4 0c5190a24c3943966541401c883eacaa20ca20cb 695a55ff780e61c9e59428aa425430b0d6bde53b 1 assignfeedback_editpdf stamps 0 / tick.png 2 1039 image/png 0 NULL NULL NULL 1775857405 1775857405 0 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM mdl_files WHERE `mdl_files`.`id` = 5
5 8c96a486d5801e0f4ab8c411f561f1c687e1f865 373e63af262a9b8466ba8632551520be793c37ff 1 assignfeedback_editpdf stamps 0 / cross.png 2 861 image/png 0 NULL NULL NULL 1775857405 1775857405 0 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM mdl_files WHERE `mdl_files`.`id` = 8
8 8efa8303178131883ad2654463f822e362274540 655c1b8942657ed551c95e40a4d1c2185d3fd1f0 11 tool_recyclebin recyclebin_coursecat 1 / backup.mbz 2 5922 application/vnd.moodle.backup 0 NULL NULL NULL 1775885584 1775885584 0 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM mdl_files WHERE `mdl_files`.`id` = 9
9 da39a3ee5e6b4b0d3255bfef95601890afd80709 481336672917443a37792ed8bc5e674cced15984 11 tool_recyclebin recyclebin_coursecat 1 / . 2 0 NULL 0 NULL NULL NULL 1775885584 1775885584 0 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM mdl_files WHERE `mdl_files`.`id` = 14
14 d9dee84a85d51af9d43e918492754e16ba537487 6810608311be96e2a71d0fb399c7ffdac17e4648 1 core_admin logo 0 / logo_iher.png NULL 103724 image/png 0 NULL NULL NULL 1775889697 1775889697 0 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM mdl_files WHERE `mdl_files`.`id` = 15
15 da39a3ee5e6b4b0d3255bfef95601890afd80709 13329bd7898f033eb0e93c11a609c6adfb8fb295 1 core_admin logo 0 / . NULL 0 NULL 0 NULL NULL NULL 1775889697 1775889697 0 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM mdl_files WHERE `mdl_files`.`id` = 16
16 d9dee84a85d51af9d43e918492754e16ba537487 209a7db24fd327760b061aca13446290a9dc7cf2 1 core_admin logocompact 0 / logo_iher_compact.png NULL 103724 image/png 0 NULL NULL NULL 1775889697 1775889697 0 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM mdl_files WHERE `mdl_files`.`id` = 17
17 da39a3ee5e6b4b0d3255bfef95601890afd80709 ed928c2defdda280bb604ab3df79598e4c3adc00 1 core_admin logocompact 0 / . NULL 0 NULL 0 NULL NULL NULL 1775889697 1775889697 0 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM mdl_files WHERE `mdl_files`.`id` = 20
20 e9f7297dff736c1028761df794200c29ed13fbab 3399df99243bb83bedab9ac974c28def56da2ddd 181 tool_recyclebin recyclebin_coursecat 2 / backup.mbz 2 18000 application/vnd.moodle.backup 0 NULL NULL NULL 1776025147 1776025148 0 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM mdl_files WHERE `mdl_files`.`id` = 21
21 da39a3ee5e6b4b0d3255bfef95601890afd80709 41f12fd051665a11d096b94112a64a3ca2866021 181 tool_recyclebin recyclebin_coursecat 2 / . 2 0 NULL 0 NULL NULL NULL 1776025148 1776025148 0 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM mdl_files WHERE `mdl_files`.`id` = 24
24 9e9a6e065a6d9bc4ea965677ceed12dd313f2a50 9218b3ec285425c6bf129f7c3c48651cb6e473a0 181 tool_recyclebin recyclebin_coursecat 3 / backup.mbz 2 18108 application/vnd.moodle.backup 0 NULL NULL NULL 1776025159 1776025159 0 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM mdl_files WHERE `mdl_files`.`id` = 25
25 da39a3ee5e6b4b0d3255bfef95601890afd80709 c948cf2116160e0555bd112cd9efd92ebc014abd 181 tool_recyclebin recyclebin_coursecat 3 / . 2 0 NULL 0 NULL NULL NULL 1776025159 1776025159 0 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM mdl_files WHERE `mdl_files`.`id` = 28
28 9d01308bc910e57e7ca208f9c299b6604820330f 313a1da0863bf07ddef26f58604f9067f37ef98b 181 tool_recyclebin recyclebin_coursecat 4 / backup.mbz 2 18003 application/vnd.moodle.backup 0 NULL NULL NULL 1776025166 1776025166 0 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM mdl_files WHERE `mdl_files`.`id` = 29
29 da39a3ee5e6b4b0d3255bfef95601890afd80709 05beedc51cf81687e07990955200511604949f68 181 tool_recyclebin recyclebin_coursecat 4 / . 2 0 NULL 0 NULL NULL NULL 1776025166 1776025166 0 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM mdl_files WHERE `mdl_files`.`id` = 32
32 545548f1f40abf4e0576ae701fa2625cf75ec7f5 a2273c00f16f5e9d0391d9df4baac888b16b56b9 181 tool_recyclebin recyclebin_coursecat 5 / backup.mbz 2 17965 application/vnd.moodle.backup 0 NULL NULL NULL 1776025178 1776025178 0 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM mdl_files WHERE `mdl_files`.`id` = 33
33 da39a3ee5e6b4b0d3255bfef95601890afd80709 b83aaec7f7b381240107a50b6359d12436173903 181 tool_recyclebin recyclebin_coursecat 5 / . 2 0 NULL 0 NULL NULL NULL 1776025178 1776025178 0 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM mdl_files WHERE `mdl_files`.`id` = 36
36 9b457fa1a820a4e5fa3136d32edd8ba01a5f7a6d 4005c8f3bf596ffee8e7e9fa6902ffd8210556b2 181 tool_recyclebin recyclebin_coursecat 6 / backup.mbz 2 17895 application/vnd.moodle.backup 0 NULL NULL NULL 1776025288 1776025289 0 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM mdl_files WHERE `mdl_files`.`id` = 37
37 da39a3ee5e6b4b0d3255bfef95601890afd80709 404f5098fb609267b26744e989867247d03c1574 181 tool_recyclebin recyclebin_coursecat 6 / . 2 0 NULL 0 NULL NULL NULL 1776025289 1776025289 0 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM mdl_files WHERE `mdl_files`.`id` = 40
40 bc114dcd972d0193e0200af5787fd56e08634ae2 bee4b56f744278c857c16133da4f0289624a3fac 181 tool_recyclebin recyclebin_coursecat 7 / backup.mbz 2 19136 application/vnd.moodle.backup 0 NULL NULL NULL 1776025343 1776025343 0 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM mdl_files WHERE `mdl_files`.`id` = 41
41 da39a3ee5e6b4b0d3255bfef95601890afd80709 0f960b97e3c56c471a86e2182fb8f4daa39d9a94 181 tool_recyclebin recyclebin_coursecat 7 / . 2 0 NULL 0 NULL NULL NULL 1776025343 1776025343 0 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM mdl_files WHERE `mdl_files`.`id` = 44
44 523f9a866dff104757e12fc533946a6d48215304 7e037edf72e9d88dc89f7ac8537b46477518d0eb 181 tool_recyclebin recyclebin_coursecat 8 / backup.mbz 2 28827 application/vnd.moodle.backup 0 NULL NULL NULL 1776025356 1776025356 0 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM mdl_files WHERE `mdl_files`.`id` = 45
45 da39a3ee5e6b4b0d3255bfef95601890afd80709 94524b4405267f2446e67df3065cb1f771fc2d91 181 tool_recyclebin recyclebin_coursecat 8 / . 2 0 NULL 0 NULL NULL NULL 1776025356 1776025356 0 NULL
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