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
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
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 an example of using sqlite3
The SQLite library contains a command line named 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
The table is created by using the following statement:
Copy Code code as follows:
CREATE table UserInfo (name text, email text)
Inserting data more quickly
Use the Time.clock () to time to see the speed of the following three
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
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.