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
Use the sqlite3 command to read the content of a file in the sqlite3 format.
/********************************************************************* * Author : Samson * Date : 07/09/2014 * Test platform: * 3.11.0.11-generic
[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
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 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
Article Reference: www.sqlite.org/sqlite.html
Sqlite3
We can manually manage the SQLite database. Common
2 sqlite3
On a computer, it is located in Android-SDK-Windows \ tools \ sqlite3.exe for managing SQLite databases on a computer; and on
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
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
There are four types of data persistence in iOS: Attribute lists, object archiving, SQLite3, and core Data,sqlite3 database operations are a must-have or missing technology.
SQLite3 Introduction SQLite3 database is the mobile side (IOS, Android,
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.