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

Today, the editor will share with you the relevant knowledge points about how to use the leave sentence in mysql. The content is detailed and the logic is clear. I believe most people still know too much about this knowledge, so share this article for your reference. I hope you can get something after reading this article.

Description

1. Leave means leaving the exit loop, just like break in programming.

2. It is used to exit from the annotated process construction, usually with BEGIN. Use END or loop together.

Example

Delimiter $CREATE PROCEDURE pro_test11 (n int) BEGIN declare total int default 0; ins: LOOP IF n

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.