帮我优化一下脚本:SELECT codenameSELECT name FROM st_streets where street_code=code streetNameSELECT name FROM st_areas where area_code=code areaNameSELECT name FROM st_cities where city_code=code cityNameSELE
SELECT v.code, v.name, s.name AS streetName, a.name AS areaName, c.name AS cityName, p.name AS provinceName FROM st_villages v LEFT JOIN st_streets s ON s.street_code = v.code LEFT JOIN st_areas a ON a.area_code = v.code LEFT JOIN st_cities c ON c.city_code = v.code LEFT JOIN st_provinces p ON p.province_code = v.code WHERE v.code LIKE '4401%' ORDER BY v.code DESC
原文地址: https://www.cveoy.top/t/topic/fdHq 著作权归作者所有。请勿转载和采集!