將檔案拖放至此處

SQL 上載 ( 0 ) x -

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





摺疊 展開 重新查詢 編輯 語句分析 效能分析 書籤 查詢失敗 資料庫 : 查詢時間 :
自訂瀏覽模式。
瀏覽模式
說明文件 僅使用圖示或文字，又或兩者都使用。 還原預設值
說明文件 僅使用圖示或文字，又或兩者都使用。 還原預設值
說明文件 是否顯示「顯示全部資料列」的按鈕。 還原預設值
說明文件 瀏覽查詢結果時，一次最多顯示的列數。如果結果超過此列數，則會顯示「上一頁」和「下一頁」的連結。 還原預設值
說明文件 SMART - 即是對 TIME、DATE、DATETIME 和 TIMESTAMP 類型的欄位遞減排序，其他欄位遞增。 還原預設值
說明文件 凸顯滑鼠指標所指的資料列。 還原預設值
說明文件 凸顯所選的資料列。 還原預設值
說明文件 還原預設值
說明文件 還原預設值
說明文件 每 X 儲存格重複標題；若要關閉此功能，請設為 0。 還原預設值
說明文件 瀏覽非數字欄位時，所顯示的最大字元數。 還原預設值
說明文件 連結包含了編輯、複製和刪除。 還原預設值
說明文件 是否顯示缺少獨一鍵的資料列連結。 還原預設值
說明文件 預設使用主鍵來排列資料表。 還原預設值
說明文件 瀏覽資料表時，會使用上次的資料表排序。 還原預設值
說明文件 顯示用選項 還原預設值 
SELECT * FROM `vw_customer_sales_flow` ORDER BY `company_name` DESC
[ 行內編輯 ] [ 編輯 ] [ SQL 語句分析 ] [ 建立 PHP 程式碼 ] [ 重新整理 ]
|
|
|
|
篩選資料列:
完整內容 customer_id company_name 遞減 遞增 1 quotation_id quotation_status project_id project_status
編輯 編輯 複製 複製 刪除 刪除
DELETE FROM vw_customer_sales_flow WHERE `vw_customer_sales_flow`.`customer_id` = 76 AND `vw_customer_sales_flow`.`company_name` = '위드텍' AND `vw_customer_sales_flow`.`quotation_id` IS NULL AND `vw_customer_sales_flow`.`quotation_status` IS NULL AND `vw_customer_sales_flow`.`project_id` IS NULL AND `vw_customer_sales_flow`.`project_status` IS NULL LIMIT 1
 		76 위드텍 NULL NULL NULL NULL
編輯 編輯 複製 複製 刪除 刪除
DELETE FROM vw_customer_sales_flow WHERE `vw_customer_sales_flow`.`customer_id` = 255 AND `vw_customer_sales_flow`.`company_name` = '선우 ENG 주식회사President' AND `vw_customer_sales_flow`.`quotation_id` IS NULL AND `vw_customer_sales_flow`.`quotation_status` IS NULL AND `vw_customer_sales_flow`.`project_id` IS NULL AND `vw_customer_sales_flow`.`project_status` IS NULL LIMIT 1
 		255 선우 ENG 주식회사President NULL NULL NULL NULL
編輯 編輯 複製 複製 刪除 刪除
DELETE FROM vw_customer_sales_flow WHERE `vw_customer_sales_flow`.`customer_id` = 253 AND `vw_customer_sales_flow`.`company_name` = '선우 ENG 주식회사' AND `vw_customer_sales_flow`.`quotation_id` IS NULL AND `vw_customer_sales_flow`.`quotation_status` IS NULL AND `vw_customer_sales_flow`.`project_id` IS NULL AND `vw_customer_sales_flow`.`project_status` IS NULL LIMIT 1
 		253 선우 ENG 주식회사 NULL NULL NULL NULL
編輯 編輯 複製 複製 刪除 刪除
DELETE FROM vw_customer_sales_flow WHERE `vw_customer_sales_flow`.`customer_id` = 813 AND `vw_customer_sales_flow`.`company_name` = '齊聯科技有限公司' AND `vw_customer_sales_flow`.`quotation_id` IS NULL AND `vw_customer_sales_flow`.`quotation_status` IS NULL AND `vw_customer_sales_flow`.`project_id` IS NULL AND `vw_customer_sales_flow`.`project_status` IS NULL LIMIT 1
 		813 齊聯科技有限公司 NULL NULL NULL NULL
