將檔案拖放至此處

SQL 上載 ( 0 ) x -

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





摺疊 展開 重新查詢 編輯 語句分析 效能分析 書籤 查詢失敗 資料庫 : 查詢時間 :
瀏覽模式
自訂瀏覽模式。
瀏覽模式
說明文件 僅使用圖示或文字,又或兩者都使用。 還原預設值
說明文件 僅使用圖示或文字,又或兩者都使用。 還原預設值
說明文件 是否顯示「顯示全部資料列」的按鈕。 還原預設值
說明文件 瀏覽查詢結果時,一次最多顯示的列數。如果結果超過此列數,則會顯示「上一頁」和「下一頁」的連結。 還原預設值
說明文件 SMART - 即是對 TIME、DATE、DATETIME 和 TIMESTAMP 類型的欄位遞減排序,其他欄位遞增。 還原預設值
說明文件 凸顯滑鼠指標所指的資料列。 還原預設值
說明文件 凸顯所選的資料列。 還原預設值
說明文件 還原預設值
說明文件 還原預設值
說明文件 每 X 儲存格重複標題;若要關閉此功能,請設為 0 還原預設值
說明文件 瀏覽非數字欄位時,所顯示的最大字元數。 還原預設值
說明文件 連結包含了編輯、複製和刪除。 還原預設值
說明文件 是否顯示缺少獨一鍵的資料列連結。 還原預設值
說明文件 預設使用主鍵來排列資料表。 還原預設值
說明文件 瀏覽資料表時,會使用上次的資料表排序。 還原預設值
說明文件 顯示用選項 還原預設值
SELECT * FROM `vw_customer_quote_project` ORDER BY `project_name` DESC 
行內編輯 ] [ 編輯 ] [ SQL 語句分析 ] [ 建立 PHP 程式碼 ] [ 重新整理 ]
完整內容 customer_id company_name quotation_id quote_no quotation_status quotation_amount project_id project_no project_name 遞減 遞增 1 project_status order_amount
編輯 編輯 複製 複製 刪除 刪除
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` = 37 AND `vw_customer_quote_project`.`quote_no` = 'Q26-001-H010-V1' AND `vw_customer_quote_project`.`quotation_status` = 'won' AND CONCAT(`vw_customer_quote_project`.`quotation_amount`) = 441000.00 AND `vw_customer_quote_project`.`project_id` = 10 AND `vw_customer_quote_project`.`project_no` = 'RE260701-001' AND `vw_customer_quote_project`.`project_name` = '國倫9N-1000-IN-10 for N2' AND `vw_customer_quote_project`.`project_status` = 'active' AND CONCAT(`vw_customer_quote_project`.`order_amount`) = 441000.00 LIMIT 1
7 國倫科技 37 Q26-001-H010-V1 won 441000.00 10 RE260701-001 國倫9N-1000-IN-10 for N2 active 441000.00
編輯 編輯 複製 複製 刪除 刪除
DELETE FROM vw_customer_quote_project WHERE `vw_customer_quote_project`.`customer_id` = 752 AND `vw_customer_quote_project`.`company_name` = '京和科技股份有限公司' AND `vw_customer_quote_project`.`quotation_id` IS NULL AND `vw_customer_quote_project`.`quote_no` IS NULL AND `vw_customer_quote_project`.`quotation_status` IS NULL AND CONCAT(`vw_customer_quote_project`.`quotation_amount`) IS NULL 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
752 京和科技股份有限公司 NULL NULL NULL NULL NULL NULL NULL NULL NULL
編輯 編輯 複製 複製 刪除 刪除
DELETE FROM vw_customer_quote_project WHERE `vw_customer_quote_project`.`customer_id` = 206 AND `vw_customer_quote_project`.`company_name` = 'Gasmax Energy Pte.Ltd' AND `vw_customer_quote_project`.`quotation_id` IS NULL AND `vw_customer_quote_project`.`quote_no` IS NULL AND `vw_customer_quote_project`.`quotation_status` IS NULL AND CONCAT(`vw_customer_quote_project`.`quotation_amount`) IS NULL 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
206 Gasmax Energy Pte.Ltd NULL NULL NULL NULL NULL NULL NULL NULL NULL
編輯 編輯 複製 複製 刪除 刪除
DELETE FROM vw_customer_quote_project WHERE `vw_customer_quote_project`.`customer_id` = 674 AND `vw_customer_quote_project`.`company_name` = '宏廣新技股份有限公司' AND `vw_customer_quote_project`.`quotation_id` IS NULL AND `vw_customer_quote_project`.`quote_no` IS NULL AND `vw_customer_quote_project`.`quotation_status` IS NULL AND CONCAT(`vw_customer_quote_project`.`quotation_amount`) IS NULL 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
674 宏廣新技股份有限公司 NULL NULL NULL NULL NULL NULL NULL NULL NULL
編輯 編輯 複製 複製 刪除 刪除
DELETE FROM vw_customer_quote_project WHERE `vw_customer_quote_project`.`customer_id` = 128 AND `vw_customer_quote_project`.`company_name` = '臺北氧氣股份有限公司' AND `vw_customer_quote_project`.`quotation_id` IS NULL AND `vw_customer_quote_project`.`quote_no` IS NULL AND `vw_customer_quote_project`.`quotation_status` IS NULL AND CONCAT(`vw_customer_quote_project`.`quotation_amount`) IS NULL 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
128 臺北氧氣股份有限公司 NULL NULL NULL NULL NULL NULL NULL NULL NULL
編輯 編輯 複製 複製 刪除 刪除
DELETE FROM vw_customer_quote_project WHERE `vw_customer_quote_project`.`customer_id` = 596 AND `vw_customer_quote_project`.`company_name` = '渣打國際商業銀行股份有限公司' AND `vw_customer_quote_project`.`quotation_id` IS NULL AND `vw_customer_quote_project`.`quote_no` IS NULL AND `vw_customer_quote_project`.`quotation_status` IS NULL AND CONCAT(`vw_customer_quote_project`.`quotation_amount`) IS NULL 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
596 渣打國際商業銀行股份有限公司 NULL NULL NULL NULL NULL NULL NULL NULL NULL
編輯 編輯 複製 複製 刪除 刪除
DELETE FROM vw_customer_quote_project WHERE `vw_customer_quote_project`.`customer_id` = 46 AND `vw_customer_quote_project`.`company_name` = '麦斯克电子材料(郑州)有限公司' AND `vw_customer_quote_project`.`quotation_id` IS NULL AND `vw_customer_quote_project`.`quote_no` IS NULL AND `vw_customer_quote_project`.`quotation_status` IS NULL AND CONCAT(`vw_customer_quote_project`.`quotation_amount`) IS NULL 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
46 麦斯克电子材料(郑州)有限公司 NULL NULL NULL NULL NULL NULL NULL NULL NULL
編輯 編輯 複製 複製 刪除 刪除
DELETE FROM vw_customer_quote_project WHERE `vw_customer_quote_project`.`customer_id` = 1032 AND `vw_customer_quote_project`.`company_name` = '工業技術研究院' AND `vw_customer_quote_project`.`quotation_id` IS NULL AND `vw_customer_quote_project`.`quote_no` IS NULL AND `vw_customer_quote_project`.`quotation_status` IS NULL AND CONCAT(`vw_customer_quote_project`.`quotation_amount`) IS NULL 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
1032 工業技術研究院 NULL NULL NULL NULL NULL NULL NULL NULL NULL
編輯 編輯 複製 複製 刪除 刪除
DELETE FROM vw_customer_quote_project WHERE `vw_customer_quote_project`.`customer_id` = 955 AND `vw_customer_quote_project`.`company_name` = '夢想廚房工廠' AND `vw_customer_quote_project`.`quotation_id` IS NULL AND `vw_customer_quote_project`.`quote_no` IS NULL AND `vw_customer_quote_project`.`quotation_status` IS NULL AND CONCAT(`vw_customer_quote_project`.`quotation_amount`) IS NULL 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
955 夢想廚房工廠 NULL NULL NULL NULL NULL NULL NULL NULL NULL
編輯 編輯 複製 複製 刪除 刪除
DELETE FROM vw_customer_quote_project WHERE `vw_customer_quote_project`.`customer_id` = 877 AND `vw_customer_quote_project`.`company_name` = '美商普拉克西艾爾科技(股)公司' AND `vw_customer_quote_project`.`quotation_id` IS NULL AND `vw_customer_quote_project`.`quote_no` IS NULL AND `vw_customer_quote_project`.`quotation_status` IS NULL AND CONCAT(`vw_customer_quote_project`.`quotation_amount`) IS NULL 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
877 美商普拉克西艾爾科技(股)公司 NULL NULL NULL NULL NULL NULL NULL NULL NULL
編輯 編輯 複製 複製 刪除 刪除
DELETE FROM vw_customer_quote_project WHERE `vw_customer_quote_project`.`customer_id` = 294 AND `vw_customer_quote_project`.`company_name` = 'A Subsidiary Company of Wholetech System Hitech Limited' AND `vw_customer_quote_project`.`quotation_id` IS NULL AND `vw_customer_quote_project`.`quote_no` IS NULL AND `vw_customer_quote_project`.`quotation_status` IS NULL AND CONCAT(`vw_customer_quote_project`.`quotation_amount`) IS NULL 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
294 A Subsidiary Company of Wholetech System Hitech Li... NULL NULL NULL NULL NULL NULL NULL NULL NULL
編輯 編輯 複製 複製 刪除 刪除
DELETE FROM vw_customer_quote_project WHERE `vw_customer_quote_project`.`customer_id` = 1221 AND `vw_customer_quote_project`.`company_name` = '派歐尼克科技(股)' AND `vw_customer_quote_project`.`quotation_id` IS NULL AND `vw_customer_quote_project`.`quote_no` IS NULL AND `vw_customer_quote_project`.`quotation_status` IS NULL AND CONCAT(`vw_customer_quote_project`.`quotation_amount`) IS NULL 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
1221 派歐尼克科技(股) NULL NULL NULL NULL NULL NULL NULL NULL NULL
編輯 編輯 複製 複製 刪除 刪除
DELETE FROM vw_customer_quote_project WHERE `vw_customer_quote_project`.`customer_id` = 1144 AND `vw_customer_quote_project`.`company_name` = '漢磊科技股份有限公司' AND `vw_customer_quote_project`.`quotation_id` IS NULL AND `vw_customer_quote_project`.`quote_no` IS NULL AND `vw_customer_quote_project`.`quotation_status` IS NULL AND CONCAT(`vw_customer_quote_project`.`quotation_amount`) IS NULL 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
1144 漢磊科技股份有限公司 NULL NULL NULL NULL NULL NULL NULL NULL NULL
編輯 編輯 複製 複製 刪除 刪除
DELETE FROM vw_customer_quote_project WHERE `vw_customer_quote_project`.`customer_id` = 784 AND `vw_customer_quote_project`.`company_name` = 'S e m' AND `vw_customer_quote_project`.`quotation_id` IS NULL AND `vw_customer_quote_project`.`quote_no` IS NULL AND `vw_customer_quote_project`.`quotation_status` IS NULL AND CONCAT(`vw_customer_quote_project`.`quotation_amount`) IS NULL 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
784 S e m NULL NULL NULL NULL NULL NULL NULL NULL NULL
編輯 編輯 複製 複製 刪除 刪除
DELETE FROM vw_customer_quote_project WHERE `vw_customer_quote_project`.`customer_id` = 238 AND `vw_customer_quote_project`.`company_name` = '瑞立亞科技有限公司' AND `vw_customer_quote_project`.`quotation_id` IS NULL AND `vw_customer_quote_project`.`quote_no` IS NULL AND `vw_customer_quote_project`.`quotation_status` IS NULL AND CONCAT(`vw_customer_quote_project`.`quotation_amount`) IS NULL 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
238 瑞立亞科技有限公司 NULL NULL NULL NULL NULL NULL NULL NULL NULL
編輯 編輯 複製 複製 刪除 刪除
DELETE FROM vw_customer_quote_project WHERE `vw_customer_quote_project`.`customer_id` = 160 AND `vw_customer_quote_project`.`company_name` = 'SERMAX Cryogenics Sdn. Bhd.' AND `vw_customer_quote_project`.`quotation_id` IS NULL AND `vw_customer_quote_project`.`quote_no` IS NULL AND `vw_customer_quote_project`.`quotation_status` IS NULL AND CONCAT(`vw_customer_quote_project`.`quotation_amount`) IS NULL 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
160 SERMAX Cryogenics Sdn. Bhd. NULL NULL NULL NULL NULL NULL NULL NULL NULL
編輯 編輯 複製 複製 刪除 刪除
DELETE FROM vw_customer_quote_project WHERE `vw_customer_quote_project`.`customer_id` = 1335 AND `vw_customer_quote_project`.`company_name` = '光磊科技股份有限公司廠務設備處' AND `vw_customer_quote_project`.`quotation_id` IS NULL AND `vw_customer_quote_project`.`quote_no` IS NULL AND `vw_customer_quote_project`.`quotation_status` IS NULL AND CONCAT(`vw_customer_quote_project`.`quotation_amount`) IS NULL 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
1335 光磊科技股份有限公司廠務設備處 NULL NULL NULL NULL NULL NULL NULL NULL NULL
編輯 編輯 複製 複製 刪除 刪除
DELETE FROM vw_customer_quote_project WHERE `vw_customer_quote_project`.`customer_id` = 78 AND `vw_customer_quote_project`.`company_name` = 'WITHTECH' AND `vw_customer_quote_project`.`quotation_id` IS NULL AND `vw_customer_quote_project`.`quote_no` IS NULL AND `vw_customer_quote_project`.`quotation_status` IS NULL AND CONCAT(`vw_customer_quote_project`.`quotation_amount`) IS NULL 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
78 WITHTECH NULL NULL NULL NULL NULL NULL NULL NULL NULL
編輯 編輯 複製 複製 刪除 刪除
DELETE FROM vw_customer_quote_project WHERE `vw_customer_quote_project`.`customer_id` = 1064 AND `vw_customer_quote_project`.`company_name` = '東立佳科技股份有限公司' AND `vw_customer_quote_project`.`quotation_id` IS NULL AND `vw_customer_quote_project`.`quote_no` IS NULL AND `vw_customer_quote_project`.`quotation_status` IS NULL AND CONCAT(`vw_customer_quote_project`.`quotation_amount`) IS NULL 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
1064 東立佳科技股份有限公司 NULL NULL NULL NULL NULL NULL NULL NULL NULL
編輯 編輯 複製 複製 刪除 刪除
DELETE FROM vw_customer_quote_project WHERE `vw_customer_quote_project`.`customer_id` = 987 AND `vw_customer_quote_project`.`company_name` = '美商英特格有限公司台灣分公司' AND `vw_customer_quote_project`.`quotation_id` IS NULL AND `vw_customer_quote_project`.`quote_no` IS NULL AND `vw_customer_quote_project`.`quotation_status` IS NULL AND CONCAT(`vw_customer_quote_project`.`quotation_amount`) IS NULL 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
987 美商英特格有限公司台灣分公司 NULL NULL NULL NULL NULL NULL NULL NULL NULL
編輯 編輯 複製 複製 刪除 刪除
DELETE FROM vw_customer_quote_project WHERE `vw_customer_quote_project`.`customer_id` = 909 AND `vw_customer_quote_project`.`company_name` = '台鎔軾-钏,j料股份有限公司' AND `vw_customer_quote_project`.`quotation_id` IS NULL AND `vw_customer_quote_project`.`quote_no` IS NULL AND `vw_customer_quote_project`.`quotation_status` IS NULL AND CONCAT(`vw_customer_quote_project`.`quotation_amount`) IS NULL 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
909 台鎔軾-钏,j料股份有限公司 NULL NULL NULL NULL NULL NULL NULL NULL NULL
編輯 編輯 複製 複製 刪除 刪除
DELETE FROM vw_customer_quote_project WHERE `vw_customer_quote_project`.`customer_id` = 500 AND `vw_customer_quote_project`.`company_name` = '上海飛擇科技有限公司' AND `vw_customer_quote_project`.`quotation_id` IS NULL AND `vw_customer_quote_project`.`quote_no` IS NULL AND `vw_customer_quote_project`.`quotation_status` IS NULL AND CONCAT(`vw_customer_quote_project`.`quotation_amount`) IS NULL 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
500 上海飛擇科技有限公司 NULL NULL NULL NULL NULL NULL NULL NULL NULL
編輯 編輯 複製 複製 刪除 刪除
DELETE FROM vw_customer_quote_project WHERE `vw_customer_quote_project`.`customer_id` = 404 AND `vw_customer_quote_project`.`company_name` = 'L·7一·株式会社' AND `vw_customer_quote_project`.`quotation_id` IS NULL AND `vw_customer_quote_project`.`quote_no` IS NULL AND `vw_customer_quote_project`.`quotation_status` IS NULL AND CONCAT(`vw_customer_quote_project`.`quotation_amount`) IS NULL 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
404 L·7一·株式会社 NULL NULL NULL NULL NULL NULL NULL NULL NULL
編輯 編輯 複製 複製 刪除 刪除
DELETE FROM vw_customer_quote_project WHERE `vw_customer_quote_project`.`customer_id` = 326 AND `vw_customer_quote_project`.`company_name` = '鴻揚半導體股份有限公司' AND `vw_customer_quote_project`.`quotation_id` IS NULL AND `vw_customer_quote_project`.`quote_no` IS NULL AND `vw_customer_quote_project`.`quotation_status` IS NULL AND CONCAT(`vw_customer_quote_project`.`quotation_amount`) IS NULL 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
326 鴻揚半導體股份有限公司 NULL NULL NULL NULL NULL NULL NULL NULL NULL
編輯 編輯 複製 複製 刪除 刪除
DELETE FROM vw_customer_quote_project WHERE `vw_customer_quote_project`.`customer_id` = 1253 AND `vw_customer_quote_project`.`company_name` = 'Genesis Photonics Inc.' AND `vw_customer_quote_project`.`quotation_id` IS NULL AND `vw_customer_quote_project`.`quote_no` IS NULL AND `vw_customer_quote_project`.`quotation_status` IS NULL AND CONCAT(`vw_customer_quote_project`.`quotation_amount`) IS NULL 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
1253 Genesis Photonics Inc. NULL NULL NULL NULL NULL NULL NULL NULL NULL
已選擇項目: 已選擇項目:
查詢結果選項 複製到剪貼簿 複製到剪貼簿 匯出 匯出 顯示圖表 顯示圖表 新增檢視表 新增檢視表
將此 SQL 查詢加為書籤 將此 SQL 查詢加為書籤