Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | :-) (CVS 85) |
|---|---|
| Downloads: | Tarball | ZIP archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
8b1c151b7b2243672a0bf0ac8377e82c |
| User & Date: | drh 2000-06-08 19:43:40.000 |
Context
|
2000-06-08
| ||
| 21:53 | :-) (CVS 86) (check-in: 049abcb37d user: drh tags: trunk) | |
| 19:43 | :-) (CVS 85) (check-in: 8b1c151b7b user: drh tags: trunk) | |
| 19:38 | :-) (CVS 84) (check-in: 57dce04add user: drh tags: trunk) | |
Changes
Changes to www/sqlite.tcl.
1 2 3 | # # Run this Tcl script to generate the sqlite.html file. # | | | 1 2 3 4 5 6 7 8 9 10 11 |
#
# Run this Tcl script to generate the sqlite.html file.
#
set rcsid {$Id: sqlite.tcl,v 1.8 2000/06/08 19:43:40 drh Exp $}
puts {<html>
<head>
<title>sqlite: A program of interacting with SQLite databases</title>
</head>
<body bgcolor=white>
<h1 align=center>
|
| ︙ | ︙ | |||
163 164 165 166 167 168 169 | <h2>Changing Output Formats</h2> <p>The sqlite program is able to show the results of a query in four different formats: "line", "column", "list", and "html". You can use the ".mode" dot command to switch between these three output formats.</p> | < | 163 164 165 166 167 168 169 170 171 172 173 174 175 176 |
<h2>Changing Output Formats</h2>
<p>The sqlite program is able to show the results of a query
in four different formats: "line", "column", "list", and "html".
You can use the ".mode" dot command to switch between these three output
formats.</p>
<p>The default output mode is "list". In
list mode, each record of a query result is written on one line of
output and each field within that record is separated by a specific
separator string. The default separator is a pipe symbol ("|").
List mode is especially useful when you are going to send the output
of a query to another program (such as AWK) for additional processing.</p>}
|
| ︙ | ︙ | |||
192 193 194 195 196 197 198 199 200 201 202 203 204 205 |
sqlite> (((.separator ", ")))
sqlite> (((select * from tbl1;)))
hello, 10
goodbye, 20
sqlite>
}
<p>In "line" mode, each field in a record of the database
is shown on a line by itself. Each line consists of the field
name, an equal sign and the field data. Successive records are
separated by a blank line. Here is an example of line mode
output:</p>}
Code {
| > | 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 |
sqlite> (((.separator ", ")))
sqlite> (((select * from tbl1;)))
hello, 10
goodbye, 20
sqlite>
}
puts {
<p>In "line" mode, each field in a record of the database
is shown on a line by itself. Each line consists of the field
name, an equal sign and the field data. Successive records are
separated by a blank line. Here is an example of line mode
output:</p>}
Code {
|
| ︙ | ︙ | |||
261 262 263 264 265 266 267 |
goodbye 20
sqlite>
}
puts {
<p>The last output mode is "html". In this mode, sqlite writes
the results of the query as an XHTML table. The beginning
| | | 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 |
goodbye 20
sqlite>
}
puts {
<p>The last output mode is "html". In this mode, sqlite writes
the results of the query as an XHTML table. The beginning
<TABLE> and the ending </TABLE> are not written, but
all of the intervening <TR>s, <TH>s, and <TD>s
are. The html output mode is envisioned as being useful for
CGI.</p>
}
puts {
<h2>Writing results to a file</h2>
|
| ︙ | ︙ |