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
One, install Sqlite31. See http://www.runoob.com/sqlite/sqlite-intro.html when getting started, easy to say, but suitable for getting started2. In the terminal input sqlite3, there is no return information, indicating that the system is not
[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
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
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
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
Original articles, if reproduced, please specify the source: http://blog.csdn.net/yihui823/article/details/6689922 Prerequisites for this article: Eclipse and ADT are already installed. The Android SDK is also downloaded. The previous ID SDK for
From: http://hi.baidu.com/vv1133/blog/item/8fae0df29f0cfc18b17ec573.html
Install
$ Tar zxvf sqlite-3.3.5.tar.gz
$ Sqlite-3.3.5 CD
$./Configure -- disable-TCL -- prefix =/usr/local/sqlite3/(the subsequent path can also be omitted, that is, it is
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.