將檔案拖放至此處

SQL 上載 ( 0 ) x -

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





摺疊 展開 重新查詢 編輯 語句分析 效能分析 書籤 查詢失敗 資料庫 : 查詢時間 :
瀏覽模式
自訂瀏覽模式。
瀏覽模式
說明文件 僅使用圖示或文字,又或兩者都使用。 還原預設值
說明文件 僅使用圖示或文字,又或兩者都使用。 還原預設值
說明文件 是否顯示「顯示全部資料列」的按鈕。 還原預設值
說明文件 瀏覽查詢結果時,一次最多顯示的列數。如果結果超過此列數,則會顯示「上一頁」和「下一頁」的連結。 還原預設值
說明文件 SMART - 即是對 TIME、DATE、DATETIME 和 TIMESTAMP 類型的欄位遞減排序,其他欄位遞增。 還原預設值
說明文件 凸顯滑鼠指標所指的資料列。 還原預設值
說明文件 凸顯所選的資料列。 還原預設值
說明文件 還原預設值
說明文件 還原預設值
說明文件 每 X 儲存格重複標題;若要關閉此功能,請設為 0 還原預設值
說明文件 瀏覽非數字欄位時,所顯示的最大字元數。 還原預設值
說明文件 連結包含了編輯、複製和刪除。 還原預設值
說明文件 是否顯示缺少獨一鍵的資料列連結。 還原預設值
說明文件 預設使用主鍵來排列資料表。 還原預設值
說明文件 瀏覽資料表時,會使用上次的資料表排序。 還原預設值
說明文件 顯示用選項 還原預設值
SELECT * FROM `vw_customer_quote_project` ORDER BY `quote_no` DESC 
行內編輯 ] [ 編輯 ] [ SQL 語句分析 ] [ 建立 PHP 程式碼 ] [ 重新整理 ]
完整內容 customer_id company_name quotation_id quote_no 遞減 遞增 1 quotation_status quotation_amount project_id project_no project_name project_status order_amount
編輯 編輯 複製 複製 刪除 刪除
DELETE FROM vw_customer_quote_project WHERE `vw_customer_quote_project`.`customer_id` = 1474 AND `vw_customer_quote_project`.`company_name` = '铠爱分析仪器(上海)有限公司' AND `vw_customer_quote_project`.`quotation_id` = 52 AND `vw_customer_quote_project`.`quote_no` = 'Q26-006-H002' AND `vw_customer_quote_project`.`quotation_status` = 'draft' AND CONCAT(`vw_customer_quote_project`.`quotation_amount`) = 6250.00 AND `vw_customer_quote_project`.`project_id` IS NULL AND `vw_customer_quote_project`.`project_no` IS NULL AND `vw_customer_quote_project`.`project_name` IS NULL AND `vw_customer_quote_project`.`project_status` IS NULL AND CONCAT(`vw_customer_quote_project`.`order_amount`) IS NULL LIMIT 1
1474 铠爱分析仪器(上海)有限公司 52 Q26-006-H002 draft 6250.00 NULL NULL NULL NULL NULL
編輯 編輯 複製 複製 刪除 刪除
DELETE FROM vw_customer_quote_project WHERE `vw_customer_quote_project`.`customer_id` = 20 AND `vw_customer_quote_project`.`company_name` = '台灣檢驗科技股份有限公司' AND `vw_customer_quote_project`.`quotation_id` = 31 AND `vw_customer_quote_project`.`quote_no` = 'Q26-006-H001' AND `vw_customer_quote_project`.`quotation_status` = 'sent' AND CONCAT(`vw_customer_quote_project`.`quotation_amount`) = 31500.00 AND `vw_customer_quote_project`.`project_id` IS NULL AND `vw_customer_quote_project`.`project_no` IS NULL AND `vw_customer_quote_project`.`project_name` IS NULL AND `vw_customer_quote_project`.`project_status` IS NULL AND CONCAT(`vw_customer_quote_project`.`order_amount`) IS NULL LIMIT 1
20 台灣檢驗科技股份有限公司 31 Q26-006-H001 sent 31500.00 NULL NULL NULL NULL NULL
編輯 編輯 複製 複製 刪除 刪除
DELETE FROM vw_customer_quote_project WHERE `vw_customer_quote_project`.`customer_id` = 1475 AND `vw_customer_quote_project`.`company_name` = '旭誼工程股份有限公司' AND `vw_customer_quote_project`.`quotation_id` = 72 AND `vw_customer_quote_project`.`quote_no` = 'Q26-006-E004' AND `vw_customer_quote_project`.`quotation_status` = 'draft' AND CONCAT(`vw_customer_quote_project`.`quotation_amount`) = 2943675.00 AND `vw_customer_quote_project`.`project_id` IS NULL AND `vw_customer_quote_project`.`project_no` IS NULL AND `vw_customer_quote_project`.`project_name` IS NULL AND `vw_customer_quote_project`.`project_status` IS NULL AND CONCAT(`vw_customer_quote_project`.`order_amount`) IS NULL LIMIT 1
1475 旭誼工程股份有限公司 72 Q26-006-E004 draft 2943675.00 NULL NULL NULL NULL NULL
編輯 編輯 複製 複製 刪除 刪除
DELETE FROM vw_customer_quote_project WHERE `vw_customer_quote_project`.`customer_id` = 722 AND `vw_customer_quote_project`.`company_name` = '洽隆 CHIAHLUANG ENTERPRISE CO., LTD' AND `vw_customer_quote_project`.`quotation_id` = 50 AND `vw_customer_quote_project`.`quote_no` = 'Q26-006-E003' AND `vw_customer_quote_project`.`quotation_status` = 'draft' AND CONCAT(`vw_customer_quote_project`.`quotation_amount`) = 34650.00 AND `vw_customer_quote_project`.`project_id` IS NULL AND `vw_customer_quote_project`.`project_no` IS NULL AND `vw_customer_quote_project`.`project_name` IS NULL AND `vw_customer_quote_project`.`project_status` IS NULL AND CONCAT(`vw_customer_quote_project`.`order_amount`) IS NULL LIMIT 1
722 洽隆 CHIAHLUANG ENTERPRISE CO., LTD 50 Q26-006-E003 draft 34650.00 NULL NULL NULL NULL NULL
編輯 編輯 複製 複製 刪除 刪除
DELETE FROM vw_customer_quote_project WHERE `vw_customer_quote_project`.`customer_id` = 1473 AND `vw_customer_quote_project`.`company_name` = '帆宣系統科技股份有限公司' AND `vw_customer_quote_project`.`quotation_id` = 48 AND `vw_customer_quote_project`.`quote_no` = 'Q26-006-E002' AND `vw_customer_quote_project`.`quotation_status` = 'draft' AND CONCAT(`vw_customer_quote_project`.`quotation_amount`) = 15225.00 AND `vw_customer_quote_project`.`project_id` IS NULL AND `vw_customer_quote_project`.`project_no` IS NULL AND `vw_customer_quote_project`.`project_name` IS NULL AND `vw_customer_quote_project`.`project_status` IS NULL AND CONCAT(`vw_customer_quote_project`.`order_amount`) IS NULL LIMIT 1
1473 帆宣系統科技股份有限公司 48 Q26-006-E002 draft 15225.00 NULL NULL NULL NULL NULL
編輯 編輯 複製 複製 刪除 刪除
DELETE FROM vw_customer_quote_project WHERE `vw_customer_quote_project`.`customer_id` = 20 AND `vw_customer_quote_project`.`company_name` = '台灣檢驗科技股份有限公司' AND `vw_customer_quote_project`.`quotation_id` = 21 AND `vw_customer_quote_project`.`quote_no` = 'Q26-006-E001' AND `vw_customer_quote_project`.`quotation_status` = 'draft' AND CONCAT(`vw_customer_quote_project`.`quotation_amount`) = 5250.00 AND `vw_customer_quote_project`.`project_id` IS NULL AND `vw_customer_quote_project`.`project_no` IS NULL AND `vw_customer_quote_project`.`project_name` IS NULL AND `vw_customer_quote_project`.`project_status` IS NULL AND CONCAT(`vw_customer_quote_project`.`order_amount`) IS NULL LIMIT 1
20 台灣檢驗科技股份有限公司 21 Q26-006-E001 draft 5250.00 NULL NULL NULL NULL NULL
編輯 編輯 複製 複製 刪除 刪除
DELETE FROM vw_customer_quote_project WHERE `vw_customer_quote_project`.`customer_id` = 408 AND `vw_customer_quote_project`.`company_name` = '工業技術研究院' AND `vw_customer_quote_project`.`quotation_id` = 99 AND `vw_customer_quote_project`.`quote_no` = 'Q26-005-E003' AND `vw_customer_quote_project`.`quotation_status` = 'draft' AND CONCAT(`vw_customer_quote_project`.`quotation_amount`) = 18585.00 AND `vw_customer_quote_project`.`project_id` IS NULL AND `vw_customer_quote_project`.`project_no` IS NULL AND `vw_customer_quote_project`.`project_name` IS NULL AND `vw_customer_quote_project`.`project_status` IS NULL AND CONCAT(`vw_customer_quote_project`.`order_amount`) IS NULL LIMIT 1
408 工業技術研究院 99 Q26-005-E003 draft 18585.00 NULL NULL NULL NULL NULL
編輯 編輯 複製 複製 刪除 刪除
DELETE FROM vw_customer_quote_project WHERE `vw_customer_quote_project`.`customer_id` = 408 AND `vw_customer_quote_project`.`company_name` = '工業技術研究院' AND `vw_customer_quote_project`.`quotation_id` = 96 AND `vw_customer_quote_project`.`quote_no` = 'Q26-005-E002' AND `vw_customer_quote_project`.`quotation_status` = 'draft' AND CONCAT(`vw_customer_quote_project`.`quotation_amount`) = 14910.00 AND `vw_customer_quote_project`.`project_id` IS NULL AND `vw_customer_quote_project`.`project_no` IS NULL AND `vw_customer_quote_project`.`project_name` IS NULL AND `vw_customer_quote_project`.`project_status` IS NULL AND CONCAT(`vw_customer_quote_project`.`order_amount`) IS NULL LIMIT 1
408 工業技術研究院 96 Q26-005-E002 draft 14910.00 NULL NULL NULL NULL NULL
編輯 編輯 複製 複製 刪除 刪除
DELETE FROM vw_customer_quote_project WHERE `vw_customer_quote_project`.`customer_id` = 408 AND `vw_customer_quote_project`.`company_name` = '工業技術研究院' AND `vw_customer_quote_project`.`quotation_id` = 75 AND `vw_customer_quote_project`.`quote_no` = 'Q26-005-E001' AND `vw_customer_quote_project`.`quotation_status` = 'draft' AND CONCAT(`vw_customer_quote_project`.`quotation_amount`) = 89775.00 AND `vw_customer_quote_project`.`project_id` IS NULL AND `vw_customer_quote_project`.`project_no` IS NULL AND `vw_customer_quote_project`.`project_name` IS NULL AND `vw_customer_quote_project`.`project_status` IS NULL AND CONCAT(`vw_customer_quote_project`.`order_amount`) IS NULL LIMIT 1
408 工業技術研究院 75 Q26-005-E001 draft 89775.00 NULL NULL NULL NULL NULL
編輯 編輯 複製 複製 刪除 刪除
DELETE FROM vw_customer_quote_project WHERE `vw_customer_quote_project`.`customer_id` = 1475 AND `vw_customer_quote_project`.`company_name` = '旭誼工程股份有限公司' AND `vw_customer_quote_project`.`quotation_id` = 89 AND `vw_customer_quote_project`.`quote_no` = 'Q26-004-H001' AND `vw_customer_quote_project`.`quotation_status` = 'sent' AND CONCAT(`vw_customer_quote_project`.`quotation_amount`) = 788700.00 AND `vw_customer_quote_project`.`project_id` IS NULL AND `vw_customer_quote_project`.`project_no` IS NULL AND `vw_customer_quote_project`.`project_name` IS NULL AND `vw_customer_quote_project`.`project_status` IS NULL AND CONCAT(`vw_customer_quote_project`.`order_amount`) IS NULL LIMIT 1
1475 旭誼工程股份有限公司 89 Q26-004-H001 sent 788700.00 NULL NULL NULL NULL NULL
編輯 編輯 複製 複製 刪除 刪除
DELETE FROM vw_customer_quote_project WHERE `vw_customer_quote_project`.`customer_id` = 876 AND `vw_customer_quote_project`.`company_name` = '洽隆企業有限公司' AND `vw_customer_quote_project`.`quotation_id` = 95 AND `vw_customer_quote_project`.`quote_no` = 'Q26-004-E001' AND `vw_customer_quote_project`.`quotation_status` = 'draft' AND CONCAT(`vw_customer_quote_project`.`quotation_amount`) = 86100.00 AND `vw_customer_quote_project`.`project_id` IS NULL AND `vw_customer_quote_project`.`project_no` IS NULL AND `vw_customer_quote_project`.`project_name` IS NULL AND `vw_customer_quote_project`.`project_status` IS NULL AND CONCAT(`vw_customer_quote_project`.`order_amount`) IS NULL LIMIT 1
876 洽隆企業有限公司 95 Q26-004-E001 draft 86100.00 NULL NULL NULL NULL NULL
編輯 編輯 複製 複製 刪除 刪除
DELETE FROM vw_customer_quote_project WHERE `vw_customer_quote_project`.`customer_id` = 1475 AND `vw_customer_quote_project`.`company_name` = '旭誼工程股份有限公司' AND `vw_customer_quote_project`.`quotation_id` = 81 AND `vw_customer_quote_project`.`quote_no` = 'Q26-003-H001' AND `vw_customer_quote_project`.`quotation_status` = 'draft' AND CONCAT(`vw_customer_quote_project`.`quotation_amount`) = 12345000.00 AND `vw_customer_quote_project`.`project_id` IS NULL AND `vw_customer_quote_project`.`project_no` IS NULL AND `vw_customer_quote_project`.`project_name` IS NULL AND `vw_customer_quote_project`.`project_status` IS NULL AND CONCAT(`vw_customer_quote_project`.`order_amount`) IS NULL LIMIT 1
1475 旭誼工程股份有限公司 81 Q26-003-H001 draft 12345000.00 NULL NULL NULL NULL NULL
編輯 編輯 複製 複製 刪除 刪除
DELETE FROM vw_customer_quote_project WHERE `vw_customer_quote_project`.`customer_id` = 45 AND `vw_customer_quote_project`.`company_name` = 'SERMAX Cryogenics Sdn. Bhd.' AND `vw_customer_quote_project`.`quotation_id` = 80 AND `vw_customer_quote_project`.`quote_no` = 'Q26-002-J031-V1' AND `vw_customer_quote_project`.`quotation_status` = 'draft' AND CONCAT(`vw_customer_quote_project`.`quotation_amount`) = 296000.00 AND `vw_customer_quote_project`.`project_id` IS NULL AND `vw_customer_quote_project`.`project_no` IS NULL AND `vw_customer_quote_project`.`project_name` IS NULL AND `vw_customer_quote_project`.`project_status` IS NULL AND CONCAT(`vw_customer_quote_project`.`order_amount`) IS NULL LIMIT 1
45 SERMAX Cryogenics Sdn. Bhd. 80 Q26-002-J031-V1 draft 296000.00 NULL NULL NULL NULL NULL
編輯 編輯 複製 複製 刪除 刪除
DELETE FROM vw_customer_quote_project WHERE `vw_customer_quote_project`.`customer_id` = 45 AND `vw_customer_quote_project`.`company_name` = 'SERMAX Cryogenics Sdn. Bhd.' AND `vw_customer_quote_project`.`quotation_id` = 58 AND `vw_customer_quote_project`.`quote_no` = 'Q26-002-J031' AND `vw_customer_quote_project`.`quotation_status` = 'replaced' AND CONCAT(`vw_customer_quote_project`.`quotation_amount`) = 176000.00 AND `vw_customer_quote_project`.`project_id` IS NULL AND `vw_customer_quote_project`.`project_no` IS NULL AND `vw_customer_quote_project`.`project_name` IS NULL AND `vw_customer_quote_project`.`project_status` IS NULL AND CONCAT(`vw_customer_quote_project`.`order_amount`) IS NULL LIMIT 1
45 SERMAX Cryogenics Sdn. Bhd. 58 Q26-002-J031 replaced 176000.00 NULL NULL NULL NULL NULL
編輯 編輯 複製 複製 刪除 刪除
DELETE FROM vw_customer_quote_project WHERE `vw_customer_quote_project`.`customer_id` = 17 AND `vw_customer_quote_project`.`company_name` = '工業技術研究院' AND `vw_customer_quote_project`.`quotation_id` = 33 AND `vw_customer_quote_project`.`quote_no` = 'Q26-002-J030' AND `vw_customer_quote_project`.`quotation_status` = 'draft' AND CONCAT(`vw_customer_quote_project`.`quotation_amount`) = 6678000.00 AND `vw_customer_quote_project`.`project_id` IS NULL AND `vw_customer_quote_project`.`project_no` IS NULL AND `vw_customer_quote_project`.`project_name` IS NULL AND `vw_customer_quote_project`.`project_status` IS NULL AND CONCAT(`vw_customer_quote_project`.`order_amount`) IS NULL LIMIT 1
17 工業技術研究院 33 Q26-002-J030 draft 6678000.00 NULL NULL NULL NULL NULL
編輯 編輯 複製 複製 刪除 刪除
DELETE FROM vw_customer_quote_project WHERE `vw_customer_quote_project`.`customer_id` = 18 AND `vw_customer_quote_project`.`company_name` = '永鈦氣體工業股份有限公司' AND `vw_customer_quote_project`.`quotation_id` = 20 AND `vw_customer_quote_project`.`quote_no` = 'Q26-002-J026' AND `vw_customer_quote_project`.`quotation_status` = 'sent' AND CONCAT(`vw_customer_quote_project`.`quotation_amount`) = 2016000.00 AND `vw_customer_quote_project`.`project_id` IS NULL AND `vw_customer_quote_project`.`project_no` IS NULL AND `vw_customer_quote_project`.`project_name` IS NULL AND `vw_customer_quote_project`.`project_status` IS NULL AND CONCAT(`vw_customer_quote_project`.`order_amount`) IS NULL LIMIT 1
18 永鈦氣體工業股份有限公司 20 Q26-002-J026 sent 2016000.00 NULL NULL NULL NULL NULL
編輯 編輯 複製 複製 刪除 刪除
DELETE FROM vw_customer_quote_project WHERE `vw_customer_quote_project`.`customer_id` = 7 AND `vw_customer_quote_project`.`company_name` = '國倫科技' AND `vw_customer_quote_project`.`quotation_id` = 56 AND `vw_customer_quote_project`.`quote_no` = 'Q26-002-H009' AND `vw_customer_quote_project`.`quotation_status` = 'draft' AND CONCAT(`vw_customer_quote_project`.`quotation_amount`) = 220500.00 AND `vw_customer_quote_project`.`project_id` IS NULL AND `vw_customer_quote_project`.`project_no` IS NULL AND `vw_customer_quote_project`.`project_name` IS NULL AND `vw_customer_quote_project`.`project_status` IS NULL AND CONCAT(`vw_customer_quote_project`.`order_amount`) IS NULL LIMIT 1
7 國倫科技 56 Q26-002-H009 draft 220500.00 NULL NULL NULL NULL NULL
編輯 編輯 複製 複製 刪除 刪除
DELETE FROM vw_customer_quote_project WHERE `vw_customer_quote_project`.`customer_id` = 7 AND `vw_customer_quote_project`.`company_name` = '國倫科技' AND `vw_customer_quote_project`.`quotation_id` = 51 AND `vw_customer_quote_project`.`quote_no` = 'Q26-002-H008-V1' AND `vw_customer_quote_project`.`quotation_status` = 'sent' AND CONCAT(`vw_customer_quote_project`.`quotation_amount`) = 288000.00 AND `vw_customer_quote_project`.`project_id` IS NULL AND `vw_customer_quote_project`.`project_no` IS NULL AND `vw_customer_quote_project`.`project_name` IS NULL AND `vw_customer_quote_project`.`project_status` IS NULL AND CONCAT(`vw_customer_quote_project`.`order_amount`) IS NULL LIMIT 1
7 國倫科技 51 Q26-002-H008-V1 sent 288000.00 NULL NULL NULL NULL NULL
編輯 編輯 複製 複製 刪除 刪除
DELETE FROM vw_customer_quote_project WHERE `vw_customer_quote_project`.`customer_id` = 7 AND `vw_customer_quote_project`.`company_name` = '國倫科技' AND `vw_customer_quote_project`.`quotation_id` = 49 AND `vw_customer_quote_project`.`quote_no` = 'Q26-002-H008' AND `vw_customer_quote_project`.`quotation_status` = 'replaced' AND CONCAT(`vw_customer_quote_project`.`quotation_amount`) = 350000.00 AND `vw_customer_quote_project`.`project_id` IS NULL AND `vw_customer_quote_project`.`project_no` IS NULL AND `vw_customer_quote_project`.`project_name` IS NULL AND `vw_customer_quote_project`.`project_status` IS NULL AND CONCAT(`vw_customer_quote_project`.`order_amount`) IS NULL LIMIT 1
7 國倫科技 49 Q26-002-H008 replaced 350000.00 NULL NULL NULL NULL NULL
編輯 編輯 複製 複製 刪除 刪除
DELETE FROM vw_customer_quote_project WHERE `vw_customer_quote_project`.`customer_id` = 7 AND `vw_customer_quote_project`.`company_name` = '國倫科技' AND `vw_customer_quote_project`.`quotation_id` = 43 AND `vw_customer_quote_project`.`quote_no` = 'Q26-002-H007' AND `vw_customer_quote_project`.`quotation_status` = 'sent' AND CONCAT(`vw_customer_quote_project`.`quotation_amount`) = 357000.00 AND `vw_customer_quote_project`.`project_id` IS NULL AND `vw_customer_quote_project`.`project_no` IS NULL AND `vw_customer_quote_project`.`project_name` IS NULL AND `vw_customer_quote_project`.`project_status` IS NULL AND CONCAT(`vw_customer_quote_project`.`order_amount`) IS NULL LIMIT 1
7 國倫科技 43 Q26-002-H007 sent 357000.00 NULL NULL NULL NULL NULL
編輯 編輯 複製 複製 刪除 刪除
DELETE FROM vw_customer_quote_project WHERE `vw_customer_quote_project`.`customer_id` = 1471 AND `vw_customer_quote_project`.`company_name` = 'APP SYSTEMS SERVICES PTE LTD' AND `vw_customer_quote_project`.`quotation_id` = 32 AND `vw_customer_quote_project`.`quote_no` = 'Q26-002-H006' AND `vw_customer_quote_project`.`quotation_status` = 'draft' AND CONCAT(`vw_customer_quote_project`.`quotation_amount`) = 6560.00 AND `vw_customer_quote_project`.`project_id` IS NULL AND `vw_customer_quote_project`.`project_no` IS NULL AND `vw_customer_quote_project`.`project_name` IS NULL AND `vw_customer_quote_project`.`project_status` IS NULL AND CONCAT(`vw_customer_quote_project`.`order_amount`) IS NULL LIMIT 1
1471 APP SYSTEMS SERVICES PTE LTD 32 Q26-002-H006 draft 6560.00 NULL NULL NULL NULL NULL
編輯 編輯 複製 複製 刪除 刪除
DELETE FROM vw_customer_quote_project WHERE `vw_customer_quote_project`.`customer_id` = 7 AND `vw_customer_quote_project`.`company_name` = '國倫科技' AND `vw_customer_quote_project`.`quotation_id` = 14 AND `vw_customer_quote_project`.`quote_no` = 'Q26-002-H005' AND `vw_customer_quote_project`.`quotation_status` = 'draft' AND CONCAT(`vw_customer_quote_project`.`quotation_amount`) = 180600.00 AND `vw_customer_quote_project`.`project_id` IS NULL AND `vw_customer_quote_project`.`project_no` IS NULL AND `vw_customer_quote_project`.`project_name` IS NULL AND `vw_customer_quote_project`.`project_status` IS NULL AND CONCAT(`vw_customer_quote_project`.`order_amount`) IS NULL LIMIT 1
7 國倫科技 14 Q26-002-H005 draft 180600.00 NULL NULL NULL NULL NULL
編輯 編輯 複製 複製 刪除 刪除
DELETE FROM vw_customer_quote_project WHERE `vw_customer_quote_project`.`customer_id` = 14 AND `vw_customer_quote_project`.`company_name` = '台灣積體電路製造股份有限公司' AND `vw_customer_quote_project`.`quotation_id` = 13 AND `vw_customer_quote_project`.`quote_no` = 'Q26-002-H004' AND `vw_customer_quote_project`.`quotation_status` = 'sent' AND CONCAT(`vw_customer_quote_project`.`quotation_amount`) = 142800.00 AND `vw_customer_quote_project`.`project_id` IS NULL AND `vw_customer_quote_project`.`project_no` IS NULL AND `vw_customer_quote_project`.`project_name` IS NULL AND `vw_customer_quote_project`.`project_status` IS NULL AND CONCAT(`vw_customer_quote_project`.`order_amount`) IS NULL LIMIT 1
14 台灣積體電路製造股份有限公司 13 Q26-002-H004 sent 142800.00 NULL NULL NULL NULL NULL
編輯 編輯 複製 複製 刪除 刪除
DELETE FROM vw_customer_quote_project WHERE `vw_customer_quote_project`.`customer_id` = 11 AND `vw_customer_quote_project`.`company_name` = '台灣日酸系統科技股份有限公司' AND `vw_customer_quote_project`.`quotation_id` = 8 AND `vw_customer_quote_project`.`quote_no` = 'Q26-002-H003' AND `vw_customer_quote_project`.`quotation_status` = 'sent' AND CONCAT(`vw_customer_quote_project`.`quotation_amount`) = 5997600.00 AND `vw_customer_quote_project`.`project_id` IS NULL AND `vw_customer_quote_project`.`project_no` IS NULL AND `vw_customer_quote_project`.`project_name` IS NULL AND `vw_customer_quote_project`.`project_status` IS NULL AND CONCAT(`vw_customer_quote_project`.`order_amount`) IS NULL LIMIT 1
11 台灣日酸系統科技股份有限公司 8 Q26-002-H003 sent 5997600.00 NULL NULL NULL NULL NULL
編輯 編輯 複製 複製 刪除 刪除
DELETE FROM vw_customer_quote_project WHERE `vw_customer_quote_project`.`customer_id` = 9 AND `vw_customer_quote_project`.`company_name` = '亞洲巴萊斯股份有限公司' AND `vw_customer_quote_project`.`quotation_id` = 6 AND `vw_customer_quote_project`.`quote_no` = 'Q26-002-H002' AND `vw_customer_quote_project`.`quotation_status` = 'sent' AND CONCAT(`vw_customer_quote_project`.`quotation_amount`) = 115500.00 AND `vw_customer_quote_project`.`project_id` IS NULL AND `vw_customer_quote_project`.`project_no` IS NULL AND `vw_customer_quote_project`.`project_name` IS NULL AND `vw_customer_quote_project`.`project_status` IS NULL AND CONCAT(`vw_customer_quote_project`.`order_amount`) IS NULL LIMIT 1
9 亞洲巴萊斯股份有限公司 6 Q26-002-H002 sent 115500.00 NULL NULL NULL NULL NULL
已選擇項目: 已選擇項目:
查詢結果選項 複製到剪貼簿 複製到剪貼簿 匯出 匯出 顯示圖表 顯示圖表 新增檢視表 新增檢視表
將此 SQL 查詢加為書籤 將此 SQL 查詢加為書籤