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

The following content mainly brings you MYSQL if judgment and while cycle, the knowledge here is slightly different from books, are summed up by professional and technical personnel in the process of contact with users, have a certain experience sharing value, hope to bring help to the majority of readers.

If judges delimiter / / CREATE PROCEDURE proc_if () BEGIN declare i int default 0; if I = 1 THEN SELECT 1; ELSEIF I = 2 THEN SELECT 2; ELSE SELECT 7; END IF;END / / delimiter; while cycle

Delimiter / / create proceduer proc_while () begin declare num int; set num = 0; while num < 10 do select num; set num = num + 1; end while; end / /

Delimiter

For the above if judgment and while cycle of MYSQL, if you need to know more, you can continue to pay attention to the innovation of our industry. If you need professional answers, you can contact the pre-sales and after-sales on the official website. I hope this article can bring you some knowledge updates.

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.