... Dump the database in an SQL text format .echo ON|OFF Turn command echo on or off .exit Exit this program .explain ON|OFF Turn output mode suitable for EXPLAIN on or off. .header(s) ON|OFF Turn display of headers on or off .help Show this message .import FILE TABLE Import da...
but not least, is the ".schema" command. With no arguments, the ".schema" command shows the original CREATE TABLE and CREATE INDEX statements that were
创建表: create table 表名(元素名 类型,…); 删除表: drop table 表名; 插入数据: insert into 表名 values(, , ,) ; 创建索引: create [unique] index 索引名on 表名(col….); 删除索引: drop index 索引名(索引是不可更改的,想更改必须删除重新建) 删除数据: delete from 表名; 更新数据: upd...
Alternatively, you can create a new database using the default temporary storage, then save that database into a disk file using the ".save" command: 代码语言:javascript 复制 SQLite version 3.16.0 2016-12-29 19:48:46 Enter ".help" for usage hints. Connected to a transient in-memory ...
To create an SQLite database namedlinux.db, execute the following command: sqlite3 linux.db; Note:The above command for creating a database is optional and is only necessary if you haven’t already created a database using theSQLitecommand. ...
.dump ?TABLE? ... Dump the database in an SQL text format .echo ON|OFF Turn command echo on or off .exit Exit this program .explain ON|OFF Turn output mode suitable for EXPLAIN on or off. .header(s) ON|OFF Turn display of headers on or off ...
create table tbl(name char(10), age smallint, score float); 查询表 .table 插入数据 insert into tbl values('yanggang', 24, 98); insert into tbl values('sunboy', 20, 78.5); 查询数据 select * from tbl; 修改显示模式 .mode column ...
F:\>sqlite3 database.db sqlite> create table admin(username text,age integer); sqlite> insert into admin values('kuang',25); sqlite> select * from admin; sqlite> update admin set username='kk',age=24 where username='kuang' and age=25; sqlite> delete from admin where username='kk';...
static void NativeMain() { // Open the database--db is our "handle" to it IntPtr db; if (SQLiteNative.sqlite3_open(@"cities.sqlite", out db) == SQLiteNative.SQLITE_OK) { // Prepare a simple DDL "CREATE TABLE" statement string query = "CREATE TABLE City " + "(name TEXT, sta...
1、sqlite命令行工具简单操作在win32下面操作,先看下sqlite.e的协助: d: sqlite3.exe -help usage: sqlite3.exe options filename sql filename is the name of an sqlite database. a new database is creat if the does not previously exist. options ilude: -help show this message -init filename...