Tuesday, March 20, 2018

Changing the stored procedure name in MYSQL


We can use the following query to rename the stored procedure in MYSQL,

UPDATE `mysql`.`proc`
SET name = '',
specific_name = ''
WHERE db = '' AND
  name = '';