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

MySQL stored procedure is a sql statement, so how do we create it? MySQL stored procedure creation and modification, delete operation.

1, stored procedure creation

DELIMITER / /

CREATE PROCEDURE GetAllProducts ()

BEGIN

SELECT * FROM products

END / /

DELIMITER

Use the key words create, procedure begin end

2, stored procedure call method

CALL GetAllProducts ()

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.