1、导出存储过程
CREATE DEFINER=`root`@`localhost` PROCEDURE `c4mo_get_cities_prc`(IN `p_state_code` VARCHAR(3), IN `p_country_code` VARCHAR(3), IN `p_language_code` VARCHAR(3))
NO SQL
BEGIN
SELECT city_name, city_code
FROM `c4mo_cities`
WHERE enabled = 'Y'
AND language_code = p_language_code
AND state_code = p_state_code
AND country_code = p_country_code;
END
2、编辑修改,去掉DEFINER = root
@ localhost这部分,如下:
`DELIMITER $$
`CREATE PROCEDURE `c4mo_get_cities_prc`(IN `p_state_code` VARCHAR(3), IN
`p_country_code` VARCHAR(3), IN `p_language_code` VARCHAR(3))
NO SQL
BEGIN
SELECT city_name, city_code
FROM `c4mo_cities`
WHERE enabled = 'Y'
AND language_code = p_language_code
AND state_code = p_state_code
AND country_code = p_country_code;
END $$
DELIMITER ;
3、执行以上SQL就行了。