A command-line access program for SQLite databases
The SQLite library includes a small command-line utility SQLite3 that will allow you to manually enter and execute SQL commands against an SQLite3 database. This document provides a brief introduction on how to use sqlite3.
To start the SQLite3 program, just type "sqlite3" followed by the name the file that holds the SQLite database. If the file does not exist, a new one is created automatically. The SQLite3 program will then prompt you to enter SQL. Type in SQL statements (terminated by a semicolon), press "Enter" and the SQL will be executed.
To start the SQLite3 program, just type "sqlite3" followed by the name the file that holds the SQLite database. If the file does not exist, a new one is created automatically. The SQLite3 program will then prompt you to enter SQL. Type in SQL statements (terminated by a semicolon), press "Enter" and the SQL will be executed.
What's New in This Release:
· Added the PRAGMA foreign_key_check command.
· Added new extended error codes for all SQLITE_CONSTRAINT errors
· Added the SQLITE_READONLY_ROLLBACK extended error code for when a database cannot be opened because it needs rollback recovery but is read-only.
· Added SQL functions unicode(A) and char(X1,...,XN).
· Performance improvements for PRAGMA incremental_vacuum, especially in cases where the number of free pages is greater than what will fit on a single trunk page of the freelist.
· Improved optimization of queries containing aggregate min() or max().
· Enhance virtual tables so that they can potentially use an index when the WHERE clause contains the IN operator.
· Allow indices to be used for sorting even if prior terms of the index are constrained by IN operators in the WHERE clause.
· Enhance the PRAGMA table_info command so that the "pk" column is an increasing integer to show the order of columns in the primary key.
· Enhance the query optimizer to exploit...
· Added the PRAGMA foreign_key_check command.
· Added new extended error codes for all SQLITE_CONSTRAINT errors
· Added the SQLITE_READONLY_ROLLBACK extended error code for when a database cannot be opened because it needs rollback recovery but is read-only.
· Added SQL functions unicode(A) and char(X1,...,XN).
· Performance improvements for PRAGMA incremental_vacuum, especially in cases where the number of free pages is greater than what will fit on a single trunk page of the freelist.
· Improved optimization of queries containing aggregate min() or max().
· Enhance virtual tables so that they can potentially use an index when the WHERE clause contains the IN operator.
· Allow indices to be used for sorting even if prior terms of the index are constrained by IN operators in the WHERE clause.
· Enhance the PRAGMA table_info command so that the "pk" column is an increasing integer to show the order of columns in the primary key.
· Enhance the query optimizer to exploit...
| Publisher | : | Richard Hipp |
|---|---|---|
| License | : | Freeware |
| Size/OS: | : | 268 KB / Windows All |
| Date | : | March 18th, 2013 |
Download | : | SQLite3 3.7.16 |
