Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
| Comment: | Fixed typo in PRAGMA documentation. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
bd71688bcb3740acc962636ec1260821 |
| User & Date: | mihailim 2008-07-04 13:40:55 |
|
2008-07-10
| ||
| 16:52 | Add documentation on SQLITE_ENABLE_MEMSYS3/5. (check-in: ecf5c9238d user: drh tags: trunk) | |
|
2008-07-04
| ||
| 13:40 | Fixed typo in PRAGMA documentation. (check-in: bd71688bcb user: mihailim tags: trunk) | |
|
2008-06-28
| ||
| 13:31 | Copy the date+time function documentation out of the wiki. (check-in: 5178724f27 user: drh tags: trunk) | |
Changes to pages/pragma.in.
480 481 482 483 484 485 486 487 488 489 490 491 492 493 494 |
<tcl>Subsection short_column_names</tcl>
<li><p><b>PRAGMA short_column_names;
<br>PRAGMA short_column_names = </b><i>0 | 1</i><b>;</b></p>
<p>Query or change the short-column-names flag. This flag affects
the way SQLite names columns of data returned by [SELECT] statements
when the expression for the column is a table-column name or the
wildcard "*". Normally, such result columns are named
<table-name/alias>lt;column-name> if the [SELECT] statement
joins two or more tables together, or simply <column-name> if
the [SELECT] statement queries a single table. When the short-column-names
flag is set, such columns are always named <column-name>
regardless of whether or not a join is performed.
</p>
<p>If both the short-column-names and full-column-names are set,
then the behaviour associated with the full-column-names flag is
|
| |
480 481 482 483 484 485 486 487 488 489 490 491 492 493 494 |
<tcl>Subsection short_column_names</tcl>
<li><p><b>PRAGMA short_column_names;
<br>PRAGMA short_column_names = </b><i>0 | 1</i><b>;</b></p>
<p>Query or change the short-column-names flag. This flag affects
the way SQLite names columns of data returned by [SELECT] statements
when the expression for the column is a table-column name or the
wildcard "*". Normally, such result columns are named
<table-name/alias><column-name> if the [SELECT] statement
joins two or more tables together, or simply <column-name> if
the [SELECT] statement queries a single table. When the short-column-names
flag is set, such columns are always named <column-name>
regardless of whether or not a join is performed.
</p>
<p>If both the short-column-names and full-column-names are set,
then the behaviour associated with the full-column-names flag is
|