.DT
sqlcmd
Discworld creator help
sqlcmd

.SH Name
.SI 5
sqlcmd - make a sql request
.EI

.SH Syntax
.SI 5
sqlcmd <database> "<query>"
.EI

.SH Description
.SP 5 5
This lets you make a single, non-blocking request to the MySQL daemon.  Queries follow the format of any standard SQL query.  See http://www.mysql.com/doc/ for documentation on formatting queries.

The result of the query is returned via a tell_creator in the call back function.

The standard database is 'discworld'.
.EP

.SH Examples
> sqlcmd discworld "select count( * ) from Tricks"
> /cmds/creator/sqlcmd:
flag: 0
({ /* sizeof() == 1 */
  ([ /* sizeof() == 1 */
    "count( * )" : 361,
  ])
})

> sqlcmd discworld "select TrickId, TrickName from Tricks where Author='tannah'"

> /cmds/creator/sqlcmd:
flag: 0
({ /* sizeof() == 3 */
  ([ /* sizeof() == 2 */
    "TrickName" : "tannah's trick of rememberin",
    "TrickId" : 139,
  ]),
  ([ /* sizeof() == 2 */
    "TrickName" : "leetle trick",
    "TrickId" : 369,
  ]),
  ([ /* sizeof() == 2 */
    "TrickName" : "wossit",
    "TrickId" : 370,
  ])
})

.SI 5
.EI

.SH See also
.SP 5 5
sql
.EP
