PHPMyadmin导出和导入存储过程的方法

k7Cx7e

于 2022-06-25 12:32:59 发布

阅读量320

点赞数

分类专栏： mysql 文章标签：大数据

本文链接：https://blog.csdn.net/gdali/article/details/125457918

版权

mysql 专栏收录该内容

15 篇文章 0 订阅

订阅专栏

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就行了。