sqlite terminal commands

I. Basic Introduction SQLite is a self-contained, serverless, zero-configuration, and transactional relational database engine. Because it is very small, it can also be built into your application as an embedded database. SQLite is used in Solaris 1

first, the basic introduction SQLite is a self-sustaining (self-contained), server-free, 0-configured, transactional-type relational database engine. Because he is very small, it can also be built into your application as an embedded database.

Research and Implementation of SQLite Embedded Database System [Date:] Source: single-chip microcomputer and Embedded System Application Author: Chen Shuang, Jin Lin, guangbin Palace, Southwest Jiaotong University [Font:Large Medium

1, download SQLite from the official website after installation, open the terminal change directory to the directory where the Sqlite3 file is located, enter the following command to create a database, if the database already exists will open:

Command: Example Output Help information Sqlite>.help (Note the character '. ' Before the command) ： View database file Information command: sqlite>.databaseView creation statements for all tables: Sqlite>.schemaView

Download sqlite-3.6.tar.gz unzip and copy it to the directory where you want to install it, I chose the usrlocalsqlite-3.3.6 and then in the terminal: # cdusrlo Download the sqlite-3.3.6.tar.gz unzip and copy it to the directory you want to install,

Document directory PHP version 4.4.8 PHP and sqlite3 After several days of efforts, we finally built the Apache + SQLite + PHP platform on the arm-Linux platform. Apche and SQLite have a lot of information on the Internet, but PHP for

Because glusterfs is implemented for multiple users, user registration and login are required, and user registration involves databases. Therefore, SQLite is used. Why choose it? 1. Small 2. cross-platform 3. configuration-free. Like access, you

First, view the version information:#sqlite3-versionSecond, sqlite3 commonly used commands1, the current directory to establish or open the Test.db database file, and enter the SQLite command terminal to sqlite> prefix identification:2. Output Help

The first thing you need to know is the path to the database, CoreData created is usually placed in the sandbox Documents folder, and you built it to see yourself,Sqlite3 #数据库路径 #//Enter the database. Tables//View tables in the database.