MySQL plsql Demo-003. Static cursors

Drop procedure if existsP_hello_world;Create procedureP_hello_world ()begin    DeclareIdinteger; DeclareUsernamevarchar( the); DeclareResultvarchar(4000)default "'; /*don ' t work*/    /*declare cur_user cursor for the Select ID from p_user where the ID is not null and the name is not a null order by ID;*/    DeclareCur_usercursor  for SelectT.id, T.name fromP_user TwhereT.id is  not NULL  andT.name is  not NULL Order  byt.id; Declare ContinueHandler forSQLSTATE'02000' SetId= NULL; OpenCur_user; FetchCur_user intoID, username;  while(ID is  not NULL) doSetResult=Concat (Result,'ID:'Id'Username:', username,';'); FetchCur_user intoID, username; End  while; CloseCur_user; Selectresult;End; call P_hello_world ();

MySQL plsql Demo-003. Static cursors