將檔案拖放至此處

SQL 上載 ( 0 ) x -

頁面相關設定 點選此列以回到頁面頂端
請按 Ctrl+Enter 執行查詢 請按 Enter 執行查詢
遞增
遞減
排序：
SQL 偵錯
次數
執行排序
使用時間
排序依：
群組查詢
解除群組查詢
摺疊 展開 顯示追蹤 隱藏追蹤 次數 : 使用時間 :
書籤
重新整理
新增
無書籤
新增書籤
選項
設為預設值





摺疊 展開 重新查詢 編輯 語句分析 效能分析 書籤 查詢失敗 資料庫 : 查詢時間 :
自訂瀏覽模式。
瀏覽模式
說明文件 僅使用圖示或文字，又或兩者都使用。 還原預設值
說明文件 僅使用圖示或文字，又或兩者都使用。 還原預設值
說明文件 是否顯示「顯示全部資料列」的按鈕。 還原預設值
說明文件 瀏覽查詢結果時，一次最多顯示的列數。如果結果超過此列數，則會顯示「上一頁」和「下一頁」的連結。 還原預設值
說明文件 SMART - 即是對 TIME、DATE、DATETIME 和 TIMESTAMP 類型的欄位遞減排序，其他欄位遞增。 還原預設值
說明文件 凸顯滑鼠指標所指的資料列。 還原預設值
說明文件 凸顯所選的資料列。 還原預設值
說明文件 還原預設值
說明文件 還原預設值
說明文件 每 X 儲存格重複標題；若要關閉此功能，請設為 0。 還原預設值
說明文件 瀏覽非數字欄位時，所顯示的最大字元數。 還原預設值
說明文件 連結包含了編輯、複製和刪除。 還原預設值
說明文件 是否顯示缺少獨一鍵的資料列連結。 還原預設值
說明文件 預設使用主鍵來排列資料表。 還原預設值
說明文件 瀏覽資料表時，會使用上次的資料表排序。 還原預設值
說明文件 顯示用選項 還原預設值 
SELECT * FROM `expense_item_receipts`
[ 行內編輯 ] [ 編輯 ] [ SQL 語句分析 ] [ 建立 PHP 程式碼 ] [ 重新整理 ]
|
|
|
|
篩選資料列:
依主鍵排序：
完整內容 id item_id application_id file_path file_name uploaded_by uploaded_at
編輯 編輯 複製 複製 刪除 刪除
DELETE FROM expense_item_receipts WHERE `expense_item_receipts`.`id` = 2
 		2 7 7 uploads/expense_receipts/7/receipt_7_7_RT029_20260... 01.jpg RT029 2026-06-01 12:22:02
編輯 編輯 複製 複製 刪除 刪除
DELETE FROM expense_item_receipts WHERE `expense_item_receipts`.`id` = 3
 		3 8 7 uploads/expense_receipts/7/receipt_7_8_RT029_20260... 02.jpg RT029 2026-06-01 12:22:02
編輯 編輯 複製 複製 刪除 刪除
DELETE FROM expense_item_receipts WHERE `expense_item_receipts`.`id` = 4
 		4 9 7 uploads/expense_receipts/7/receipt_7_9_RT029_20260... 03.jpg RT029 2026-06-01 12:22:02
編輯 編輯 複製 複製 刪除 刪除
DELETE FROM expense_item_receipts WHERE `expense_item_receipts`.`id` = 5
 		5 10 7 uploads/expense_receipts/7/receipt_7_10_RT029_2026... 04.jpg RT029 2026-06-01 12:22:02
編輯 編輯 複製 複製 刪除 刪除
DELETE FROM expense_item_receipts WHERE `expense_item_receipts`.`id` = 6
 		6 11 7 uploads/expense_receipts/7/receipt_7_11_RT029_2026... 05.jpg RT029 2026-06-01 12:22:02
編輯 編輯 複製 複製 刪除 刪除
DELETE FROM expense_item_receipts WHERE `expense_item_receipts`.`id` = 7
 		7 12 7 uploads/expense_receipts/7/receipt_7_12_RT029_2026... 06.jpg RT029 2026-06-01 12:22:02
編輯 編輯 複製 複製 刪除 刪除
DELETE FROM expense_item_receipts WHERE `expense_item_receipts`.`id` = 8
 		8 13 7 uploads/expense_receipts/7/receipt_7_13_RT029_2026... 07.jpg RT029 2026-06-01 12:22:02
編輯 編輯 複製 複製 刪除 刪除
DELETE FROM expense_item_receipts WHERE `expense_item_receipts`.`id` = 9
 		9 14 7 uploads/expense_receipts/7/receipt_7_14_RT029_2026... 08.jpg RT029 2026-06-01 12:22:02
編輯 編輯 複製 複製 刪除 刪除
DELETE FROM expense_item_receipts WHERE `expense_item_receipts`.`id` = 10
 		10 15 7 uploads/expense_receipts/7/receipt_7_15_RT029_2026... 09.jpg RT029 2026-06-01 12:22:02
