Shell implementation, mysql stored procedure code directly exported as a file dbcnmysql-h172161194-uroot-p123456; dbBCReport_Sync_Executor; ii0; ct '$ dbcn-N-eselectcount (1) frommysqlprocasp
# Shell implementation: export the stored procedure code in mysql as the file dbcn = "mysql-h172.16.1.194-uroot-p123456"; db = BCReport_Sync_Executor; ii = 0; ct = '$ dbcn-N-e "select count (1) from mysql. proc as p where 1 = 1 and p. db = '$ db' and p. type like 'p % '; "'; mkdir-P/chenenhui/$ dbwhile true; doif [$ ii-lt $ ct] then p = $ ii; let ii ++; echo p = $ p echo ii = $ iispname = '$ dbcn-N-e "select p. name from mysql. proc as p where 1 = 1 and p. db = '$ db' and p. type like 'p % 'limit $ P, 1; "'; echo spname = $ spnamesleep 0; ss = '$ dbcn-N-e" select concat ('delimi ', 'ter ', REPEAT (CHAR (36), 2), 'use', CHAR (96), p. db, CHAR (96), REPEAT (CHAR (36), 2), 'Drop procedure if exists', CHAR (96), p. name, CHAR (96), REPEAT (CHAR (36), 2), 'create DEFINER = ', CHAR (96), LEFT (DEFINER, -1 + LOCATE ('@', DEFINER), CHAR (96), '@', CHAR (96), RIGHT (DEFINER, LENGTH (DEFINER) -LOCATE ('@', DEFINER), CHAR (96), 'Procedure ', CHAR (96), p. name, CHAR (96), '(', p. param_list, ')', p. body_utf8, REPEAT (CHAR (36), 2), 'delimi', 'ter; ') AS SQL _create FROM mysql. proc AS p WHERE 1 = 1 and p. db = '$ db' and p. type LIKE 'p % 'and p. name = '$ spname'; "'echo-e" $ ss ">/chenenhui/$ db/$ spname. sqlecho $ spnameelse echo '_ while finished'; exit 0; fidone