sqlite3 cli 快速查询数据库内容

sudo apt update
sudo apt install sqlite3
sqlite3 --version
sqlite3 sharks.db
#创建
CREATE TABLE sharks(id integer NOT NULL, name text NOT NULL, sharktype text NOT NULL, length integer NOT NULL);
#插入
INSERT INTO tablename VALUES(values go here);
INSERT INTO sharks VALUES (1, "Sammy", "Greenland Shark", 427);
INSERT INTO sharks VALUES (2, "Alyoshka", "Great White Shark", 600);
INSERT INTO sharks VALUES (3, "Himari", "Megaladon", 1800);
SELECT * FROM sharks;
SELECT * FROM sharks WHERE id IS 1;
ALTER TABLE sharks ADD COLUMN age integer;
UPDATE sharks SET age = 272 WHERE id=1;
UPDATE sharks SET age = 70 WHERE id=2;
UPDATE sharks SET age = 40 WHERE id=3;
DELETE FROM sharks WHERE age <= 200;