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 `employee_201_files` ORDER BY `filepath` DESC 
[ Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
Full texts id emp_id agency_code
Multi-agency support
title description filename
Original filename
filepath Descending Ascending 1
Unique stored filename path
file_size
File size in bytes
created_at
Edit Edit Copy Copy Delete Delete
DELETE FROM employee_201_files WHERE `employee_201_files`.`id` = 40
40 2021010245 SA001 LESP - DOMINGO DOMINGO - LESP.pdf 2021010245_201_1788493838_DOMINGO_-_LESP.pdf 5425379 2026-09-04 03:50:46
Edit Edit Copy Copy Delete Delete
DELETE FROM employee_201_files WHERE `employee_201_files`.`id` = 39
39 2021010244 SA001 LESP - Gorospe GOROSPE - 201 File.pdf 2021010244_201_1788491300_GOROSPE_-_201_File.pdf 5013440 2026-09-04 03:08:26
Edit Edit Copy Copy Delete Delete
DELETE FROM employee_201_files WHERE `employee_201_files`.`id` = 31
31 2021010229 sa001 Training scanned_batch_1784774315750.pdf 2021010229_201_1784774320_scanned_batch_1784774315... 1179498 2026-07-23 02:38:43
Edit Edit Copy Copy Delete Delete
DELETE FROM employee_201_files WHERE `employee_201_files`.`id` = 35
35 2021010228 sa001 Training scanned_batch_1784776620387.pdf 2021010228_201_1784776626_scanned_batch_1784776620... 4246264 2026-07-23 03:17:10
Edit Edit Copy Copy Delete Delete
DELETE FROM employee_201_files WHERE `employee_201_files`.`id` = 10
10 2021010220 sa001 LESP Attachment scanned_batch_1780379038862.pdf 2021010220_201_1780379046_scanned_batch_1780379038... 4225930 2026-06-02 05:44:13
Edit Edit Copy Copy Delete Delete
DELETE FROM employee_201_files WHERE `employee_201_files`.`id` = 17
17 2021010219 sa001 Training Valdez, Richard - Training.pdf 2021010219_201_1784703495_Valdez__Richard_-_Traini... 3135925 2026-07-22 06:58:19
Edit Edit Copy Copy Delete Delete
DELETE FROM employee_201_files WHERE `employee_201_files`.`id` = 8
8 2021010218 SA001 LESP Attachment Files SG Taccaban.pdf 2021010218_201_1779763154_Files_SG_Taccaban.pdf 4271508 2026-05-26 02:39:20
Edit Edit Copy Copy Delete Delete
DELETE FROM employee_201_files WHERE `employee_201_files`.`id` = 33
33 2021010217 sa001 Training scanned_batch_1784775110743.pdf 2021010217_201_1784775116_scanned_batch_1784775110... 6915274 2026-07-23 02:52:00
Edit Edit Copy Copy Delete Delete
DELETE FROM employee_201_files WHERE `employee_201_files`.`id` = 6
6 2021010216 SA001 Lesp scanned_201_1779169265793.pdf 2021010216_201_1779169271_scanned_201_177916926579... 340794 2026-05-19 05:41:11
Edit Edit Copy Copy Delete Delete
DELETE FROM employee_201_files WHERE `employee_201_files`.`id` = 26
26 2021010209 sa001 Training scanned_batch_1784772697120.pdf 2021010209_201_1784772703_scanned_batch_1784772697... 4000519 2026-07-23 02:11:46
Edit Edit Copy Copy Delete Delete
DELETE FROM employee_201_files WHERE `employee_201_files`.`id` = 42
42 2021010199 SA001 LESP Attachment LESP Attachment.pdf 2021010199_201_1789362768_LESP_Attachment.pdf 5062706 2026-09-14 05:12:54
Edit Edit Copy Copy Delete Delete
DELETE FROM employee_201_files WHERE `employee_201_files`.`id` = 21
21 2021010195 sa001 Training Cabugao - Training.pdf 2021010195_201_1784708478_Cabugao_-_Training.pdf 3386231 2026-07-22 08:21:23
Edit Edit Copy Copy Delete Delete
DELETE FROM employee_201_files WHERE `employee_201_files`.`id` = 19
19 2021010192 sa001 Training Pahalon - Training.pdf 2021010192_201_1784707428_Pahalon_-_Training.pdf 3225721 2026-07-22 08:03:52
Edit Edit Copy Copy Delete Delete
DELETE FROM employee_201_files WHERE `employee_201_files`.`id` = 13
13 2021010190 sa001 Training Corpuz, Kevin - Training.pdf 2021010190_201_1784691751_Corpuz__Kevin_-_Training... 3010804 2026-07-22 03:42:34
Edit Edit Copy Copy Delete Delete
DELETE FROM employee_201_files WHERE `employee_201_files`.`id` = 16
16 2021010183 sa001 Training Sune - Training.pdf 2021010183_201_1784702107_Sune_-_Training.pdf 3097954 2026-07-22 06:35:11
Edit Edit Copy Copy Delete Delete
DELETE FROM employee_201_files WHERE `employee_201_files`.`id` = 14
14 2021010161 sa001 Training Panguisa - Training.pdf 2021010161_201_1784698749_Panguisa_-_Training.pdf 2897869 2026-07-22 05:39:12
Edit Edit Copy Copy Delete Delete
DELETE FROM employee_201_files WHERE `employee_201_files`.`id` = 27
27 2021010160 sa001 Training scanned_batch_1784773084353.pdf 2021010160_201_1784773091_scanned_batch_1784773084... 3628758 2026-07-23 02:18:16
Edit Edit Copy Copy Delete Delete
DELETE FROM employee_201_files WHERE `employee_201_files`.`id` = 30
30 2021010152 sa001 Training scanned_batch_1784773840030.pdf 2021010152_201_1784773844_scanned_batch_1784773840... 1085041 2026-07-23 02:30:49
Edit Edit Copy Copy Delete Delete
DELETE FROM employee_201_files WHERE `employee_201_files`.`id` = 11
11 2021010147 sa001 Training Certificate scanned_batch_1784687761976.pdf 2021010147_201_1784687776_scanned_batch_1784687761... 2604567 2026-07-22 02:36:19
Edit Edit Copy Copy Delete Delete
DELETE FROM employee_201_files WHERE `employee_201_files`.`id` = 36
36 2021010141 sa001 Training scanned_batch_1784776925613.pdf 2021010141_201_1784776930_scanned_batch_1784776925... 4165249 2026-07-23 03:22:14
Edit Edit Copy Copy Delete Delete
DELETE FROM employee_201_files WHERE `employee_201_files`.`id` = 18
18 2021010128 sa001 Training Viloria - Training.pdf 2021010128_201_1784706908_Viloria_-_Training.pdf 2452365 2026-07-22 07:55:13
Edit Edit Copy Copy Delete Delete
DELETE FROM employee_201_files WHERE `employee_201_files`.`id` = 32
32 2021010126 sa001 Training scanned_batch_1784774673504.pdf 2021010126_201_1784774677_scanned_batch_1784774673... 1499838 2026-07-23 02:44:41
Edit Edit Copy Copy Delete Delete
DELETE FROM employee_201_files WHERE `employee_201_files`.`id` = 29
29 2021010111 sa001 Training scanned_batch_1784773605777.pdf 2021010111_201_1784773610_scanned_batch_1784773605... 698408 2026-07-23 02:26:53
Edit Edit Copy Copy Delete Delete
DELETE FROM employee_201_files WHERE `employee_201_files`.`id` = 38
38 2021010110 SA001 LESP - Escamillas ESCAMILLAS.pdf 2021010110_201_1788489964_ESCAMILLAS.pdf 4622096 2026-09-04 02:46:13
Edit Edit Copy Copy Delete Delete
DELETE FROM employee_201_files WHERE `employee_201_files`.`id` = 34
34 2021010108 sa001 Training scanned_batch_1784776257041.pdf 2021010108_201_1784776269_scanned_batch_1784776257... 3829790 2026-07-23 03:11:12
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