03-region.sql

最新推荐文章于 2019-10-29 10:31:29 发布

spencer_tseng

最新推荐文章于 2019-10-29 10:31:29 发布

阅读量410

点赞数

CC 4.0 BY-SA版权

分类专栏： database

本文链接：https://blog.youkuaiyun.com/spencer_tseng/article/details/78558042

database 专栏收录该内容

45 篇文章

订阅专栏

本文展示了针对上海行政区划数据的一系列数据库操作，包括查询、删除和插入等SQL语句，用以维护数据库中区划信息的准确性。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

脚本太长了~ ~ ~ ~复制部分~ ~ ~ ~

SELECT * FROM T_SYS_DICT WHERE pid = 'b8d10191-8464-4463-a977-0daad9b7d6fc';
SELECT t1.* FROM T_SYS_DICT t1 WHERE t1.pid IN (SELECT ID FROM T_SYS_DICT WHERE pid = 'b8d10191-8464-4463-a977-0daad9b7d6fc');
SELECT t2.* FROM T_SYS_DICT t2 WHERE t2.pid IN (SELECT t1.id FROM T_SYS_DICT t1 WHERE t1.pid IN (SELECT ID FROM T_SYS_DICT WHERE pid = 'b8d10191-8464-4463-a977-0daad9b7d6fc'));


DELETE FROM T_SYS_DICT t2 WHERE t2.pid IN (SELECT t1.id FROM T_SYS_DICT t1 WHERE t1.pid IN (SELECT ID FROM T_SYS_DICT WHERE pid = 'b8d10191-8464-4463-a977-0daad9b7d6fc'));
DELETE FROM T_SYS_DICT t1 WHERE t1.pid IN (SELECT ID FROM T_SYS_DICT WHERE pid = 'b8d10191-8464-4463-a977-0daad9b7d6fc');
DELETE FROM T_SYS_DICT WHERE pid = 'b8d10191-8464-4463-a977-0daad9b7d6fc';
DELETE FROM T_SYS_DICT WHERE id = 'b8d10191-8464-4463-a977-0daad9b7d6fc';


INSERT INTO T_SYS_DICT (id, name, code, pid, remark, seq, type, lv) VALUES ('b8d10191-8464-4463-a977-0daad9b7d6fc', '区划', 'REGION', NULL, NULL, 9, '0', NULL);

INSERT INTO T_SYS_DICT (id,name,code,pid,seq,type) VALUES ('5289fe9b-0428-4b7b-84f6-b21827520540','上海市','SH','b8d10191-8464-4463-a977-0daad9b7d6fc',0,0);
INSERT INTO T_SYS_DICT (id,name,code,pid,seq,type) VALUES ('76a9605c-a27d-4528-af23-f872139d6576','上海市','SHS','5289fe9b-0428-4b7b-84f6-b21827520540',0,0);
INSERT INTO T_SYS_DICT (id,name,code,pid,seq,type) VALUES ('3d18ae3a-c8c8-482d-b180-4b61799fc832','浦东新区','PDXQ','76a9605c-a27d-4528-af23-f872139d6576',0,0);
INSERT INTO T_SYS_DICT (id,name,code,pid,seq,type) VALUES ('84e32498-a1a0-4278-aba2-fc2f4fd5a053','徐汇区','XHQ','76a9605c-a27d-4528-af23-f872139d6576',1,0);
INSERT INTO T_SYS_DICT (id,name,code,pid,seq,type) VALUES ('503b0031-c39b-4ff3-a9ab-e606e5669107','黄浦区','HPQ','76a9605c-a27d-4528-af23-f872139d6576',2,0);
INSERT INTO T_SYS_DICT (id,name,code,pid,seq,type) VALUES ('4bb00f71-0bd4-4aec-9c13-9db96d016347','杨浦区','YPQ','76a9605c-a27d-4528-af23-f872139d6576',3,0);
INSERT INTO T_SYS_DICT (id,name,code,pid,seq,type) VALUES ('209ec857-93cb-47b3-ab0e-9ffa4fc93ea8','虹口区','HKQ','76a9605c-a27d-4528-af23-f872139d6576',4,0);
INSERT INTO T_SYS_DICT (id,name,code,pid,seq,type) VALUES ('cb3fabc8-f20a-4355-9f38-d9d750a8a1d6','闵行区','ZXQ','76a9605c-a27d-4528-af23-f872139d6576',5,0);
INSERT INTO T_SYS_DICT (id,name,code,pid,seq,type) VALUES ('f421e7b4-f0b0-442c-bcb2-6e6a873dff23','长宁区','CNQ','76a9605c-a27d-4528-af23-f872139d6576',6,0);
INSERT INTO T_SYS_DICT (id,name,code,pid,seq,type) VALUES ('c74ab78f-ffd8-4e8d-9e0f-c7ae44044195','普陀区','PTQ','76a9605c-a27d-4528-af23-f872139d6576',7,0);
INSERT INTO T_SYS_DICT (id,name,code,pid,seq,type) VALUES ('621b67df-ed77-4eed-923e-2341583f2461','宝山区','BSQ','76a9605c-a27d-4528-af23-f872139d6576',8,0);
INSERT INTO T_SYS_DICT (id,name,code,pid,seq,type) VALUES ('3025aca7-98ca-4072-8bcd-9788b28edb7f','静安区','JAQ','76a9605c-a27d-4528-af23-f872139d6576',9,0);
INSERT INTO T_SYS_DICT (id,name,code,pid,seq,type) VALUES ('1b6ac684-9a60-45d2-ab4d-7e4ce510c496','闸北区','ZBQ','76a9605c-a27d-4528-af23-f872139d6576',10,0);
INSERT INTO T_SYS_DICT (id,name,code,pid,seq,type) VALUES ('32019258-fede-4816-aec0-de2479c6e93a','卢湾区','LWQ','76a9605c-a27d-4528-af23-f872139d6576',11,0);
INSERT INTO T_SYS_DICT (id,name,code,pid,seq,type) VALUES ('08a97d86-4f1f-4ca7-a77f-865f7fba57cd','松江区','SJQ','76a9605c-a27d-4528-af23-f872139d6576',12,0);