編輯 編輯 複製 複製 刪除 刪除
DELETE FROM expense_item_receipts WHERE `expense_item_receipts`.`id` = 11
 		11 16 7 uploads/expense_receipts/7/receipt_7_16_RT029_2026... 10.jpg RT029 2026-06-01 12:22:02
編輯 編輯 複製 複製 刪除 刪除
DELETE FROM expense_item_receipts WHERE `expense_item_receipts`.`id` = 12
 		12 17 8 uploads/expense_receipts/8/receipt_8_17_RT049_2026... 5月份費用申請.png RT049 2026-06-01 21:29:02
編輯 編輯 複製 複製 刪除 刪除
DELETE FROM expense_item_receipts WHERE `expense_item_receipts`.`id` = 13
 		13 19 9 uploads/expense_receipts/9/receipt_9_19_RT048_2026... 1 (2).jpg RT048 2026-06-24 10:16:29
編輯 編輯 複製 複製 刪除 刪除
DELETE FROM expense_item_receipts WHERE `expense_item_receipts`.`id` = 14
 		14 20 9 uploads/expense_receipts/9/receipt_9_20_RT048_2026... 1 (3).jpg RT048 2026-06-24 10:16:29
編輯 編輯 複製 複製 刪除 刪除
DELETE FROM expense_item_receipts WHERE `expense_item_receipts`.`id` = 15
 		15 21 9 uploads/expense_receipts/9/receipt_9_21_RT048_2026... 1 (5).jpg RT048 2026-06-24 10:16:29
編輯 編輯 複製 複製 刪除 刪除
DELETE FROM expense_item_receipts WHERE `expense_item_receipts`.`id` = 16
 		16 22 9 uploads/expense_receipts/9/receipt_9_22_RT048_2026... 1 (8).jpg RT048 2026-06-24 10:16:29
編輯 編輯 複製 複製 刪除 刪除
DELETE FROM expense_item_receipts WHERE `expense_item_receipts`.`id` = 17
 		17 23 9 uploads/expense_receipts/9/receipt_9_23_RT048_2026... 1 (9).jpg RT048 2026-06-24 10:16:29
編輯 編輯 複製 複製 刪除 刪除
DELETE FROM expense_item_receipts WHERE `expense_item_receipts`.`id` = 18
 		18 24 9 uploads/expense_receipts/9/receipt_9_24_RT048_2026... 1 (11).jpg RT048 2026-06-24 10:16:29
編輯 編輯 複製 複製 刪除 刪除
DELETE FROM expense_item_receipts WHERE `expense_item_receipts`.`id` = 19
 		19 25 9 uploads/expense_receipts/9/receipt_9_25_RT048_2026... 1 (12).jpg RT048 2026-06-24 10:16:29
編輯 編輯 複製 複製 刪除 刪除
DELETE FROM expense_item_receipts WHERE `expense_item_receipts`.`id` = 20
 		20 26 9 uploads/expense_receipts/9/receipt_9_26_RT048_2026... 1 (13).jpg RT048 2026-06-24 10:16:29
編輯 編輯 複製 複製 刪除 刪除
DELETE FROM expense_item_receipts WHERE `expense_item_receipts`.`id` = 21
 		21 27 9 uploads/expense_receipts/9/receipt_9_27_RT048_2026... 1 (16).jpg RT048 2026-06-24 10:16:29
編輯 編輯 複製 複製 刪除 刪除
DELETE FROM expense_item_receipts WHERE `expense_item_receipts`.`id` = 22
 		22 28 9 uploads/expense_receipts/9/receipt_9_28_RT048_2026... 1 (19).jpg RT048 2026-06-24 10:16:29
編輯 編輯 複製 複製 刪除 刪除
DELETE FROM expense_item_receipts WHERE `expense_item_receipts`.`id` = 23
 		23 29 9 uploads/expense_receipts/9/receipt_9_29_RT048_2026... 1 (21).jpg RT048 2026-06-24 10:16:29
編輯 編輯 複製 複製 刪除 刪除
DELETE FROM expense_item_receipts WHERE `expense_item_receipts`.`id` = 24
 		24 30 9 uploads/expense_receipts/9/receipt_9_30_RT048_2026... 1 (22).jpg RT048 2026-06-24 10:16:29
編輯 編輯 複製 複製 刪除 刪除
DELETE FROM expense_item_receipts WHERE `expense_item_receipts`.`id` = 25
 		25 31 9 uploads/expense_receipts/9/receipt_9_31_RT048_2026... 1 (23).jpg RT048 2026-06-24 10:16:29
編輯 編輯 複製 複製 刪除 刪除
DELETE FROM expense_item_receipts WHERE `expense_item_receipts`.`id` = 26
 		26 32 9 uploads/expense_receipts/9/receipt_9_32_RT048_2026... 1 (24).jpg RT048 2026-06-24 10:16:29
已選擇項目： 已選擇項目：
|
|
|
|
篩選資料列:
依主鍵排序：
查詢結果選項 複製到剪貼簿 複製到剪貼簿 匯出 匯出 顯示圖表 顯示圖表 新增檢視表 新增檢視表
將此 SQL 查詢加為書籤 將此 SQL 查詢加為書籤