Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Change "'CREATE TABLE AS' statements" to "'CREATE TABLE ... AS SELECT ...' statements" on lang_createtable.html. |
|---|---|
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
4534ea5789e33976e9ee5d1b259858f7 |
| User & Date: | dan 2010-09-29 11:10:06 |
| Original User & Date: | dan 2010-09-29 23:10:06 |
Context
|
2010-09-29
| ||
| 18:22 | Fix a problem with the definition of the DEFAULT clause on lang_conflict.html. check-in: 73b4c1e498 user: dan tags: trunk | |
| 11:10 | Change "'CREATE TABLE AS' statements" to "'CREATE TABLE ... AS SELECT ...' statements" on lang_createtable.html. check-in: 4534ea5789 user: dan tags: trunk | |
| 04:20 | Fix documentation typos in testing.html and in fileformat2.html. check-in: ac93c65159 user: drh tags: trunk | |
Changes
Changes to pages/lang.in.
663 664 665 666 667 668 669 670 671 672 673 674 675 676 677 678 679 680 681 682 683 684 685 |
if the "IF NOT EXISTS" clause is specified. <p>^It is not an error to create a table that has the same name as an existing [CREATE TRIGGER|trigger]. <p>^Tables are removed using the [DROP TABLE] statement. </p> <h3>CREATE TABLE AS Statements</h3> <p>^A "CREATE TABLE AS" statement creates and populates a database table based on the results of a SELECT statement. ^(The table has the same number of columns as the rows returned by the SELECT statement. The name of each column is the same as the name of the corresponding column in the result set of the SELECT statement.)^ ^(The declared type of each column is determined by the [expression affinity] of the corresponding expression in the result set of the SELECT statement, as follows: </p> <center><table border=1> <tr><th>Expression Affinity <th>Column Declared Type <tr><td>TEXT <td>"TEXT" <tr><td>NUMERIC <td>"NUM" <tr><td>INTEGER <td>"INT" |
| | | | | | | | |
663 664 665 666 667 668 669 670 671 672 673 674 675 676 677 678 679 680 681 682 683 684 685 |
if the "IF NOT EXISTS" clause is specified. <p>^It is not an error to create a table that has the same name as an existing [CREATE TRIGGER|trigger]. <p>^Tables are removed using the [DROP TABLE] statement. </p> <h3>CREATE TABLE ... AS SELECT Statements</h3> <p>^(A "CREATE TABLE ... AS SELECT" statement creates and populates a database table based on the results of a SELECT statement.)^ ^(The table has the same number of columns as the rows returned by the SELECT statement. The name of each column is the same as the name of the corresponding column in the result set of the SELECT statement.)^ ^(The declared type of each column is determined by the [expression affinity] of the corresponding expression in the result set of the SELECT statement, as follows: </p> <center><table border=1> <tr><th>Expression Affinity <th>Column Declared Type <tr><td>TEXT <td>"TEXT" <tr><td>NUMERIC <td>"NUM" <tr><td>INTEGER <td>"INT" |