简体中文(ZH-CN) English(EN) 繁体中文(ZH-TW) 日本語(JA) 한국어(KO) Melayu(MS) Français(FR) Deutsch(DE)
Home > Database > Mysql Tutorial > body text

MySQL5.5 存储过程支持limit变量

WBOY
Release： 2016-06-07 17:41:56
Original
1198 people have browsed it

今天我在审核开发的SQL时，发现有个存储过程他们是用动态SQL（CONCAT()函数）拼凑的，这样性能没有静态SQL好，于是让他们更改，结果他们说创建存储过程报错，我

今天我在审核开发的SQL时，发现有个存储过程他们是用动态SQL（CONCAT()函数）拼凑的，香港服务器租用，这样性能没有静态SQL好，于是让他们更改，结果他们说创建存储过程报错，我很纳闷，不应该啊，网站空间，我这边没问题，结果咨询了那边，测试环境是用的MySQL5.1，而我这边是MySQL5.5，版本的问题。
 

下面我做了一个测试，这个是MySQL5.1的，如图：


创建果然报错，再来看看MySQL5.5的表现，如图：
 


完全OK，香港服务器，一切顺利。

 

本文出自 “贺春旸的技术专栏” 博客，请务必保留此出处

Related labels：
limit stored procedure
source：php.cn
Previous article： RMAN高级应用之同机复制数据库 Next article： 生产环境高并发MySQL SQL语句优化案例
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
What are the best practices for displaying version information in web applications? I'm developing a web application. What are the best practices for displaying version infor...
From 2024-04-06 19:13:16
0
2
476
Generate default values ​​and CSS variables using SCSS I'm implementing website styling. For legacy support reasons, I need to support IE11, at l...
From 2024-04-06 17:46:54
0
1
355
Compare Imagick, Adobe Photoshop and Windows - Detect resolution (pixels per centimeter or pixels per inch) This is not a question but an attempt to improve my understanding of how DPI is stored in ...
From 2024-04-06 16:01:27
0
1
397
Regular expression filter for MERN stack search boxes and checkboxes I'm trying to understand how the MERN stack works together by learning by doing, and I'm f...
From 2024-04-06 14:53:12
0
1
425
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
About us Disclaimer Sitemap
php.cn：Public welfare online PHP training，Help PHP learners grow quickly！