• 日期: 2027-07-18 16:45:55
  • 标签: 社会

SELECT (SELECT name FROM zc_system_city WHERE city_id = 487723) AS city, (SELECT name FROM zc_system_city WHERE city_id = (SELECT parent_id FROM zc_system_city WHERE city_id = 487723)) AS province, (SELECT name FROM zc_system_city WHERE city_id = (SELECT parent_id FROM zc_system_city WHERE city_id = (SELECT parent_id FROM zc_system_city WHERE city_id = 487723))) AS country FROM zc_system_city LIMIT 1

SELECT name FROM zc_system_city WHERE city_id = SELECT parent_id FROM zc_system_city WHERE city_id = SELECT parent_id FROM zc_system_city WHERE city_id = 487723 改一下这个sql 把每次子查询的结果合并上次的结果 也返回出去SELE

原文地址: https://www.cveoy.top/t/topic/bXkR 著作权归作者所有。请勿转载和采集!

免费AI点我,无需注册和登录