Linux SQLite安装
一、软件包 a) sqlite-autoconf-3070400.tar.gz二、安装步骤a) tar zxvf sqlite-autoconf-3070400.tar.gzb) cd sqlite-autoconf-
首页 → 数据库技术
背景:
阅读新闻
Linux SQLite安装
[日期:2011-01-18] 来源:51CTO 作者:witer666 [字体:]
一、软件包
a) sqlite-autoconf-3070400.tar.gz
二、安装步骤
a) tar zxvf sqlite-autoconf-3070400.tar.gz
b) cd sqlite-autoconf-3070400
c) ./configure --prefix=/usr/local/sqlite
d) Make
e) Make install
三、SQLite3相关命令
a) /usr/local/sqlite/bin/Sqlite3 user.db创建一数据库
b) 查看帮助
SQLite version 3.3.6
Enter ".help" for instructions
sqlite> .databases
seq name file
--- --------------- ----------------------------------------------------------
0 main /usr/local/sqlite/bin/userdb
sqlite> .help
.databases List names and files of attached databases
.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
.help Show this message
.import FILE TABLE Import data from FILE into TABLE
.indices TABLE Show names of all indices on TABLE
.mode MODE ?TABLE? Set output mode where MODE is one of:
csv Comma-separated values
column Left-aligned columns. (See .width)
html HTML
推荐阅读
-
Linux SQLite安装
-
win系统下为Python3.5安装flask-mongoengine 库
-
linux 下 MySQL源码包的安装_MySQL
-
小弟我在windows2008并且是64位的操作系统上安装PHP,请教PHP有64位的吗
-
win10环境下python3.5安装步骤图文教程
-
win2008 R2 WEB环境配置之MYSQL 5.6.22安装版安装配置方法
-
mysql 5.7.13 winx64安装配置方法图文教程
-
python虚拟环境virualenv的安装与使用
-
在Linux下使用strace窥视Oracle LGWR进程
-
Oracle Database 11g R2 安装详细过程
网友评论
文明上网理性发言,请遵守 新闻评论服务协议
我要评论