MySQL Cookbook

Create table

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

To see all definers:

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

• MySQL Full-Text Search