Home  >  Article  >  Database  >  批量修改MYSQL的存储过程或者函数所有者的对象_MySQL

批量修改MYSQL的存储过程或者函数所有者的对象_MySQL

WBOY
WBOYOriginal
2016-06-01 13:48:291121browse

bitsCN.com

use mysql;//此处是数据库自身创建的系统数据库名字是mysql

UPDATE proc set `definer`='新所有者名称' where `definer`='旧所有者名称';

bitsCN.com
Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn