Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
Comment: | Documentation updates (CVS 1921) |
---|---|
Downloads: | Tarball | ZIP archive |
Timelines: | family | ancestors | descendants | both | trunk |
Files: | files | file ages | folders |
SHA1: |
9322c439c5727f0d65548efdf4de4d7b |
User & Date: | drh 2004-08-30 14:58:12.000 |
Context
2004-08-30
| ||
16:52 | Better detection and handling of corrupt database files. (CVS 1922) (check-in: 8f5b199e84 user: drh tags: trunk) | |
14:58 | Documentation updates (CVS 1921) (check-in: 9322c439c5 user: drh tags: trunk) | |
14:22 | Remove the \001 character that lemon inserts automatically in its output file. The need for this character has expired and it creates confusion for users. Ticket #877 (CVS 1920) (check-in: acfc59186a user: drh tags: trunk) | |
Changes
Changes to www/c_interface.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: c_interface.tcl,v 1.41 2004/08/30 14:58:12 drh Exp $} source common.tcl header {The C language interface to the SQLite library} puts { <h2>The C language interface to the SQLite library</h2> <p>The SQLite library is designed to be very easy to use from a C or C++ program. This document gives an overview of the C/C++ |
︙ | ︙ | |||
691 692 693 694 695 696 697 | pointer. In addition to the regular data, there is an added row at the beginning of the array that contains the name of each column of the result.</p> <p>As an example, consider the following query:</p> <blockquote> | | | 691 692 693 694 695 696 697 698 699 700 701 702 703 704 705 | pointer. In addition to the regular data, there is an added row at the beginning of the array that contains the name of each column of the result.</p> <p>As an example, consider the following query:</p> <blockquote> SELECT employee_name, login, host FROM users WHERE login LIKE 'd%'; </blockquote> <p>This query will return the name, login and host computer name for every employee whose login begins with the letter "d". If this query is submitted to <b>sqlite_get_table</b> the result might look like this:</p> |
︙ | ︙ |
Changes to www/nulls.tcl.
1 2 3 | # # Run this script to generated a nulls.html output file # | | | 1 2 3 4 5 6 7 8 9 10 11 | # # Run this script to generated a nulls.html output file # set rcsid {$Id: nulls.tcl,v 1.7 2004/08/30 14:58:12 drh Exp $} source common.tcl header {NULL Handling in SQLite} puts { <h2>NULL Handling in SQLite Versus Other Database Engines</h2> <p> The goal is |
︙ | ︙ | |||
103 104 105 106 107 108 109 | <td valign="center" align="center" bgcolor="#a9c7a9">Yes</td> </tr> <tr><td>nulls are distinct in a UNIQUE column</td> <td valign="center" align="center" bgcolor="#a9c7a9">Yes</td> <td valign="center" align="center" bgcolor="#a9c7a9">Yes</td> <td valign="center" align="center" bgcolor="#a9c7a9">Yes</td> <td valign="center" align="center" bgcolor="#c7a9a9">No</td> | | | 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 | <td valign="center" align="center" bgcolor="#a9c7a9">Yes</td> </tr> <tr><td>nulls are distinct in a UNIQUE column</td> <td valign="center" align="center" bgcolor="#a9c7a9">Yes</td> <td valign="center" align="center" bgcolor="#a9c7a9">Yes</td> <td valign="center" align="center" bgcolor="#a9c7a9">Yes</td> <td valign="center" align="center" bgcolor="#c7a9a9">No</td> <td valign="center" align="center" bgcolor="#aaaad2">(Note 4)</td> <td valign="center" align="center" bgcolor="#c7a9a9">No</td> <td valign="center" align="center" bgcolor="#a9c7a9">Yes</td> </tr> <tr><td>nulls are distinct in SELECT DISTINCT</td> <td valign="center" align="center" bgcolor="#c7a9a9">No</td> <td valign="center" align="center" bgcolor="#c7a9a9">No</td> <td valign="center" align="center" bgcolor="#c7a9a9">No</td> |
︙ | ︙ | |||
235 236 237 238 239 240 241 | <tr><td>2. </td> <td>Test data unavailable.</td> </tr> <tr><td>3. </td> <td>MySQL version 3.23.41 does not support UNION.</td> </tr> <tr><td>4. </td> | | | 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 | <tr><td>2. </td> <td>Test data unavailable.</td> </tr> <tr><td>3. </td> <td>MySQL version 3.23.41 does not support UNION.</td> </tr> <tr><td>4. </td> <td>DB2, SQL Anywhere, and Borland Interbase do not allow NULLs in a UNIQUE column.</td> </tr> <tr><td>5. </td> <td>Borland Interbase does not support CASE expressions.</td> </tr> </table> <br clear="both"> |
︙ | ︙ |