| User Functions |
|
Don't have an account yet? Sign up as a New User
|
|
| Events |
|
There are no upcoming events |
|
|
 |
 |
 |
 |
| SQLite Tutorial released |
|
Friday, November 26 2004 @ 05:30 PM EST Contributed by: Anonymous
|
An updated version of the SQLite Tutorial is NOW available. What's SQLite you ask?
SQLite is a small C library that implements a self-contained, embeddable, zero-configuration SQL database engine.
SQLite Tutorial:
This article explores the power and simplicity of sqlite3, first by starting with common commands and triggers, then the attach statement with the union operation is introduced in a way that allows multiple tables, in separate databases, to be combined as one virtual table, without the overhead of copying or moving data. Next, the simple sign function and the amazingly powerful trick of using this function in SQL select statements to solve complex queries with a single pass through the data is demonstrated, after making a brief mathematical case for how the sign function defines the absolute value and IF conditions.
|
|
| |
| [ Views: 1800 ] |
|
|
 |
 |
 |
 |
|
|
We have written a
range of guides highlighting excellent free
books for popular programming languages. Check out the
following guides: C,
C++,
C#,
Java,
JavaScript,
CoffeeScript,
HTML,
Python,
Ruby,
Perl,
Haskell,
PHP,
Lisp,
R,
Prolog,
Scala,
Scheme, and SQL.
|
|
|
|