編輯 編輯 複製 複製 刪除 刪除
DELETE FROM vw_customer_sales_flow WHERE `vw_customer_sales_flow`.`customer_id` = 197 AND `vw_customer_sales_flow`.`company_name` = '鼎豐精密科技有限公司' AND `vw_customer_sales_flow`.`quotation_id` IS NULL AND `vw_customer_sales_flow`.`quotation_status` IS NULL AND `vw_customer_sales_flow`.`project_id` IS NULL AND `vw_customer_sales_flow`.`project_status` IS NULL LIMIT 1
 		197 鼎豐精密科技有限公司 NULL NULL NULL NULL
編輯 編輯 複製 複製 刪除 刪除
DELETE FROM vw_customer_sales_flow WHERE `vw_customer_sales_flow`.`customer_id` = 802 AND `vw_customer_sales_flow`.`company_name` = '鼎元光電科技股份有限公司' AND `vw_customer_sales_flow`.`quotation_id` IS NULL AND `vw_customer_sales_flow`.`quotation_status` IS NULL AND `vw_customer_sales_flow`.`project_id` IS NULL AND `vw_customer_sales_flow`.`project_status` IS NULL LIMIT 1
 		802 鼎元光電科技股份有限公司 NULL NULL NULL NULL
編輯 編輯 複製 複製 刪除 刪除
DELETE FROM vw_customer_sales_flow WHERE `vw_customer_sales_flow`.`customer_id` = 1290 AND `vw_customer_sales_flow`.`company_name` = '默克光電科技股份有限公司' AND `vw_customer_sales_flow`.`quotation_id` IS NULL AND `vw_customer_sales_flow`.`quotation_status` IS NULL AND `vw_customer_sales_flow`.`project_id` IS NULL AND `vw_customer_sales_flow`.`project_status` IS NULL LIMIT 1
 		1290 默克光電科技股份有限公司 NULL NULL NULL NULL
編輯 編輯 複製 複製 刪除 刪除
DELETE FROM vw_customer_sales_flow WHERE `vw_customer_sales_flow`.`customer_id` = 46 AND `vw_customer_sales_flow`.`company_name` = '麦斯克电子材料(郑州)有限公司' AND `vw_customer_sales_flow`.`quotation_id` IS NULL AND `vw_customer_sales_flow`.`quotation_status` IS NULL AND `vw_customer_sales_flow`.`project_id` IS NULL AND `vw_customer_sales_flow`.`project_status` IS NULL LIMIT 1
 		46 麦斯克电子材料(郑州)有限公司 NULL NULL NULL NULL
編輯 編輯 複製 複製 刪除 刪除
DELETE FROM vw_customer_sales_flow WHERE `vw_customer_sales_flow`.`customer_id` = 306 AND `vw_customer_sales_flow`.`company_name` = '鴻海精密工業股份有限公司' AND `vw_customer_sales_flow`.`quotation_id` IS NULL AND `vw_customer_sales_flow`.`quotation_status` IS NULL AND `vw_customer_sales_flow`.`project_id` IS NULL AND `vw_customer_sales_flow`.`project_status` IS NULL LIMIT 1
 		306 鴻海精密工業股份有限公司 NULL NULL NULL NULL
編輯 編輯 複製 複製 刪除 刪除
DELETE FROM vw_customer_sales_flow WHERE `vw_customer_sales_flow`.`customer_id` = 1482 AND `vw_customer_sales_flow`.`company_name` = '鴻海精密工業股份有限公司' AND `vw_customer_sales_flow`.`quotation_id` = 94 AND `vw_customer_sales_flow`.`quotation_status` = 'draft' AND `vw_customer_sales_flow`.`project_id` IS NULL AND `vw_customer_sales_flow`.`project_status` IS NULL LIMIT 1
 		1482 鴻海精密工業股份有限公司 94 draft NULL NULL
編輯 編輯 複製 複製 刪除 刪除
DELETE FROM vw_customer_sales_flow WHERE `vw_customer_sales_flow`.`customer_id` = 509 AND `vw_customer_sales_flow`.`company_name` = '鴻新室裝修設計有限公司' AND `vw_customer_sales_flow`.`quotation_id` IS NULL AND `vw_customer_sales_flow`.`quotation_status` IS NULL AND `vw_customer_sales_flow`.`project_id` IS NULL AND `vw_customer_sales_flow`.`project_status` IS NULL LIMIT 1
 		509 鴻新室裝修設計有限公司 NULL NULL NULL NULL
