MySQL5.5 stored procedures support limit Variables

MySQL5.5 stored procedures support limit Variables

When reviewing the developed SQL statements, they found a stored procedure that was pieced together with a dynamic SQL (CONCAT () function). In this way, the performance was not as good as static SQL, so they were asked 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,


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



Completely OK, everything goes well.