MySQL Cookbook: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
|||
| Line 8: | Line 8: | ||
); | ); | ||
</syntaxhighlight> | </syntaxhighlight> | ||
== Change the definer of a procedure == | == Change the definer of a procedure == | ||
To see all definers: | To see all definers: <ref>[https://stackoverflow.com/questions/3206820/change-the-stored-procedure-definer Change the stored procedure definer] - StackOverflow</ref> | ||
<syntaxhighlight lang="mysql"> | <syntaxhighlight lang="mysql"> | ||
| Line 32: | Line 29: | ||
</syntaxhighlight> | </syntaxhighlight> | ||
== See also == | |||
*[[MySQL Full-Text Search]] | |||
== Reference == | |||
<references /> | |||
[[Category:MySQL]] [[Category:MariaDB]] [[Category:Web Development]] | [[Category:MySQL]] [[Category:MariaDB]] [[Category:Web Development]] | ||
Latest revision as of 15:46, 15 September 2024
Create table[edit]
CREATE TABLE IF NOT EXISTS `shipping_rates` ( `id` int(11) NOT NULL auto_increment , `region` varchar(50) default NULL , INDEX `IX_shipping_rates_region` (`region` ASC) , PRIMARY KEY (`id`) );
Change the definer of a procedure[edit]
To see all definers: [1]
SHOW PROCEDURE status;
Change definers with
UPDATE `mysql`.`proc` p SET definer = '[NEW_DEFINER]' WHERE definer='[OLD_DEFINER]';
For example:
UPDATE `mysql`.`proc` p SET definer = 'new_user@%' WHERE definer='user@%';
See also[edit]
Reference[edit]
- ↑ Change the stored procedure definer - StackOverflow