編輯 編輯 複製 複製 刪除 刪除
DELETE FROM vw_customer_sales_flow WHERE `vw_customer_sales_flow`.`customer_id` = 12 AND `vw_customer_sales_flow`.`company_name` = '鴻揚半導體股份有限公司' AND `vw_customer_sales_flow`.`quotation_id` = 24 AND `vw_customer_sales_flow`.`quotation_status` = 'negotiating' AND `vw_customer_sales_flow`.`project_id` IS NULL AND `vw_customer_sales_flow`.`project_status` IS NULL LIMIT 1
 		12 鴻揚半導體股份有限公司 24 negotiating NULL NULL
編輯 編輯 複製 複製 刪除 刪除
DELETE FROM vw_customer_sales_flow WHERE `vw_customer_sales_flow`.`customer_id` = 326 AND `vw_customer_sales_flow`.`company_name` = '鴻揚半導體股份有限公司' AND `vw_customer_sales_flow`.`quotation_id` IS NULL AND `vw_customer_sales_flow`.`quotation_status` IS NULL AND `vw_customer_sales_flow`.`project_id` IS NULL AND `vw_customer_sales_flow`.`project_status` IS NULL LIMIT 1
 		326 鴻揚半導體股份有限公司 NULL NULL NULL NULL
編輯 編輯 複製 複製 刪除 刪除
DELETE FROM vw_customer_sales_flow WHERE `vw_customer_sales_flow`.`customer_id` = 327 AND `vw_customer_sales_flow`.`company_name` = '鴻揚半導體股份有限公司' AND `vw_customer_sales_flow`.`quotation_id` IS NULL AND `vw_customer_sales_flow`.`quotation_status` IS NULL AND `vw_customer_sales_flow`.`project_id` IS NULL AND `vw_customer_sales_flow`.`project_status` IS NULL LIMIT 1
 		327 鴻揚半導體股份有限公司 NULL NULL NULL NULL
編輯 編輯 複製 複製 刪除 刪除
DELETE FROM vw_customer_sales_flow WHERE `vw_customer_sales_flow`.`customer_id` = 12 AND `vw_customer_sales_flow`.`company_name` = '鴻揚半導體股份有限公司' AND `vw_customer_sales_flow`.`quotation_id` = 10 AND `vw_customer_sales_flow`.`quotation_status` = 'replaced' AND `vw_customer_sales_flow`.`project_id` IS NULL AND `vw_customer_sales_flow`.`project_status` IS NULL LIMIT 1
 		12 鴻揚半導體股份有限公司 10 replaced NULL NULL
編輯 編輯 複製 複製 刪除 刪除
DELETE FROM vw_customer_sales_flow WHERE `vw_customer_sales_flow`.`customer_id` = 296 AND `vw_customer_sales_flow`.`company_name` = '鴻揚半導體股份有限公司' AND `vw_customer_sales_flow`.`quotation_id` IS NULL AND `vw_customer_sales_flow`.`quotation_status` IS NULL AND `vw_customer_sales_flow`.`project_id` IS NULL AND `vw_customer_sales_flow`.`project_status` IS NULL LIMIT 1
 		296 鴻揚半導體股份有限公司 NULL NULL NULL NULL
編輯 編輯 複製 複製 刪除 刪除
DELETE FROM vw_customer_sales_flow WHERE `vw_customer_sales_flow`.`customer_id` = 12 AND `vw_customer_sales_flow`.`company_name` = '鴻揚半導體股份有限公司' AND `vw_customer_sales_flow`.`quotation_id` = 12 AND `vw_customer_sales_flow`.`quotation_status` = 'sent' AND `vw_customer_sales_flow`.`project_id` IS NULL AND `vw_customer_sales_flow`.`project_status` IS NULL LIMIT 1
 		12 鴻揚半導體股份有限公司 12 sent NULL NULL
編輯 編輯 複製 複製 刪除 刪除
DELETE FROM vw_customer_sales_flow WHERE `vw_customer_sales_flow`.`customer_id` = 815 AND `vw_customer_sales_flow`.`company_name` = '鰲誤鑫化氣體科技术有限公司' AND `vw_customer_sales_flow`.`quotation_id` IS NULL AND `vw_customer_sales_flow`.`quotation_status` IS NULL AND `vw_customer_sales_flow`.`project_id` IS NULL AND `vw_customer_sales_flow`.`project_status` IS NULL LIMIT 1
 		815 鰲誤鑫化氣體科技术有限公司 NULL NULL NULL NULL
