{"status":true,"html":"
\u00a0 1 delimiter \/\/ ---------------------<\/p>\r\n\r\n ERROR 1064 (42000) at line 2: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '@procname<\/a> varchar(100); \u597d\u50cf\u65e0\u6cd5\u8fd9\u6837\u58f0\u660e\u53d8\u91cf: declare @procname varchar(100);<\/p>\r\n\r\n \u5982\u679c\u6211\u628a@procname \u6539\u6210: procname \u4e5f\u4f1a\u51fa\u73b0\u5176\u5b83\u95ee\u9898:<\/p>\r\n\r\n ERROR 1337 (42000) at line 2: Variable or condition declaration after cursor or handler declaration<\/p>\r\n\r\n \u00a0<\/p>\r\n\r\n \u00a0<\/p><\/p>\n <\/div>\n
\r\n\u00a0 2 CREATE DEFINER=`idccapp`@`%<\/a>` PROCEDURE `del_routines`()
\r\n\u00a0 3 begin
\r\n\u00a0 4 declare proccur cursor for select routine_name from information_schema.routines where routine_type = 'procedure'\u00a0\u00a0\u00a0\u00a0 and routine_schema = 'mytest';
\r\n\u00a0 5 declare @procname varchar(100);
\r\n\u00a0 6 open proccur;
\r\n\u00a0 7 fetch next from proccur into @procname;
\r\n\u00a0 8 while(@@FETCH_STATUS = 0);
\r\n\u00a0 9 begin
\r\n\u00a010 exec('drop proc ' + @procname);
\r\n\u00a011 print(@procname + '\u5df2\u88ab\u5220\u9664');
\r\n\u00a012 fetch next from proccur into @procname;
\r\n\u00a013 end
\r\n\u00a014 close proccur;
\r\n\u00a015 deallocate proccur;
\r\n\u00a016 end \/\/
\r\n\u00a017 delimiter ;
\r\n~\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/p>\r\n\r\n
\r\nopen proccur;\u00a0
\r\nfetch next from proccur into @procname;
\r\n' at line 4<\/p>\r\n\r\n