Hi Brannon,
Try this:
SQLite version 3.3.6
Enter ".help" for instructions
sql3> .help
.databases List names and files of
attached databases
.dump ?TABLE? ... Dump the database in an SQL
text format
.echo ON|OFF Turn command echo on or off
.exit Exit this program
.explain ON|OFF Turn output mode suitable for
EXPLAIN on or off.
.feedback ON|OFF Print number of rows
selected/affected on or off.
.header(s) ON|OFF Turn display of headers on or
off
.help Show this message
.import FILE TABLE Import data from FILE into
TABLE
.indices TABLE Show names of all indices on
TABLE
.mode MODE ?TABLE? Set output mode where MODE is
one of:
csv Comma-separated
values
column Left-aligned
columns. (See .width)
html HTML <table> code
insert SQL insert
statements for TABLE
line One value per line
list Values delimited by
.separator string
tabs Tab-separated values
tcl TCL list elements
.newline Print a new line
.noprint ON|OFF No output
.nullvalue STRING Print STRING in place of NULL
values
.output FILENAME Send output to FILENAME
.output stdout Send output to the screen
.prompt MAIN CONTINUE Replace the standard prompts
.quit Exit this program
.read FILENAME Execute SQL in FILENAME
.schema ?TABLE? Show the CREATE statements
.separator STRING Change separator used by output
mode and .import
.show Show the current values for
various settings
.tables ?PATTERN? List names of tables matching a
LIKE pattern
.timeout MS Try opening locked tables for
MS milliseconds
.timing ON|OFF Turn elapsed time on or off
.width NUM NUM ... Set column widths for "column"
mode
sql3>
changes are:
feedback
noprint
newline
timing
--- Brannon King <[EMAIL PROTECTED]> wrote:
> I'd like to modify the shell.c so that I get an
> "time taken" output with
> each query executed (similar to the mysql client).
> Where would I put the
> start and stop/print code in shell.c so that I
> capture the query time but
> not the time required to output the data to the
> console? Thanks.
>
> ______________________________
> Brannon King
> ¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯
>
>
>
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
