An Introduction to sqlite3 (sqlite3 Introduction)0. This article is a brief translation of the documents and descriptions on the official SQLite website. It mainly introduces some features of SQLite and its common applications.
1. SQLite
Int sqlite3_open (Const char * filename,/* database filename (UTF-8 )*/Sqlite3 ** ppdb/* Out: SQLite dB handle */);Function: Open the database. If the database does not exist, it is automatically created.Param1 (in): database file name, UTF-8
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 & _ * {
Note: This document describes the usage of API functions recognized by the author since his access to SQLite. This document is translated and updated by myself.
/* 2012-05-25 */ Int Sqlite3_open ( Const Char * Filename, /* Database file
Introduction to SQLITE3 C Language interface API functionsDescription: This document belongs to the author from the contact SQLite began to understand the use of API functions, from my translation, constantly updated./*2012-05-25*/IntSqlite3_open
1, in the PC environment to start a simulator (not mobile)2. See if the simulator/systen/xbin has sqlite3 commandADB shellCd/system/xbinLs3. Copy the simulator/system/xbin/sqlite3 command file from the simulator to the PCADB pull/system/xbin/sqlite3
System platform: ubuntu10.04
Brief introductionSqlite3 a lightweight database for embedded purposes, this article aims to provide technical documentation for familiar Sqlite3 basic commands.Note: All operations in this article are performed under
Writing this article originates from writing a script to write a CSV file (which uses GBK or UTF-8 encoding) into the SQLite database.Python version: 2.7.9The Sqlite3 module provides a method such as con = Sqlite3.connect ("d:\\text_factory.db3") to
Note: All operations in this article are performed under the root user.
1. Install sqlite3
Install sqlite3 in ubuntu and run the following command directly on the terminal:# Apt-get install sqlite3View version information:# Sqlite3-version2. Common
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.