MySQL Cookbook: Difference between revisions
Jump to navigation
Jump to search
(Created page with "==Create table== <syntaxhighlight lang="mysql"> CREATE TABLE IF NOT EXISTS `shipping_rates` ( `id` int(11) NOT NULL auto_increment , `region` varchar(50) default NULL , IND...") |
No edit summary |
||
| (4 intermediate revisions by the same user not shown) | |||
| Line 9: | Line 9: | ||
</syntaxhighlight> | </syntaxhighlight> | ||
[[Category:MySQL]] | == Change the definer of a procedure == | ||
[[Category:Web Development]] | |||
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"> | |||
SHOW PROCEDURE status; | |||
</syntaxhighlight> | |||
Change definers with | |||
<syntaxhighlight lang="mysql"> | |||
UPDATE `mysql`.`proc` p SET definer = '[NEW_DEFINER]' WHERE definer='[OLD_DEFINER]'; | |||
</syntaxhighlight> | |||
For example: | |||
<syntaxhighlight lang="mysql"> | |||
UPDATE `mysql`.`proc` p SET definer = 'new_user@%' WHERE definer='user@%'; | |||
</syntaxhighlight> | |||
== See also == | |||
*[[MySQL Full-Text Search]] | |||
== Reference == | |||
<references /> | |||
[[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