Home >Database >Mysql Tutorial >mysql存储过程写分页程序_MySQL
mysql存储过程写分页程序_MySQL
- WBOYOriginal
- 2016-06-01 13:39:121029browse
bitsCN.com
mysql存储过程写分页程序 /*分页程序*/delimiter //drop procedure if exists sp_page;create procedure sp_page( p_table_name varchar(1024), p_fields varchar(1024), p_page_size int, p_curr_page int, p_order_string varchar(256), p_where_string varchar(1024), out p_total_rows int ) not deterministic sql security definer comment '分页存储过程' begin /*变量的申明*/ declare v_start_row int default 0; declare v_limit_string varchar(256); /*给变量赋值*/ if p_curr_page
Statement：
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
Previous article：Linux修改xampp下mysql的编码问题_MySQLNext article：如何使用SQL Profiler性能分析器_MySQL