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

-create-- SQL function must have a return value-- create function function name (argument list) returns return type create function F1 () returns intreturn 10-View-View mysql.proc select db,name,type from mysql.proc;- call-call select F1 ();-delete-delete function drop function F1; delete from mysql.proc where name = 'xx' -variable-- temporarily modify delimiter / / create function F1 (an int,b int) returns intbegin-- to define a variable resdeclare res int default 0-from mm_users-assign the result of a + b to resset res = a + b-return resreturn res;end//delimiter;-- Note of user variables-- you cannot use'= 'select count (*) from mm_users when assigning values to user variables in the sql statement. Select @ count = count (*) from mm_users;--'= 'means to judge whether it is equal or not-judge if condition 1 then statement 1 else if condition 2 then statement end if;- loop while condition do statement; end while; exit loop: leave, equivalent to break exit this loop: iterate, equivalent to continue- example delimiter / / create function f3 () returns varchar (300) begin-- 1. Declare the increment value I, the resdeclare i int default 0 of the splicing result: res varchar (300) default';-- 2. Increment iwhile I through while

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.