\n
\u5b58\u50a8\u8fc7\u7a0b\u8bed\u6cd5\u9519\u8bef<\/h3>\n
<\/p>\r\n\r\n
\u8bf7\u95ee\u8fd9\u4e2a\u5b58\u50a8\u8fc7\u7a0b\u54ea\u91cc\u9519\u4e86\uff0c\u76ee\u7684\u662f\u6279\u91cf\u5220\u9664\u5b58\u50a8\u8fc7\u7a0b
\r\n\u00a0\u00a01\u00a0delimiter\u00a0\/\/
\r\n\u00a0\u00a02\u00a0CREATE\u00a0DEFINER=`idccapp`@`%`\u00a0PROCEDURE\u00a0`del_routines`()
\r\n\u00a0\u00a03\u00a0begin
\r\n\u00a0\u00a04\u00a0declare\u00a0proccur\u00a0cursor;
\r\n\u00a0\u00a05\u00a0for
\r\n\u00a0\u00a06\u00a0select\u00a0routine_name\u00a0from\u00a0information_schema.routines\u00a0where\u00a0routine_type\u00a0=\u00a0'procedure'\u00a0and\u00a0routine_schema\u00a0=\u00a0'mytest';
\r\n\u00a0\u00a07\u00a0declare\u00a0@procname\u00a0varchar(100);
\r\n\u00a0\u00a08\u00a0open\u00a0proccur;
\r\n\u00a0\u00a09\u00a0fetch\u00a0next\u00a0from\u00a0proccur\u00a0into\u00a0@procname;
\r\n\u00a010\u00a0while(@@FETCH_STATUS\u00a0=\u00a00);
\r\n\u00a011\u00a0begin
\r\n\u00a012\u00a0exec('drop\u00a0proc\u00a0'\u00a0+\u00a0@procname);
\r\n\u00a013\u00a0print(@procname\u00a0+\u00a0'\u5df2\u88ab\u5220\u9664');
\r\n\u00a014\u00a0fetch\u00a0next\u00a0from\u00a0proccur\u00a0into\u00a0@procname;
\r\n\u00a015\u00a0end
\r\n\u00a016\u00a0close\u00a0proccur;
\r\n\u00a017\u00a0deallocate\u00a0proccur;
\r\n\u00a018\u00a0end
\r\n\u00a019\u00a0delimiter\u00a0;
\r\n~\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0
\r\n~\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0
\r\n[root@myecs\u00a0shell_script]#\u00a0mysql\u00a0mytest\u00a0<\u00a0delete_routines.sql\u00a0
\r\nERROR\u00a01064\u00a0(42000)\u00a0at\u00a0line\u00a02:\u00a0You\u00a0have\u00a0an\u00a0error\u00a0in\u00a0your\u00a0SQL\u00a0syntax;\u00a0check\u00a0the\u00a0manual\u00a0that\u00a0corresponds\u00a0to\u00a0your\u00a0MySQL\u00a0server\u00a0version\u00a0for\u00a0the\u00a0right\u00a0syntax\u00a0to\u00a0use\u00a0near\u00a0';\u00a0\u00a0
\r\nfor\u00a0\u00a0
\r\nselect\u00a0routine_name\u00a0from\u00a0information_schema.routines\u00a0where\u00a0routine_typ'\u00a0at\u00a0line\u00a03<\/p><\/p>\n <\/div>\n