刚接触SQLite数据库时,看着上面介绍了一大堆关于这个东西的好处,又是什么轻量级,又是什么存储小呀,什么什么的一大堆,我一句都没记住,我想要的只是先这东西要怎么用,乱七八糟的一堆东西,谁知道这是个什么意思,好像这都成了套路了,每看一本书都是什么前言,概述,第一章铁定是这些东西,就不能像个编程的样了第一次给个hello word 给人瞅瞅吗?
创建数据库: sqlite3 testDB.db(不以";"结束,不要奇怪,人家就是这么省)
查看数据库:.databases
会显示:
seq name file
--- ---------------------------- --------------------------------------------
0 main c:\users\Admin***\testDB.db
退出:.quite
导出数据库:sqlite3 testDB.db .dump > test.sql
test.sql打开内容如下:
PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
COMMIT;
附加数据库:ATTACH DATABASE 'testDB' as 'test';(注意有分号)
查看会出现
--- ---------------------------- --------------------------------------------
0 main c:\users\Admin***\testDB.db 2 test c:\users\Admin***\testDB.db
分离数据库:ATTACH DATABASE 'test';(注意有分号)
查看会出现
--- ---------------------------- --------------------------------------------
0 main c:\users\Admin***\testDB.db 创建表:CREATE TABLE COMPANY( (注意空格,不然的查看时就是输入时的样子)
id INT PRIMARY KEY NOT NULL,
name TEXT NOT NULL,
age INT NOT NULL,
address CHAR(50) NOT NULL,
salary REAL
);
查看表:.tabales
显示:
COMPANY
具体查看:.schema
CREATE TABLE COMPANY(
id INT PRIMARY KEY NOT NULL,
name TEXT NOT NULL,
age INT NOT NULL,
address CHAR(50) NOT NULL,
salary REAL
);
删除表:DROP TABLE COMPANY;(注意有分号哦);
插入数据:INTSERT INTO COMPANY (id, name, age, address, salary)
VALUES (1, 'Ouyang', 28, nixiang, 2000.00);
查询数据:SELECT * FROM COMPANY;
显示:1|Ouyang|28|nixiang||20000.0
其它查找方法:
.header on (加头部)
.mode column (加列名)
.width 10, 20, 10 (设置宽度)
SELECT id, name, salary from company;
SELECT COMPANY FROM sqlite_master WHERE type = 'table';
有各种数学运算符(用于查找)如:
SELECT * FROM COMPANY WHERE AGE > 10;
总之就是SELECT column1, column2, columnN
FROM table_name
WHERE [condition]
修改:
UPDATE table_name
SET column1 = value1, column2 = value2, columnN = valueN
WHERE [condition];
如:
UPDATA COMPANY SET address = 'taojiang' WHERE id = 1;
删除:
DELETE FROM table_name
WHERE [condition];
如:DELETE FROM COMPANY WHERE ID = 1;
排序:
SELECT column-list
FROM table_name
[WHERE condition]
[ORDER BY column1, column2, columnN] [ASC | DESC];
如:
SELECT * FROM COMPANY ORDER BY SALARY ASC;
SQLite 基本玩法就这样了,更多高级玩法 。。。。。