The SQLite library contains a command line named sqlite3, which allows you to manually enter and execute SQL commands for the SQLite database. This document provides a brief description of sqlite3.
Start
To start the sqlite3 program, you only need
ArticleDirectory
The SQLite library contains a command line named sqlite3, which allows you to manually enter and execute SQL commands for the SQLite database. This document provides a brief description of sqlite3.
The SQLite library
Address: http://blogold.chinaunix.net/u3/90025/showart_1764687.html
Address: http://www.sqlite.org/sqlite.html
The SQLite library contains a name calledSqlite3It allows you to manually enter and execute SQL commands for SQLite databases. This
Python Study Notes 21: Database Operations (sqlite3), pythonsqlite3Python comes with a lightweight relational database SQLite. This database uses the SQL language.As a back-end database, SQLite can be used with Python to build websites or create
Sqlite3: a command line interface for SQLite Databases
Address: http://www.sqlite.org/sqlite.html
The SQLite library contains a command line named sqlite3, which allows you to manually enter and execute SQL commands for the SQLite database. This
Use the basic SQLite3 command and the unzip tusqlite3 command in ubuntu
System Platform: ubuntu10.04
IntroductionSqlite3 is mainly used for Embedded lightweight databases. This article aims to provide technical documents for familiar with sqlite3
Preface:
/V * C ,~ $ X, A3 P3 J2 R! A; m, K + u: P: Q. x 'C' g/L $ A + V2] 7 S) L
I. Version :? /R0 Z. D5 C6 V1 C (^
! S % W1 C6 ^ 3 P/Q 2. Basic compilation % \/A % o $ T: i7 g
! Y3 C2 X) M4 _ + u & I 3. SQLite operations6 o/J '1 X % _/L1 N & _ * {
Directory
1 Setting Up Database Archives
2 operating under the SQLITE3 hint column
3 SQL instruction format
4 Creating a data table
5 building an index
6 Add a piece of information
7 Search Information
8 How to change or delete
[Practice environment]Operating System: Mac 10.6
Tool: terminal, xcode
[Materials and practices]Http://www.sqlite.org/index.htmlCurrent version 3.7.7.1
On Mac 10.6, the version is 3.6.12.
InTerminalThe program name is sqlite3
Sqlite3-help
Frequently
The previous article has been described without database version operation (Csv,json), today we will start to talk about the database version of the operation, the first is sqlite3.1 IntroductionSQLite is a C library that provides a lightweight disk-
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.