mysql递归查广东省市区
时间: 2023-07-06 12:43:24 浏览: 81
在 MySQL 中,可以使用递归查询语句来实现查找广东省市区的操作。以下是一个示例:
```
WITH RECURSIVE
gd_province AS (
SELECT id, name, parent_id
FROM province
WHERE name = '广东省'
),
gd_city AS (
SELECT id, name, parent_id
FROM city
WHERE parent_id = (SELECT id FROM gd_province)
),
gd_district AS (
SELECT id, name, parent_id
FROM district
WHERE parent_id IN (SELECT id FROM gd_city)
),
gd_region AS (
SELECT id, name, parent_id
FROM district
WHERE parent_id IN (SELECT id FROM gd_district)
)
SELECT name AS region_name
FROM (
SELECT name, parent_id FROM gd_province
UNION ALL
SELECT name, parent_id FROM gd_city
UNION ALL
SELECT name, parent_id FROM gd_district
UNION ALL
SELECT name, parent_id FROM gd_region
) AS t
ORDER BY parent_id;
```
以上语句使用了递归查询语法,从广东省开始,依次查询其下属的市、区、街道等地区,最终返回所有地区的名称。需要注意的是,以上语句中的表名和字段名需要根据实际情况进行修改。
阅读全文