sqlite3 的常用命令

-- select * from tb_internetnetwork;
-- PRAGMA database_list;
-- insert into tb_region(ID,GEOGRAPHICLOCATION, OPERATIONUNIT, SITE)  VALUES ('1','亦庄数据中心外网','国网信通公司','外网')
-- insert into tb_internetnetwork(net, isp, location, inter_region_id) VALUES ('192.168.1.0/24','BGP','亦庄','1');
-- delete from tb_region where id=1;
-- PRAGMA  foreign_keys;    开启 外键级联功能