mdb-sql [-HFp] [-d delimiter] [-i file] [-o file] [database]
mdb-sql is a utility program distributed with MDB Tools.
mdb-sql allows querying of an MDB database using a limited SQL subset language.
mdb-sql in interactive mode takes some special commands.
reset A batch can be cleared using the 'reset' command.
The currently implemented SQL subset is quite small, supporting only single table queries, no aggregates, and limited support for WHERE clauses. Here is a brief synopsis of the supported language.
When passing a file (-i) or piping output to mdb-sql the final 'go' is optional. This allow constructs like
echo "Select * from Table1" | mdb-sql mydb.mdb
to work correctly.
The -i command can be passed the string 'stdin' to test entering text as if using a pipe.
mdb-sql first appeared in MDB Tools 0.3.
gmdb2(1) mdb-export(1) mdb-hexdump(1) mdb-prop(1) mdb-ver(1) mdb-array(1) mdb-header(1) mdb-parsecsv(1) mdb-schema(1) mdb-tables(1) isql(1)
The mdb-sql utility was written by Brian Bruns.
The supported SQL syntax is a very limited subset and deficient in several ways.