.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