Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Typo on the "datatypes.html" document. (CVS 1136) |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
80b1e277123c07b2db7441a9e600dd69 |
| User & Date: | drh 2003-12-18 14:19:41 |
Context
|
2003-12-19
| ||
| 02:52 | Add new thread-testing code and fix locking under Linux threads. Ticket #530. (CVS 1137) check-in: b36a4bb6 user: drh tags: trunk | |
|
2003-12-18
| ||
| 14:19 | Typo on the "datatypes.html" document. (CVS 1136) check-in: 80b1e277 user: drh tags: trunk | |
| 01:22 | Version 2.8.8 (CVS 1135) check-in: a0451ccf user: drh tags: trunk | |
Changes
Changes to www/datatypes.tcl.
1
2
3
4
5
6
7
8
9
10
11
..
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
|
#
# Run this script to generated a datatypes.html output file
#
set rcsid {$Id: datatypes.tcl,v 1.5 2002/08/18 19:09:24 drh Exp $}
puts {<html>
<head>
<title>Datatypes In SQLite</title>
</head>
<body bgcolor="white">
<h1 align="center">
................................................................................
of AUTOINCREMENT. If you try to insert a NULL into an INTEGER PRIMARY
KEY column, the column will actually be filled with a integer that is
one greater than the largest key already in the table. Or if the
largest key is 2147483647, then the column will be filled with a
random integer. Either way, the INTEGER PRIMARY KEY column will be
assigned a unique integer. You can retrieve this integer using
the <b>sqlite_last_insert_rowid()</b> API function or using the
<b>last_insert_rowid()</b> SQL function is a subsequent SELECT statement.
</p>
<h2>3.0 Comparison and Sort Order</h2>
<p>
SQLite is typeless for the purpose of deciding what data is allowed
to be stored in a column. But some notion of type comes into play
|
|
|
|
1
2
3
4
5
6
7
8
9
10
11
..
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
|
#
# Run this script to generated a datatypes.html output file
#
set rcsid {$Id: datatypes.tcl,v 1.6 2003/12/18 14:19:41 drh Exp $}
puts {<html>
<head>
<title>Datatypes In SQLite</title>
</head>
<body bgcolor="white">
<h1 align="center">
................................................................................
of AUTOINCREMENT. If you try to insert a NULL into an INTEGER PRIMARY
KEY column, the column will actually be filled with a integer that is
one greater than the largest key already in the table. Or if the
largest key is 2147483647, then the column will be filled with a
random integer. Either way, the INTEGER PRIMARY KEY column will be
assigned a unique integer. You can retrieve this integer using
the <b>sqlite_last_insert_rowid()</b> API function or using the
<b>last_insert_rowid()</b> SQL function in a subsequent SELECT statement.
</p>
<h2>3.0 Comparison and Sort Order</h2>
<p>
SQLite is typeless for the purpose of deciding what data is allowed
to be stored in a column. But some notion of type comes into play
|