sqlite3 cli 快速查询数据库内容

原文链接https://www.digitalocean.com/community/tutorials/how-to-install-and-use-sqlite-on-ubuntu-20-04

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;

真实用到的

select F_ChannelUriInSide from T_Channel;