編輯 編輯 複製 複製 刪除 刪除
DELETE FROM vw_customer_sales_flow WHERE `vw_customer_sales_flow`.`customer_id` = 788 AND `vw_customer_sales_flow`.`company_name` = '高芯科技' AND `vw_customer_sales_flow`.`quotation_id` IS NULL AND `vw_customer_sales_flow`.`quotation_status` IS NULL AND `vw_customer_sales_flow`.`project_id` IS NULL AND `vw_customer_sales_flow`.`project_status` IS NULL LIMIT 1
 		788 高芯科技 NULL NULL NULL NULL
編輯 編輯 複製 複製 刪除 刪除
DELETE FROM vw_customer_sales_flow WHERE `vw_customer_sales_flow`.`customer_id` = 550 AND `vw_customer_sales_flow`.`company_name` = '高平磊晶科技股份有限公司' AND `vw_customer_sales_flow`.`quotation_id` IS NULL AND `vw_customer_sales_flow`.`quotation_status` IS NULL AND `vw_customer_sales_flow`.`project_id` IS NULL AND `vw_customer_sales_flow`.`project_status` IS NULL LIMIT 1
 		550 高平磊晶科技股份有限公司 NULL NULL NULL NULL
編輯 編輯 複製 複製 刪除 刪除
DELETE FROM vw_customer_sales_flow WHERE `vw_customer_sales_flow`.`customer_id` = 1394 AND `vw_customer_sales_flow`.`company_name` = '馬來西亞商科藝工程有限公司台灣分公司' AND `vw_customer_sales_flow`.`quotation_id` IS NULL AND `vw_customer_sales_flow`.`quotation_status` IS NULL AND `vw_customer_sales_flow`.`project_id` IS NULL AND `vw_customer_sales_flow`.`project_status` IS NULL LIMIT 1
 		1394 馬來西亞商科藝工程有限公司台灣分公司 NULL NULL NULL NULL
編輯 編輯 複製 複製 刪除 刪除
DELETE FROM vw_customer_sales_flow WHERE `vw_customer_sales_flow`.`customer_id` = 652 AND `vw_customer_sales_flow`.`company_name` = '香港商台灣美埃有限公司' AND `vw_customer_sales_flow`.`quotation_id` IS NULL AND `vw_customer_sales_flow`.`quotation_status` IS NULL AND `vw_customer_sales_flow`.`project_id` IS NULL AND `vw_customer_sales_flow`.`project_status` IS NULL LIMIT 1
 		652 香港商台灣美埃有限公司 NULL NULL NULL NULL
編輯 編輯 複製 複製 刪除 刪除
DELETE FROM vw_customer_sales_flow WHERE `vw_customer_sales_flow`.`customer_id` = 1312 AND `vw_customer_sales_flow`.`company_name` = '香岳實業股份有限公司' AND `vw_customer_sales_flow`.`quotation_id` IS NULL AND `vw_customer_sales_flow`.`quotation_status` IS NULL AND `vw_customer_sales_flow`.`project_id` IS NULL AND `vw_customer_sales_flow`.`project_status` IS NULL LIMIT 1
 		1312 香岳實業股份有限公司 NULL NULL NULL NULL
編輯 編輯 複製 複製 刪除 刪除
DELETE FROM vw_customer_sales_flow WHERE `vw_customer_sales_flow`.`customer_id` = 761 AND `vw_customer_sales_flow`.`company_name` = '饔斯吸(南京)有限公司 上海褰斯化分公司' AND `vw_customer_sales_flow`.`quotation_id` IS NULL AND `vw_customer_sales_flow`.`quotation_status` IS NULL AND `vw_customer_sales_flow`.`project_id` IS NULL AND `vw_customer_sales_flow`.`project_status` IS NULL LIMIT 1
 		761 饔斯吸(南京)有限公司 上海褰斯化分公司 NULL NULL NULL NULL
編輯 編輯 複製 複製 刪除 刪除
DELETE FROM vw_customer_sales_flow WHERE `vw_customer_sales_flow`.`customer_id` = 939 AND `vw_customer_sales_flow`.`company_name` = '霖豐股份有限公司' AND `vw_customer_sales_flow`.`quotation_id` IS NULL AND `vw_customer_sales_flow`.`quotation_status` IS NULL AND `vw_customer_sales_flow`.`project_id` IS NULL AND `vw_customer_sales_flow`.`project_status` IS NULL LIMIT 1
 		939 霖豐股份有限公司 NULL NULL NULL NULL
已選擇項目： 已選擇項目：
|
|
|
|
篩選資料列:
查詢結果選項 複製到剪貼簿 複製到剪貼簿 匯出 匯出 顯示圖表 顯示圖表 新增檢視表 新增檢視表
將此 SQL 查詢加為書籤 將此 SQL 查詢加為書籤