diff options
| author | drh <drh@noemail.net> | 2000-08-08 20:19:09 +0000 |
|---|---|---|
| committer | drh <drh@noemail.net> | 2000-08-08 20:19:09 +0000 |
| commit | a50da106f04f3dd6eb07655927f20f9afacb6c7f (patch) | |
| tree | ac3f25d693ca4c4713673fb5d3bb4930fe45d90c /www/sqlite.tcl | |
| parent | 4cdc9e8488d3e59cadefc89b4b65436e4d9db96c (diff) | |
| download | sqlite-a50da106f04f3dd6eb07655927f20f9afacb6c7f.tar.gz sqlite-a50da106f04f3dd6eb07655927f20f9afacb6c7f.zip | |
Add pattern matching to the .table command (CVS 129)
FossilOrigin-Name: 2b3511eca7e562ef2428cec2f7eeca1d26b6c1c8
Diffstat (limited to 'www/sqlite.tcl')
| -rw-r--r-- | www/sqlite.tcl | 21 |
1 files changed, 19 insertions, 2 deletions
diff --git a/www/sqlite.tcl b/www/sqlite.tcl index ed3bb31a7..48b00b113 100644 --- a/www/sqlite.tcl +++ b/www/sqlite.tcl @@ -1,7 +1,7 @@ # # Run this Tcl script to generate the sqlite.html file. # -set rcsid {$Id: sqlite.tcl,v 1.12 2000/08/04 13:49:03 drh Exp $} +set rcsid {$Id: sqlite.tcl,v 1.13 2000/08/08 20:19:09 drh Exp $} puts {<html> <head> @@ -399,7 +399,24 @@ ORDER BY type DESC, name </pre></blockquote> <p>The <b>%s</b> in the query above is replaced by the argument -to ".schema", of course.</p> +to ".schema", of course. Notice that the argument to the ".schema" +command appears to the right of an SQL LIKE operator. So you can +use wildcards in the name of the table. For example, to get the +schema for all tables whose names contain the character string +"abc" you could enter:</p>} + +Code { +sqlite> (((.schema %abc%))) +} + +puts { +<p> +Along these same lines, +the ".table" command also accepts a pattern as its first argument. +If you give an argument to the .table command, a "%" is both +appended and prepended and a LIKE clause is added to the query. +This allows you to list only those tables that match a particular +pattern.</p> <h2>Converting An Entire Database To An ASCII Text File</h2> |