Shulou(Shulou.com)06/01 Report--

This article mainly introduces the solution to the 1064 error in navicat for mysql, which has certain reference value and can be used for reference by friends who need it. I hope you will learn a lot after reading this article. Next, let the editor take you to learn about it.

A 1064 error occurred when the function was created in navicat for mysql and saved, as shown below:

It is basically caused by two reasons:

1. The length of the parameter of the stored procedure is not set. We need to add the length of the parameter when we create the stored procedure in Navicat, otherwise this error will occur.

Add the length of the parameter and then save it without error.

2. If the parameters are fine, check your own sql code, which is basically caused by the syntax error of the code.

Sure enough, it was because there was no delimiter.

MySQL defaults to ";" as the delimiter. If no delimiter is declared, the compiler will treat the stored procedure as a SQL statement, so the compilation process will report an error.

So declare the current segment delimiter with "DELIMITER / /" in advance, and let the compiler treat the content between the two "/ /" as the code of the stored procedure, which will not be executed.

"DELIMITER;" means to restore the delimiter.

Thank you for reading this article carefully. I hope it will be helpful for everyone to share the solutions to the 1064 errors in navicat for mysql. At the same time, I also hope that you will support us, pay attention to the industry information channel, and find out if you encounter problems. Detailed solutions are waiting for you to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.