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。离线整理了版式、链接和媒体显示。
