💾 Archived View for freeshell.de › tldr › q.gmi captured on 2022-06-11 at 23:40:36. Gemini links have been rewritten to link to archived content

View Raw

More Information

⬅️ Previous capture (2022-04-28)

-=-=-=-=-=-=-

q

Execute SQL-like queries on .csv and .tsv files.

More information.

q -d',' "SELECT * from {path/to/file}"
q -t "SELECT * from {path/to/file}"
q -d{delimiter} -H "SELECT * from {path/to/file}"
{output} | q "select * from -"
q "SELECT * FROM {path/to/file} f1 JOIN {path/to/other_file} f2 ON (f1.c1 = f2.c1)"
q -D{delimiter} -O "SELECT {column} as {alias} from {path/to/file}"
Copyright © 2014—present the tldr-pages team and contributors.
This work is licensed under the Creative Commons Attribution 4.0 International License (CC-BY).

CC-BY