Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
Comment: | Update the keyword list and description in the language documentation. CVSTrac ticket #3612. |
---|---|
Downloads: | Tarball | ZIP archive |
Timelines: | family | ancestors | descendants | both | trunk |
Files: | files | file ages | folders |
SHA1: |
561c52b85bbbdeb8d3d7f1b185090fa5 |
User & Date: | drh 2009-01-29 19:28:24.000 |
Context
2009-01-30
| ||
01:55 | Much larger mimetype table for the webserver. (check-in: 5666307201 user: drh tags: trunk) | |
2009-01-29
| ||
19:28 | Update the keyword list and description in the language documentation. CVSTrac ticket #3612. (check-in: 561c52b85b user: drh tags: trunk) | |
2009-01-26
| ||
14:15 | Add FAQ #20. (check-in: 32f90bde6c user: drh tags: trunk) | |
Changes
Changes to pages/lang.in.
︙ | ︙ | |||
2325 2326 2327 2328 2329 2330 2331 | AS ASC* ATTACH* AUTOINCREMENT BEFORE* BEGIN* BETWEEN | | | | 2325 2326 2327 2328 2329 2330 2331 2332 2333 2334 2335 2336 2337 2338 2339 2340 2341 2342 2343 2344 2345 | AS ASC* ATTACH* AUTOINCREMENT BEFORE* BEGIN* BETWEEN BY* CASCADE* CASE CAST* CHECK COLLATE COLUMN* COMMIT CONFLICT* CONSTRAINT CREATE CROSS CURRENT_DATE* CURRENT_TIME* |
︙ | ︙ | |||
2370 2371 2372 2373 2374 2375 2376 | GROUP HAVING IF* IGNORE* IMMEDIATE* IN INDEX | | | 2370 2371 2372 2373 2374 2375 2376 2377 2378 2379 2380 2381 2382 2383 2384 | GROUP HAVING IF* IGNORE* IMMEDIATE* IN INDEX INDEXED INITIALLY* INNER INSERT INSTEAD* INTERSECT INTO IS |
︙ | ︙ | |||
2401 2402 2403 2404 2405 2406 2407 | OUTER PLAN* PRAGMA* PRIMARY QUERY* RAISE* REFERENCES | | | | | 2401 2402 2403 2404 2405 2406 2407 2408 2409 2410 2411 2412 2413 2414 2415 2416 2417 2418 2419 2420 2421 2422 2423 2424 | OUTER PLAN* PRAGMA* PRIMARY QUERY* RAISE* REFERENCES REGEXP* REINDEX* RELEASE* RENAME* REPLACE* RESTRICT* RIGHT ROLLBACK ROW* SAVEPOINT* SELECT SET TABLE TEMP* TEMPORARY* THEN TO |
︙ | ︙ | |||
2451 2452 2453 2454 2455 2456 2457 | <p>If you want to use a keyword as a name, you need to quote it. There are three ways of quoting keywords in SQLite:</p> <p> <blockquote> <table> <tr> <td valign="top"><b>'keyword'</b></td><td width="20"></td> | | | < | | < | > > > > > > > > | > > > > > > > > > > > > > > > > > > > > | | 2451 2452 2453 2454 2455 2456 2457 2458 2459 2460 2461 2462 2463 2464 2465 2466 2467 2468 2469 2470 2471 2472 2473 2474 2475 2476 2477 2478 2479 2480 2481 2482 2483 2484 2485 2486 2487 2488 2489 2490 2491 2492 2493 2494 2495 2496 2497 2498 2499 2500 2501 2502 2503 2504 2505 2506 2507 2508 | <p>If you want to use a keyword as a name, you need to quote it. There are three ways of quoting keywords in SQLite:</p> <p> <blockquote> <table> <tr> <td valign="top"><b>'keyword'</b></td><td width="20"></td> <td>A keyword in single quotes is a string literal.</td></tr> <tr> <td valign="top"><b>"keyword"</b></td><td></td> <td>A keyword in double-quotes is an identifier</td></tr> <tr> <td valign="top"><b>[keyword]</b></td><td></td> <td>A keyword enclosed in square brackets is an identifier. This is not standard SQL. This quoting mechanism is used by MS Access and SQL Server and is included in SQLite for compatibility.</td></tr> <tr> <td valign="top"><b>`keyword`</b></td><td></td> <td>A keyword enclosed in grave accents (ASCII code 96) is an identifier. This is not standard SQL. This quoting mechanism is used by MySQL and is included in SQLite for compatibility.</td></tr> </table> </blockquote> </p> <p>For resilience when confronted with historical SQL statements, SQLite will sometimes bend the quoting rules above:</p> <ul> <li><p>If a keyword in single quotes (ex: <b>'key'</b> or <b>'glob'</b>) is used in a context where an identifier is allowed but where a string literal is not allowed, then the token is understood to be an identifier instead of a string literal. </p></li> <li><p>If a keyword in double quotes (ex: <b>"key"</b> or <b>"glob"</b>) is used in a context where it cannot be resolved to an indentifier but where a string literal is allowed, then the token is understood to be a string literal instead of an identifer.</p></li> </ul> <p>Programmers are cautioned not to use the two exceptions described in the previous bullets. We emphasize that they exist only so that old and ill-formed SQL statements will run correctly. Future versions of SQLite might change to raise errors instead of accepting the malformed statements covered by the exceptions above.</p> <p>SQLite is extended to allow many keywords to be used unquoted as the names of databases, tables, indices, triggers, views, columns, user-defined functions, collations, attached databases, and virtual function modules. In the list of keywords that follows, those that can be used as identifiers are shown in an italic font. Keywords that must be quoted in order to be used as identifiers are shown in bold.</p> |
︙ | ︙ |