\ncreate PROCEDURE ut()
\nbegin<\/p>\n
declare _done int default 0;
\ndeclare _id bigint;
\ndeclare _type tinyint;<\/p>\n
declare cur cursor for select gn_number from groupnumber;
\ndeclare continue handler for not found set _done = 1; <\/p>\n
open cur;<\/p>\n
repeat
\nfetch cur into _id;
\nif not _done then
\n select ai_type into _type from alcoholinfo where ai_number=_id limit 1;
\n update groupnumber set gn_alcoholtype=_type where gn_number=_id;
\nend if;
\nuntil _done end repeat;
\nclose cur;<\/p>\n
end;<\/p>\n
call ut();
\ndrop PROCEDURE ut;<\/p>\n","protected":false},"excerpt":{"rendered":"
\ncreate PROCEDURE ut()
\nbegin<\/p>\n
declare _done int default 0;
\ndeclare _id bigint;
\ndeclare _type tinyint;<\/p>\n
declare cur cursor for select gn_number from groupnumber;
\ndeclare continue handler for not found set _done = 1; <\/p>\n
open cur;<\/p>\n
repeat
\nfetch cur into _id;
\nif not _done then
\n select... \u7ee7\u7eed\u9605\u8bfb