大网数据广告活动
Linux 与通用命令

trdsql · 常用命令示例

· 52CE 我爱测

Execute SQL on CSV, LTSV, JSON, YAML, and TBLN files. > More information: <https://noborus.github.io/trdsql/>.

trdsql

Execute SQL on CSV, LTSV, JSON, YAML, and TBLN files. More information: https://noborus.github.io/trdsql/.

  • Convert object data from multiple JSON files to a CSV file with header (-oh) and double quote:

trdsql -ocsv -oh "SELECT * FROM " | sed 's/\([^,]*\)/"&"/g' >

  • Interpret JSON list as a table and put objects inside as columns (path/to/file.json: {"list":[{"age":"26","name":"Tanaka"}]}):

trdsql "SELECT * FROM ::.list"

  • Manipulate complex SQL query with data from multiple CSV files with first line is header (-ih):

trdsql -icsv -ih "SELECT FROM WHERE column2 != '' ORDER BY GROUP BY "

  • Merge content of 2 CSV files to one CSV file:

trdsql "SELECT FROM UNION SELECT FROM "

  • Connect to PostgreSQL database:

trdsql -driver postgres -dsn "host= port= dbname=" "SELECT 1"

  • Create table data to MySQL database from CSV file:

trdsql -driver mysql -dsn ":@/" -ih "CREATE TABLE ( int, varchar(20)) AS SELECT AS , FROM "

  • Show data from compress log files:

trdsql -iltsv "SELECT * FROM "

来源:tldr-pages contributors · 作者与贡献记录 · CC BY 4.0。离线整理了版式、链接和媒体显示。

资料来源与适用范围

资料来源
tldr-pages contributors
适用范围
请按文中版本与环境说明核对
内容语言
中文;命令、路径和错误标识保留技术原文
本地收录日期
2026-11-15
授权说明
CC BY 4.0

正文与所需资源由本站本地存储。查看来源及更新记录 ↗

请按适用版本和实际日志确认原因;本站没有对每一种系统或设备逐项执行文中的操作。