mql − A front-end to the Emdros engine using the MQL query language
mql [
options ] filename
mql [ options ]
mql is a front-end to Emdros using the MQL query language. If a filename is given on the command-line, the contents of that file are piped through the MQL engine. If no filename is given on the command-line, stdin is used to get the MQL input. The output is given on stdout, or on stderr if unsuccessful.
mql
supports the following command-line switches:
−−help
show help
−V , −−version
show version
−−xml
output-format is XML
−−cxml
output-format is compact XML
−−console
output-format is console (this is the default)
−−incomplete-output
the caller is prepared to expect incomplete output. The tradeoff is that, with this option, we gain some speed due to flushing the output buffer all the time being unnecessary.
−d , −−dbname dbname
set initial dbname (default is ’emdf’)
−h , −−host hostname
set db back-end hostname to connect to (default is ’localhost’). Has no effect on SQLite.
−u , −−user user
set database user to connect as (default is ’emdf’). Has no effect on SQLite.
−p , −−password password
set password to use for the database user. Has no effect on SQLite, unless you have an encryption-enabled SQLite, in which case this gets passed as the key.
−b , −−backend backend
set database backend to ‘backend’. Valid values are: For PostgreSQL: "p", "pg", "postgres", and "postgresql". For MySQL: "m", "my", and "mysql". For SQLite 2.X.X: "2", "s", "l", "lt", "sqlite", and "sqlite2". For SQLite 3.X.X: "3", "s3", "lt3", and "sqlite3".
−n , −−nop
do not print results (no output)
0
Success
1 Wrong usage
2 Connection to backend server could not be established
3 An exception occurred (the type is printed on stderr)
4 Could not open file
5 Database error
6 Compiler error (error in MQL input)
Written Ulrik Sandborg-Petersen (ulrikp@emdros.org).