SELECT
CONCAT(
'sqlstr=$(cat /chenenhui/',p.db,'/',p.name,'.sql)',
CHAR(10),
'`$mysql_dev -N -e " $sqlstr"`'
) ssss
FROM mysql.proc AS p
WHERE p.type LIKE '%PROCEDURE%' AND p.db IN ('AdAPI_Executor','BuyerCenterIS_Executor','BuyerCenter_Executor')
ORDER BY p.`created` DESC
SELECT * FROM mysql.proc p
WHERE p.db IN ('AdAPI_Executor','BuyerCenterIS_Executor','BuyerCenter_Executor')
AND p.`definer` != 'root@%'
UPDATE mysql.proc p
SET p.`definer` = 'root@%'
WHERE p.db IN ('AdAPI_Executor','BuyerCenterIS_Executor','BuyerCenter_Executor')
AND p.`definer` != 'root@%'