ql: modernc.org/ql/ql Files

Command ql

Command ql is a utility to explore a database, prototype a schema or test drive a query, etc.


$ go get modernc.org/ql/ql


ql [-db name] [-schema regexp] [-tables regexp] [-fld] statement_list


-db name	Name of the database to use. Defaults to "ql.db".
		If the DB file does not exists it is created automatically.

-schema re	If re != "" show the CREATE statements of matching tables and exit.

-tables re	If re != "" show the matching table names and exit.

-fld		First row of a query result set will show field names.

statement_list	QL statements to execute.
		If no non flag arguments are present, ql reads from stdin.
		The list is wrapped into an automatic transaction.

-t		Report and measure time to execute, including creating/opening and closing the DB.


$ ql 'create table t (i int, s string)'
$ ql << EOF
> insert into t values
> (1, "a"),
> (2, "b"),
> (3, "c"),
$ ql 'select * from t'
3, "c"
2, "b"
1, "a"
$ ql -fld 'select * from t where i != 2 order by s'
"i", "s"
1, "a"
3, "c"

Package Files


Package main imports 12 packages (graph). Updated 2019-04-24. Refresh now. Tools for package owners.