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

Stored procedure is a code segment, in the mysql execution process, encountered the semicolon on the execution, how to change the semicolon, let the code continue to execute, the following talk about the role and usage of the MySQL stored procedure DELIMITER.

1the function of DELIMITER stored procedure MySQL changes the semicolon of the execution statement, which can be changed to DELIMITER / / or DELIMITER $$2. The usage of MySQL stored procedure DELIMITER $/ / defines & & CREATE PROCEDURE GetAllProducts ()

BEGIN

SELECT * FROM products

END $$/ / end $$

DELIMITER; / / change back to the original

The article is from www.huthon.cn.

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.