Community Learn Tools Library Leisure
search
English
Home > Backend Development > PHP Tutorial > ，关联查询有关问题，比如省市关联查询，一级省，二级市

，关联查询有关问题，比如省市关联查询，一级省，二级市

WBOY
Release： 2016-06-13 12:09:38
Original
917 people have browsed it

在线等，关联查询问题，比如省市关联查询，一级省，二级市
关联查询问题，比如省市关联查询，一级省，二级市。查出的结果如山东省下有济南青岛，江苏省下面有南京苏州这种形式。
我现在查的是山东济南、山东青岛，江苏南京、江苏苏州这种形式，是一个数组。想查出来那种二维数组怎么写sql
------解决思路----------------------
这和数据的组织方式有直接关系
先说一下你的数据是什么样的
------解决思路----------------------
不能举个例子吗？
结构不同算法就不同

Related labels：
sql
source：php.cn
Previous article：一下一个正则表达式 Next article：php5.4.3连接sqlserver2000有关问题
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
SQL Count() also requires 0 I have only one table and I want to count each entry of a tag that starts with 0. Now I tr...
From 2024-04-06 19:48:53
0
1
449
Calculate the sum of fields in another table using MySQL SQL query I have a schema like this: User table with attributes "user_id" and "userna...
From 2024-04-06 19:39:29
0
1
441
sql groupby not working, I want to group by code_branch ->select('a.statusasstatus','b.nameascustomer_name','e.nameasbranch_name','c.nameas...
From 2024-04-06 19:24:49
0
2
488
Record query under partial value conditions - SQL skill sharing I have a table called zipcode which has a column called code. The Code column contains the...
From 2024-04-06 16:01:26
0
1
395
Node.js: Unable to store SQL query results in an array I'm trying to push the results of a SQL query to an array. However, it doesn't seem to wor...
From 2024-04-06 14:14:46
0
1
373
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template