MySQL5.5 stored procedures support limit Variables

Today, when I reviewed the developed SQL statements, I found that a stored procedure was pieced together with a dynamic SQLCONCAT () function. In this way, the performance is not good for static SQL, so I asked them to change it, as a result, they said that an error was reported during the storage creation process. I was puzzled. No problem was found here. After consulting, the test environment was MySQL5.1, while MySQL5.5 was used, version issues.
 

Next I did a test. This is from MySQL5.1,

650) this. width = 650; "border =" 0 "src =" http://www.bkjia.com/uploads/allimg/131228/2249562461-0.jpg "alt =" "/>

An error occurred while creating the instance. Let's take a look at the performance of MySQL5.5,
 

650) this. width = 650; "border =" 0 "src =" http://www.bkjia.com/uploads/allimg/131228/22495C030-1.jpg "alt =" "/>

Completely OK, everything goes well.

 

This article is from the "hechun's technical column" blog, please be sure to keep this source http://hcymysql.blog.51cto.com/5223301/1193962