zf-about the charge statistics didn't come out Jianli County problem

This problem is known as a stored procedure, so I went directly to the background implementation class found this stored procedure

The first sentence in the stored procedure is that quhua_code, from SELECT, queries out 4 names and then gives the @quhua_code temporary table the data from this query.

Then put this query statement in the new query to take out a separate query because @quhua_code out will be an error (because it is a temporary table), so you have to go backstage to break point to find his code

Find it and write it as a box in the Red line to query

And then this Hubei province code is 420000 where in the Parent_code field if it is also 420000, then this place is the child of Hubei province, but Jianli County is the child of Jingzhou, so it only inquires 3 places

There is no Jianli County, so if you want to query out 4 places, then the where query conditions to write off

This is what it looks like after you log out, and then the stored procedure is done.

zf-about the charge statistics didn't come out Jianli County problem