# `Sp_Do_ProcedurePageTree` (procedure) > 过程插入20条数据后,获取分组,分页条数 - **Type:** PROCEDURE - **Deterministic:** NO - **SQL data access:** CONTAINS SQL - **Created:** 2026-04-27 19:10:32 - **Last altered:** 2026-04-27 19:10:32 ## Parameters | # | Mode | Name | Type | |---|---|---|---| | 1 | IN | `p_sTmpTableName` | `varchar(1000)` | | 2 | IN | `p_sSumTableName` | `longtext` | | 3 | IN | `p_sTmpTableWhere` | `longtext` | | 4 | IN | `p_sLimit` | `varchar(500)` | | 5 | IN | `p_sTbNameBm` | `varchar(10)` | | 6 | IN | `countCloumn` | `varchar(5000)` | | 7 | IN | `p_sumCloumn` | `longtext` | | 8 | OUT | `totalCount` | `int` | | 9 | OUT | `countMapJson` | `longtext` | | 10 | OUT | `p_sSumSql` | `longtext` | ## Body _Body is not pre-cached. To inspect: `mysql --defaults-file=~/.my.cnf -e 'SHOW CREATE PROCEDURE `Sp_Do_ProcedurePageTree`'`._ ## Narrative _No human-written narrative yet._