Discover create database sqlite command line, include the articles, news, trends, analysis and practical advice about create database sqlite command line on alibabacloud.com
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
From: http://blog.csdn.net/LocalVar/archive/2008/02/13/3620555.aspx
1. Introduction
An important feature of a database that supports transactions like SQLITE is "Atomic commit ". Atomic commit means that all modification actions in a transaction
1. sqlite3: a command line interface of the SQLite Database
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.
Reference: https://www.pantz.org/software/sqlite/sqlite_commands_and_general_usage.htmlSQLite is an embedded open source relational database (db). It is the very portable, easy-to-use, compact, efficient, and reliable. Being an embedded database it
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
SQLite is an acid-compliant, lightweight database engine that is contained in a relatively small C library. It is a public domain project created by D.richardhipp. Unlike the common client/server architecture paradigm, the SQLite engine is not a
Introduction | data | Database This article discusses the more popular embedded development combination arm+uclinux, namely the target Development Board for Samsung S3C4510, complete SQLite on its uclinux transplant.
This article assumes that you
interface, like MySQL, is the cmd interface, but not the database created in SQLite.exe:First or the CMD under the use of SQLite online has been a lot, do not do too much to repeat. Roughly speaking the corresponding command on the line, as a
SQLite database management commands
1. Create a database
Start the command line and run the following command to open the shell mode CLP:
Sqlite3 test. DB
Although we provide the database name, if the database does not exist, SQLite does not
1. Use. dump in the command line to back up SQL files. Command statement: C: sqlitesqlite3tim. db. dumptest. SQL. dump? TABLE ?... DumpthedatabaseinanSQLtextformatIfTABLEspecified, onlydumptablesmatchingLIKEpatternTABLE.2, through the. read
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.