02-nation.sql

最新推荐文章于 2025-06-29 12:14:00 发布
原创最新推荐文章于 2025-06-29 12:14:00 发布 · 257 阅读
0 ·
CC 4.0 BY-SA版权
database 专栏收录该内容
45 篇文章
订阅专栏
本文介绍了一次数据库操作，包括删除原有民族类别数据并插入新的民族信息记录，涵盖了从汉族到基诺族等56个民族及其它类别。
摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >
DELETE FROM T_SYS_DICT WHERE pid = 'a7f3b464-38b2-472c-90c5-348a2ffe4df7';

INSERT INTO T_SYS_DICT (id,name,code,pid,seq,type) VALUES ('8a476803-63d4-4aee-a057-9503caa19085','汉族','1','a7f3b464-38b2-472c-90c5-348a2ffe4df7',0,0);
INSERT INTO T_SYS_DICT (id,name,code,pid,seq,type) VALUES ('72250002-3e44-447f-acf7-c58261d8e071','蒙古族','2','a7f3b464-38b2-472c-90c5-348a2ffe4df7',1,0);
INSERT INTO T_SYS_DICT (id,name,code,pid,seq,type) VALUES ('9213078b-d543-432a-9818-fc2f1573c33f','回族','3','a7f3b464-38b2-472c-90c5-348a2ffe4df7',2,0);
INSERT INTO T_SYS_DICT (id,name,code,pid,seq,type) VALUES ('db3c3556-be99-4a31-bb81-6412e371fcf4','藏族','4','a7f3b464-38b2-472c-90c5-348a2ffe4df7',3,0);
INSERT INTO T_SYS_DICT (id,name,code,pid,seq,type) VALUES ('cc1a905e-9fef-4d1c-805d-6feb7ce16d05','维吾尔族','5','a7f3b464-38b2-472c-90c5-348a2ffe4df7',4,0);
INSERT INTO T_SYS_DICT (id,name,code,pid,seq,type) VALUES ('29e78fe2-e510-4f21-b84f-021e80494d33','苗族','6','a7f3b464-38b2-472c-90c5-348a2ffe4df7',5,0);
INSERT INTO T_SYS_DICT (id,name,code,pid,seq,type) VALUES ('b6b78c90-985a-4dbd-a012-8dd4b85560ca','彝族','7','a7f3b464-38b2-472c-90c5-348a2ffe4df7',6,0);
INSERT INTO T_SYS_DICT (id,name,code,pid,seq,type) VALUES ('a7a97885-6cf8-4130-a83a-a46297e5a050','壮族','8','a7f3b464-38b2-472c-90c5-348a2ffe4df7',7,0);
INSERT INTO T_SYS_DICT (id,name,code,pid,seq,type) VALUES ('93250c17-2dec-4b78-ae78-00e2ff98c547','布依族','9','a7f3b464-38b2-472c-90c5-348a2ffe4df7',8,0);
INSERT INTO T_SYS_DICT (id,name,code,pid,seq,type) VALUES ('d080722c-71f2-4289-a4f4-c476a4696045','朝鲜族','10','a7f3b464-38b2-472c-90c5-348a2ffe4df7',9,0);
INSERT INTO T_SYS_DICT (id,name,code,pid,seq,type) VALUES ('2f4b9f44-bbf5-4e24-a063-e68538aedc9d','满族','11','a7f3b464-38b2-472c-90c5-348a2ffe4df7',10,0);
INSERT INTO T_SYS_DICT (id,name,code,pid,seq,type) VALUES ('5aabaf1e-e28c-4ade-8dc1-376006d5b7f1','侗族','12','a7f3b464-38b2-472c-90c5-348a2ffe4df7',11,0);
INSERT INTO T_SYS_DICT (id,name,code,pid,seq,type) VALUES ('bd09564e-e14b-4f6f-80e7-5a81ee70b63e','瑶族','13','a7f3b464-38b2-472c-90c5-348a2ffe4df7',12,0);
INSERT INTO T_SYS_DICT (id,name,code,pid,seq,type) VALUES ('49137e75-e77b-42a4-b66f-f7bf5b9e0d95','白族','14','a7f3b464-38b2-472c-90c5-348a2ffe4df7',13,0);
INSERT INTO T_SYS_DICT (id,name,code,pid,seq,type) VALUES ('b271b804-6409-4f76-a763-026e08d014aa','土家族','15','a7f3b464-38b2-472c-90c5-348a2ffe4df7',14,0);
INSERT INTO T_SYS_DICT (id,name,code,pid,seq,type) VALUES ('312420cc-1c3d-40d7-8f61-8d17ba9fed4e','哈尼族','16','a7f3b464-38b2-472c-90c5-348a2ffe4df7',15,0);
INSERT INTO T_SYS_DICT (id,name,code,pid,seq,type) VALUES ('95b19faf-b28c-43af-81d0-d6e3554032aa','哈萨克族','17','a7f3b464-38b2-472c-90c5-348a2ffe4df7',16,0);
INSERT INTO T_SYS_DICT (id,name,code,pid,seq,type) VALUES ('64a49697-5545-4fc8-b241-ff851b9d6caf','傣族','18','a7f3b464-38b2-472c-90c5-348a2ffe4df7',17,0);
INSERT INTO T_SYS_DICT (id,name,code,pid,seq,type) VALUES ('d3e46da1-88aa-46a3-bc15-48fefe904fb4','黎族','19','a7f3b464-38b2-472c-90c5-348a2ffe4df7',18,0);
INSERT INTO T_SYS_DICT (id,name,code,pid,seq,type) VALUES ('c2eff56f-3964-461b-97ae-9036af7b51f1','傈僳族','20','a7f3b464-38b2-472c-90c5-348a2ffe4df7',19,0);
INSERT INTO T_SYS_DICT (id,name,code,pid,seq,type) VALUES ('0cc7379e-5607-46d7-9fdc-8e1322023e39','佤族','21','a7f3b464-38b2-472c-90c5-348a2ffe4df7',20,0);
INSERT INTO T_SYS_DICT (id,name,code,pid,seq,type) VALUES ('736b7636-65c3-4d5e-88e9-55626ca4ba66','畲族','22','a7f3b464-38b2-472c-90c5-348a2ffe4df7',21,0);
INSERT INTO T_SYS_DICT (id,name,code,pid,seq,type) VALUES ('96c8373e-69a6-4447-8784-45dc1c161669','高山族','23','a7f3b464-38b2-472c-90c5-348a2ffe4df7',22,0);
INSERT INTO T_SYS_DICT (id,name,code,pid,seq,type) VALUES ('d7a01806-db1f-4003-b919-39399b156883','拉祜族','24','a7f3b464-38b2-472c-90c5-348a2ffe4df7',23,0);
INSERT INTO T_SYS_DICT (id,name,code,pid,seq,type) VALUES ('1141cda4-ccf7-43d9-ae4f-32a39ce149b6','水族','25','a7f3b464-38b2-472c-90c5-348a2ffe4df7',24,0);
INSERT INTO T_SYS_DICT (id,name,code,pid,seq,type) VALUES ('ac9a29e6-ab59-402b-bf84-7cad5e3d378e','东乡族','26','a7f3b464-38b2-472c-90c5-348a2ffe4df7',25,0);
INSERT INTO T_SYS_DICT (id,name,code,pid,seq,type) VALUES ('d20ae88b-0fe3-4b1d-b74b-cd8b6ce27b34','纳西族','27','a7f3b464-38b2-472c-90c5-348a2ffe4df7',26,0);
INSERT INTO T_SYS_DICT (id,name,code,pid,seq,type) VALUES ('dd4d0838-8705-4f1d-a2b9-7107244e9da4','景颇族','28','a7f3b464-38b2-472c-90c5-348a2ffe4df7',27,0);
INSERT INTO T_SYS_DICT (id,name,code,pid,seq,type) VALUES ('69181414-bbea-43db-a891-d9a3821354aa','柯尔克孜族','29','a7f3b464-38b2-472c-90c5-348a2ffe4df7',28,0);
INSERT INTO T_SYS_DICT (id,name,code,pid,seq,type) VALUES ('549e3732-81de-406a-9368-f9ab67c59281','土族','30','a7f3b464-38b2-472c-90c5-348a2ffe4df7',29,0);
INSERT INTO T_SYS_DICT (id,name,code,pid,seq,type) VALUES ('5cb71012-260f-4445-9eb7-09ab83f7a311','达斡尔族','31','a7f3b464-38b2-472c-90c5-348a2ffe4df7',30,0);
INSERT INTO T_SYS_DICT (id,name,code,pid,seq,type) VALUES ('768ce5cc-3549-473d-a0bc-5ee29d9c94fc','仫佬族','32','a7f3b464-38b2-472c-90c5-348a2ffe4df7',31,0);
INSERT INTO T_SYS_DICT (id,name,code,pid,seq,type) VALUES ('7ba4ad17-2bb2-4216-93a5-af367232bd8e','羌族','33','a7f3b464-38b2-472c-90c5-348a2ffe4df7',32,0);
INSERT INTO T_SYS_DICT (id,name,code,pid,seq,type) VALUES ('19a1b7ff-9566-44c8-89fa-185067dc0fbe','布朗族','34','a7f3b464-38b2-472c-90c5-348a2ffe4df7',33,0);
INSERT INTO T_SYS_DICT (id,name,code,pid,seq,type) VALUES ('b5f739d0-7b8d-42bf-85fc-162c7e95c2fe','撒拉族','35','a7f3b464-38b2-472c-90c5-348a2ffe4df7',34,0);
INSERT INTO T_SYS_DICT (id,name,code,pid,seq,type) VALUES ('7da625ac-42eb-4efc-99a1-e7b92710ad4e','毛难族','36','a7f3b464-38b2-472c-90c5-348a2ffe4df7',35,0);
INSERT INTO T_SYS_DICT (id,name,code,pid,seq,type) VALUES ('e12116cb-936a-473b-aa90-9d85a6ad81f8','仡佬族','37','a7f3b464-38b2-472c-90c5-348a2ffe4df7',36,0);
INSERT INTO T_SYS_DICT (id,name,code,pid,seq,type) VALUES ('df811711-255c-48b5-8c2c-9dbe9bb551dc','锡伯族','38','a7f3b464-38b2-472c-90c5-348a2ffe4df7',37,0);
INSERT INTO T_SYS_DICT (id,name,code,pid,seq,type) VALUES ('f0df017a-102a-4121-a357-523b81f032d8','阿昌族','39','a7f3b464-38b2-472c-90c5-348a2ffe4df7',38,0);
INSERT INTO T_SYS_DICT (id,name,code,pid,seq,type) VALUES ('20ee2e2a-88ce-4cf7-8842-7deb13a7708f','普米族','40','a7f3b464-38b2-472c-90c5-348a2ffe4df7',39,0);
INSERT INTO T_SYS_DICT (id,name,code,pid,seq,type) VALUES ('cf831088-d398-40e6-891e-0a6a1fcebc82','塔吉克族','41','a7f3b464-38b2-472c-90c5-348a2ffe4df7',40,0);
INSERT INTO T_SYS_DICT (id,name,code,pid,seq,type) VALUES ('588276ed-b643-4553-a3fe-6a8434cd506c','怒族','42','a7f3b464-38b2-472c-90c5-348a2ffe4df7',41,0);
INSERT INTO T_SYS_DICT (id,name,code,pid,seq,type) VALUES ('84f9f3e5-c059-4c6e-b292-c24ac8581b2e','乌孜别克族','43','a7f3b464-38b2-472c-90c5-348a2ffe4df7',42,0);
INSERT INTO T_SYS_DICT (id,name,code,pid,seq,type) VALUES ('e9b763f7-915a-43ab-b5cc-97d87cd38857','俄罗斯族','44','a7f3b464-38b2-472c-90c5-348a2ffe4df7',43,0);
INSERT INTO T_SYS_DICT (id,name,code,pid,seq,type) VALUES ('a206a866-d997-4105-9699-01e9565caa39','鄂温克族','45','a7f3b464-38b2-472c-90c5-348a2ffe4df7',44,0);
INSERT INTO T_SYS_DICT (id,name,code,pid,seq,type) VALUES ('899be4de-84d9-4f6e-99db-e7679cadab23','崩龙族','46','a7f3b464-38b2-472c-90c5-348a2ffe4df7',45,0);
INSERT INTO T_SYS_DICT (id,name,code,pid,seq,type) VALUES ('05daa476-adf3-41cc-adfb-73d7655abbeb','保安族','47','a7f3b464-38b2-472c-90c5-348a2ffe4df7',46,0);
INSERT INTO T_SYS_DICT (id,name,code,pid,seq,type) VALUES ('de684dbc-9cf4-4e0a-a790-aa8182a3a228','裕固族','48','a7f3b464-38b2-472c-90c5-348a2ffe4df7',47,0);
INSERT INTO T_SYS_DICT (id,name,code,pid,seq,type) VALUES ('0ba1fad6-1843-48b9-8c6e-19d534d32c55','京族','49','a7f3b464-38b2-472c-90c5-348a2ffe4df7',48,0);
INSERT INTO T_SYS_DICT (id,name,code,pid,seq,type) VALUES ('70db7890-6265-49ce-bc52-8052eee00c4e','塔塔尔族','50','a7f3b464-38b2-472c-90c5-348a2ffe4df7',49,0);
INSERT INTO T_SYS_DICT (id,name,code,pid,seq,type) VALUES ('223da740-f855-43e1-b3e9-50d32c197824','独龙族','51','a7f3b464-38b2-472c-90c5-348a2ffe4df7',50,0);
INSERT INTO T_SYS_DICT (id,name,code,pid,seq,type) VALUES ('41c01b45-ae61-4e9c-8f6b-9f5bf1209aca','鄂伦春族','52','a7f3b464-38b2-472c-90c5-348a2ffe4df7',51,0);
INSERT INTO T_SYS_DICT (id,name,code,pid,seq,type) VALUES ('e02a2e18-38a5-4a7b-abef-e8db5a52e4d0','赫哲族','53','a7f3b464-38b2-472c-90c5-348a2ffe4df7',52,0);
INSERT INTO T_SYS_DICT (id,name,code,pid,seq,type) VALUES ('660b0d55-e0f5-4942-abb3-09f6a078373e','门巴族','54','a7f3b464-38b2-472c-90c5-348a2ffe4df7',53,0);
INSERT INTO T_SYS_DICT (id,name,code,pid,seq,type) VALUES ('ccc37d2e-4daf-42eb-97f0-0643ec48817b','珞巴族','55','a7f3b464-38b2-472c-90c5-348a2ffe4df7',54,0);
INSERT INTO T_SYS_DICT (id,name,code,pid,seq,type) VALUES ('a01a66bb-520d-4ce6-917b-d588eab078bc','基诺族','56','a7f3b464-38b2-472c-90c5-348a2ffe4df7',55,0);
INSERT INTO T_SYS_DICT (id,name,code,pid,seq,type) VALUES ('1886cad0-f2fb-472c-be14-d6a6b4781f5e','其他','57','a7f3b464-38b2-472c-90c5-348a2ffe4df7',56,0);
INSERT INTO T_SYS_DICT (id,name,code,pid,seq,type) VALUES ('24e6652e-36b0-4b4b-993c-8ad4baac6b26','外国血统','58','a7f3b464-38b2-472c-90c5-348a2ffe4df7',57,0);

SELECT * FROM T_SYS_DICT WHERE pid = 'a7f3b464-38b2-472c-90c5-348a2ffe4df7';