Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Update the ATTACH documentation to allow an expression as the filename parameter. Core ticket http://www.sqlite.org/src/info/9013e13dba. |
|---|---|
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
be0c879c12562eb5c9b7ed729355508f |
| User & Date: | drh 2011-02-04 00:52:55 |
Context
|
2011-02-05
| ||
| 17:00 | Update the description of fts4aux in fts3.in to account for recent changes. check-in: 8e18201f14 user: dan tags: trunk | |
|
2011-02-04
| ||
| 00:52 | Update the ATTACH documentation to allow an expression as the filename parameter. Core ticket http://www.sqlite.org/src/info/9013e13dba. check-in: be0c879c12 user: drh tags: trunk | |
|
2011-02-03
| ||
| 19:06 | Update fts3.html to describe the fts4aux module and the fts4 compress/uncompress options. check-in: ead2cc60ef user: dan tags: trunk | |
Changes
Changes to art/syntax/attach-stmt.gif.
cannot compute difference between binary files
Changes to art/syntax/bubble-generator-data.tcl.
55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 |
}
}
analyze-stmt {
line ANALYZE {or nil /database-name /table-name
{line /database-name . /table-name}}
}
attach-stmt {
line ATTACH {or DATABASE nil} /filename AS /database-name
}
begin-stmt {
line BEGIN {or nil DEFERRED IMMEDIATE EXCLUSIVE}
{optx TRANSACTION}
}
commit-stmt {
line {or COMMIT END} {optx TRANSACTION}
|
| |
55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 |
}
}
analyze-stmt {
line ANALYZE {or nil /database-name /table-name
{line /database-name . /table-name}}
}
attach-stmt {
line ATTACH {or DATABASE nil} expr AS /database-name
}
begin-stmt {
line BEGIN {or nil DEFERRED IMMEDIATE EXCLUSIVE}
{optx TRANSACTION}
}
commit-stmt {
line {or COMMIT END} {optx TRANSACTION}
|
Changes to pages/lang.in.
225 226 227 228 229 230 231 232 233 234 235 236 237 238 |
Section {ATTACH DATABASE} attach *ATTACH
BubbleDiagram attach-stmt 1
</tcl>
<p> ^The ATTACH DATABASE statement adds another database
file to the current [database connection].
^The database-names 'main' and
'temp' refer to the main database and the database used for
temporary tables. ^The main and temp databases cannot be attached or
detached.</p>
<p> ^(Tables in an attached database can be referred to using the syntax
<i>database-name.table-name</i>.)^ ^If the name of the table is unique
|
> > > > > > > > |
225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 |
Section {ATTACH DATABASE} attach *ATTACH
BubbleDiagram attach-stmt 1
</tcl>
<p> ^The ATTACH DATABASE statement adds another database
file to the current [database connection].
^The filename for the database to be attached is the value of
the expression that occurs before the AS keyword.
^The filename of the database follows the same semantics as the
filename argument to [sqlite3_open()] and [sqlite3_open_v2()]; the
special name "[:memory:]" results in an in-memory database and an
empty string results in a new temporary database.
The name that occurs after the AS keyword is the name of the database
used internally by SQLite.
^The database-names 'main' and
'temp' refer to the main database and the database used for
temporary tables. ^The main and temp databases cannot be attached or
detached.</p>
<p> ^(Tables in an attached database can be referred to using the syntax
<i>database-name.table-name</i>.)^ ^If the name of the table is unique
|