The function and usage of MySQL stored procedure DELIMITER
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.
