Shulou(Shulou.com)05/31 Report--

In order to solve the problem of compiling stored procedures in mysql linux environment, this article introduces the corresponding analysis and solutions in detail, hoping to help more partners who want to solve this problem to find a more simple and easy way.

Mysql > DELIMITER / /

Mysql > CREATE PROCEDURE proc1 (OUT s int)

-> BEGIN

-> SELECT COUNT (*) INTO s FROM user

-> END

-> / /

Mysql > DELIMITER

Note:

(1) what we need to pay attention to here are DELIMITER / / and DELIMITER; in two sentences, DELIMITER means a delimiter, because MySQL defaults to ";". If we do not declare a delimiter, the compiler will treat the stored procedure as a SQL statement, and the compilation process of the stored procedure will report an error, so the current segment delimiter must be declared with the DELIMITER keyword in advance, so that MySQL will set the " "as code in a stored procedure, the code will not be executed and the delimiter will be restored when it is used up.

Display all 2165 possibilities? (y or n)

The statement contains the tab key, which causes the problem. Delete all suspected tabs in the statement and execute it again.

The answer to the question about how the mysql linux environment compiles stored procedures is shared here. I hope the above content can be of some help to you. If you still have a lot of doubts to be solved, you can follow the industry information channel to learn more about it.

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.