diff options
-rw-r--r-- | README.markdown | 8 | ||||
-rw-r--r-- | doc/basic-examples.png | bin | 6635 -> 0 bytes |
2 files changed, 6 insertions, 2 deletions
diff --git a/README.markdown b/README.markdown index 85863af..9477de3 100644 --- a/README.markdown +++ b/README.markdown @@ -3,7 +3,7 @@ # q - Text as Data q is a command line tool that allows direct execution of SQL-like queries on CSVs/TSVs (and any other tabular text files). -q treats ordinary files as database tables, and supports all SQL constructs, such as WHERE, GROUP BY, JOINs etc. It supports automatic column name and type detection, and q provides full support for multiple character encodings. +q treats ordinary files as database tables, and supports all SQL constructs, such as `WHERE`, `GROUP BY`, `JOIN`s, etc. It supports automatic column name and type detection, and q provides full support for multiple character encodings. q's web site is [http://harelba.github.io/q/](http://harelba.github.io/q/). It contains everything you need to download and use q immediately. @@ -14,7 +14,11 @@ Instructions for all OSs are [here](http://harelba.github.io/q/install.html). ## Examples -![blah](doc/basic-examples.png) +``` +q "SELECT COUNT(*) FROM ./clicks_file.csv WHERE c3 > 32.3" + +ps -ef | q -H "SELECT UID, COUNT(*) cnt FROM - GROUP BY UID ORDER BY cnt DESC LIMIT 3" +``` Go [here](http://harelba.github.io/q/examples.html) for more examples. diff --git a/doc/basic-examples.png b/doc/basic-examples.png Binary files differdeleted file mode 100644 index 6943d47..0000000 --- a/doc/basic-examples.png +++ /dev/null |