Sqlite3 Encryption SchemeSqlite3 free version does not support encryption, but there are a number of interfaces, there are many open source encryption implementation, but some need to use the OpenSSL configuration is slightly cumbersome, but the use
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
First, how to enter the sqlite3 interactive mode for command operation?1. Confirm whether the Sqlite3 is installedGo to the python command line and execute>>> Import sqlite3>>>No error, indicating that Sqlite3 has successfully installed the2. How to
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
Document directory
Sqlite3
Common functions
Sqlite3
SQLite is a lightweight database. Similar to common MySQL databases. Compared with MySQL, the data type is basically the same, but all SQLite commands are ". "(for example, in MySQL, check
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
Sqlite3 long for lightweight data storage, such as single-chip computer, but now the sqlite3, has been very advanced, can not underestimateTwo sqlite3 common commands The current directory establishes or opens the test.db database file and enters
Note: All operations in this article are performed under Root.
1. Installation Sqlite3
Ubuntu install sqlite3 directly in the terminal to run the command:#apt-get Install Sqlite3To view version information:#sqlite3-version2, sqlite3 Common
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
From: http://blog.sina.com.cn/s/blog_74dfa9f401017s69.htmlSystem Platform: ubuntu10.04
IntroductionSqlite3 is mainly used for Embedded lightweight databases. This article aims to provide technical documents for familiar with sqlite3 basic
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.