匯出
功能性的以下一位接手的人或工具真正用得上的格式傳送結果。
一 匯出… 命令(可從格線選單或工具列開啟),會為任何結果集開啟同一個對話方塊。挑選格式,選擇 複製到剪貼簿 或 儲存到檔案…,就完成了。標準資料格式和程式語言產生器放在一起,用不到的格式可以在 設定 › 結果 › 匯出.


NULL 如何寫入、儲存格內的換行如何處理、是否包含表頭、選用的 gzip,以及批次檔名的模式 {schema}_{table}_{date}.{format}.sqlly query 在命令列上。若橋接器執行的是這個版本,透過中繼連線也是一樣;較舊的橋接器會把每個儲存格完整送出,因此網格回報不了預覽,而單列超過 16 MiB 就會讓查詢失敗。以下每個範例都匯出這個兩列的小結果集:
SELECT id, customer, amount, created FROM orders;
-- id | customer | amount | created
-- 1 | Acme | 1250.00 | 2026-09-01
-- 2 | Globex | 890.50 | 2026-09-02
標準格式
CSV .csv
以逗號分隔,使用 RFC 風格的引號。Excel 相容的版本會額外加上 UTF-8 BOM。
id,customer,amount,created
1,Acme,1250.00,2026-09-01
2,Globex,890.50,2026-09-02
TSV .tsv
Tab 分隔 - 方便貼入試算表。
id customer amount created
1 Acme 1250.00 2026-09-01
2 Globex 890.50 2026-09-02
JSON .json
物件陣列,每列一個物件。
[
{ "id": 1, "customer": "Acme", "amount": 1250.00, "created": "2026-09-01" },
{ "id": 2, "customer": "Globex", "amount": 890.50, "created": "2026-09-02" }
]
JSON Lines .jsonl
每行一個 JSON 物件,適合串流與日誌管線。
{"id":1,"customer":"Acme","amount":1250.00,"created":"2026-09-01"}
{"id":2,"customer":"Globex","amount":890.50,"created":"2026-09-02"}
Markdown .md
含分隔列的管線表格;儲存格內的管線符號會被逸出。
| id | customer | amount | created |
| -- | -------- | ------- | ---------- |
| 1 | Acme | 1250.00 | 2026-09-01 |
| 2 | Globex | 890.50 | 2026-09-02 |
HTML .html
一個獨立的 <table>.
<table>
<thead><tr><th>id</th><th>customer</th><th>amount</th><th>created</th></tr></thead>
<tbody>
<tr><td>1</td><td>Acme</td><td>1250.00</td><td>2026-09-01</td></tr>
<tr><td>2</td><td>Globex</td><td>890.50</td><td>2026-09-02</td></tr>
</tbody>
</table>
XML .xml
每個元素一列的文件。
<rows>
<row>
<id>1</id>
<customer>Acme</customer>
<amount>1250.00</amount>
<created>2026-09-01</created>
</row>
<row>
<id>2</id>
<customer>Globex</customer>
<amount>890.50</amount>
<created>2026-09-02</created>
</row>
</rows>
INSERT .sql
INSERT 語句,並依連線的方言加上引號([brackets] 用於 SQL Server、反引號用於 MySQL 和 ClickHouse、雙引號用於 PostgreSQL、SQLite、DuckDB 和 Oracle),字面值則以該引擎想要的方式呈現。
INSERT INTO orders (id, customer, amount, created) VALUES
(1, 'Acme', 1250.00, '2026-09-01'),
(2, 'Globex', 890.50, '2026-09-02');
暫存資料表 .sql
A CREATE 針對臨時資料表加上插入語句 - 一個自包含的快照,可以貼到另一個工作階段中。支持方言識別。
CREATE TABLE #orders (
id INT,
customer NVARCHAR(4000),
amount DECIMAL(18,2),
created DATE
);
INSERT INTO #orders (id, customer, amount, created) VALUES
(1, 'Acme', 1250.00, '2026-09-01'),
(2, 'Globex', 890.50, '2026-09-02');
SQL 值 .sql
一個單純的 VALUES 清單,可以拖放進 CTE 或 IN 子句。可辨識方言。
VALUES
(1, 'Acme', 1250.00, '2026-09-01'),
(2, 'Globex', 890.50, '2026-09-02')
Excel (XLSX) .xlsx
一個真實的 .xlsx 工作簿——一張套用格式的 Excel 資料表,含交錯列底色與自動篩選標題。它會保留你看到的網格:欄位順序、寬度、隱藏與凍結欄位、數字與日期格式,以及條件式格式設定。計算欄位會變成可運算的 Excel 公式,已設定的樞紐分析會多一張工作表。因為是二進位格式,只能儲存成檔案(停用剪貼簿)。細節請見 Excel 匯出.
SQLLY 匯出 .sqllyexport
SQLly 專屬的信封格式——內含資料列及其欄位類型與中繼資料,可無損地匯回 SQLly。
程式設計格式
這些產生器會輸出可直接貼上的原始程式碼,把結果資料列以資料形式嵌入,適合用來做測試資料(fixture)、種子資料和快速腳本。每種語言各一個範例:
C# .cs
var rows = new[]
{
new { Id = 1, Customer = "Acme", Amount = 1250.00m, Created = "2026-09-01" },
new { Id = 2, Customer = "Globex", Amount = 890.50m, Created = "2026-09-02" },
};
Python .py
rows = [
{"id": 1, "customer": "Acme", "amount": 1250.00, "created": "2026-09-01"},
{"id": 2, "customer": "Globex", "amount": 890.50, "created": "2026-09-02"},
]
Rust .rs
struct Order { id: i64, customer: &'static str, amount: f64, created: &'static str }
let rows = vec![
Order { id: 1, customer: "Acme", amount: 1250.00, created: "2026-09-01" },
Order { id: 2, customer: "Globex", amount: 890.50, created: "2026-09-02" },
];
JavaScript .js
const rows = [
{ id: 1, customer: "Acme", amount: 1250.00, created: "2026-09-01" },
{ id: 2, customer: "Globex", amount: 890.50, created: "2026-09-02" },
];
TypeScript .ts
interface Order { id: number; customer: string; amount: number; created: string; }
const rows: Order[] = [
{ id: 1, customer: "Acme", amount: 1250.00, created: "2026-09-01" },
{ id: 2, customer: "Globex", amount: 890.50, created: "2026-09-02" },
];
Kotlin .kt
data class Order(val id: Int, val customer: String, val amount: Double, val created: String)
val rows = listOf(
Order(1, "Acme", 1250.00, "2026-09-01"),
Order(2, "Globex", 890.50, "2026-09-02"),
)
Swift .swift
struct Order { let id: Int; let customer: String; let amount: Double; let created: String }
let rows = [
Order(id: 1, customer: "Acme", amount: 1250.00, created: "2026-09-01"),
Order(id: 2, customer: "Globex", amount: 890.50, created: "2026-09-02"),
]
Java .java
record Order(int id, String customer, double amount, String created) {}
List<Order> rows = List.of(
new Order(1, "Acme", 1250.00, "2026-09-01"),
new Order(2, "Globex", 890.50, "2026-09-02")
);
開始 .go
type Order struct {
ID int
Customer string
Amount float64
Created string
}
rows := []Order{
{1, "Acme", 1250.00, "2026-09-01"},
{2, "Globex", 890.50, "2026-09-02"},
}
PHP .php
$rows = [
['id' => 1, 'customer' => 'Acme', 'amount' => 1250.00, 'created' => '2026-09-01'],
['id' => 2, 'customer' => 'Globex', 'amount' => 890.50, 'created' => '2026-09-02'],
];
C++ .cpp
struct Order { int id; std::string customer; double amount; std::string created; };
std::vector<Order> rows = {
{1, "Acme", 1250.00, "2026-09-01"},
{2, "Globex", 890.50, "2026-09-02"},
};
精確的欄位名稱、類型以及值的引用方式遵循結果的欄位及你的連線方言,上述範例具有代表性。任何你不使用的格式都可以隱藏在 設定 › 結果 › 匯出.