drop procedure mysql_MySQL 存储过程 drop procedure/function语句

最新推荐文章于 2022-05-11 19:12:03 发布
最新推荐文章于 2022-05-11 19:12:03 发布
阅读量147 收藏
点赞数
文章标签： drop procedure mysql
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/weixin_39873325/article/details/113216280
版权

mysql>use information_schema;

Reading table informationforcompletion of table and column names

You can turn offthis feature to get a quicker startup with -A

Database changed

mysql>show tables;+---------------------------------------+

| Tables_in_information_schema |

+---------------------------------------+

| CHARACTER_SETS |

| COLLATIONS |

| COLLATION_CHARACTER_SET_APPLICABILITY |

| COLUMNS |

| COLUMN_PRIVILEGES |

| COLUMN_STATISTICS |

| ENGINES |

| EVENTS |

| FILES |

| INNODB_BUFFER_PAGE |

| INNODB_BUFFER_PAGE_LRU |

| INNODB_BUFFER_POOL_STATS |

| INNODB_CACHED_INDEXES |

| INNODB_CMP |

| INNODB_CMPMEM |

| INNODB_CMPMEM_RESET |

| INNODB_CMP_PER_INDEX |

| INNODB_CMP_PER_INDEX_RESET |

| INNODB_CMP_RESET |

| INNODB_COLUMNS |

| INNODB_DATAFILES |

| INNODB_FIELDS |

| INNODB_FOREIGN |

| INNODB_FOREIGN_COLS |

| INNODB_FT_BEING_DELETED |

| INNODB_FT_CONFIG |

| INNODB_FT_DEFAULT_STOPWORD |

| INNODB_FT_DELETED |

| INNODB_FT_INDEX_CACHE |

| INNODB_FT_INDEX_TABLE |

| INNODB_INDEXES |

| INNODB_METRICS |

| INNODB_SESSION_TEMP_TABLESPACES |

| INNODB_TABLES |

| INNODB_TABLESPACES |

| INNODB_TABLESPACES_BRIEF |

| INNODB_TABLESTATS |

| INNODB_TEMP_TABLE_INFO |

| INNODB_TRX |

| INNODB_VIRTUAL |

| KEYWORDS |

| KEY_COLUMN_USAGE |

| OPTIMIZER_TRACE |

| PARAMETERS |

| PARTITIONS |

| PLUGINS |

| PROCESSLIST |

| PROFILING |

| REFERENTIAL_CONSTRAINTS |

| RESOURCE_GROUPS |

| ROUTINES |

| SCHEMATA |

| SCHEMA_PRIVILEGES |

| STATISTICS |

| ST_GEOMETRY_COLUMNS |

| ST_SPATIAL_REFERENCE_SYSTEMS |

| TABLES |

| TABLESPACES |

| TABLE_CONSTRAINTS |

| TABLE_PRIVILEGES |

| TRIGGERS |

| USER_PRIVILEGES |

| VIEWS |

| VIEW_ROUTINE_USAGE |

| VIEW_TABLE_USAGE |

+---------------------------------------+rowsin set (0.01sec)

mysql>desc routines;+--------------------------+---------------------------+------+-----+---------+-------+

| Field | Type | Null | Key | Default | Extra |

+--------------------------+---------------------------+------+-----+---------+-------+

| SPECIFIC_NAME | varchar(64) | NO | | NULL | |

| ROUTINE_CATALOG | varchar(64) | NO | | NULL | |

| ROUTINE_SCHEMA | varchar(64) | NO | | NULL | |

| ROUTINE_NAME | varchar(64) | NO | | NULL | |

| ROUTINE_TYPE | enum('FUNCTION','PROCEDURE') | NO | | NULL | |

| DATA_TYPE | longtext | YES | | NULL | |

| CHARACTER_MAXIMUM_LENGTH | bigint(21) | YES | | NULL | |

| CHARACTER_OCTET_LENGTH | bigint(21) | YES | | NULL | |

| NUMERIC_PRECISION | int(10) unsigned | YES | | NULL | |

| NUMERIC_SCALE | int(10) unsigned | YES | | NULL | |

| DATETIME_PRECISION | int(10) unsigned | YES | | NULL | |

| CHARACTER_SET_NAME | varchar(64) | YES | | NULL | |

| COLLATION_NAME | varchar(64) | YES | | NULL | |

| DTD_IDENTIFIER | longtext | YES | | NULL | |

| ROUTINE_BODY | varchar(3) | NO | | | |

| ROUTINE_DEFINITION | longtext | YES | | NULL | |

| EXTERNAL_NAME | binary(0) | YES | | NULL | |

| EXTERNAL_LANGUAGE | varchar(64) | NO | | SQL | |

| PARAMETER_STYLE | varchar(3) | NO | | | |

| IS_DETERMINISTIC | varchar(3) | NO | | | |

| SQL_DATA_ACCESS | enum('CONTAINS SQL','NO SQL','READS SQL DATA','MODIFIES SQL DATA') | NO | | NULL | |

| SQL_PATH | binary(0) | YES | | NULL | |

| SECURITY_TYPE | enum('DEFAULT','INVOKER','DEFINER') | NO | | NULL | |

| CREATED | timestamp | NO | | NULL | |

| LAST_ALTERED | timestamp | NO | | NULL | |

| SQL_MODE | set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','NOT_USED','ONLY_FULL_GROUP_BY',

'NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','NOT_USED_9','NOT_USED_10','NOT_USED_11','NOT_USED_12',

'NOT_USED_13','NOT_USED_14','NOT_USED_15','NOT_USED_16','NOT_USED_17','NOT_USED_18','ANSI','NO_AUTO_VALUE_ON_ZERO',

'NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_ALL_TABLES','NO_ZERO_IN_DATE','NO_ZERO_DATE','INVALID_DATES',

'ERROR_FOR_DIVISION_BY_ZERO','TRADITIONAL','NOT_USED_29','HIGH_NOT_PRECEDENCE','NO_ENGINE_SUBSTITUTION',

'PAD_CHAR_TO_FULL_LENGTH','TIME_TRUNCATE_FRACTIONAL') | NO | | NULL | |

| ROUTINE_COMMENT | text | NO | | NULL | |

| DEFINER | varchar(93) | NO | | NULL | |

| CHARACTER_SET_CLIENT | varchar(64) | NO | | NULL | |

| COLLATION_CONNECTION | varchar(64) | NO | | NULL | |

| DATABASE_COLLATION | varchar(64) | NO | | NULL | |

+--------------------------+------------------------+------+-----+---------+-------+rowsin set (0.01sec)

mysql> select * from routines limit 1;+-------------------------------+-----------------+----------------+-------------------------------+--------------+-----------+--------------------------+------------------------+-------------------+---------------+--------------------+--------------------+--------------------+----------------+--------------+--------------------------------------------------------------------------------------------------------+---------------+-------------------+-----------------+------------------+-----------------+----------+---------------+---------------------+---------------------+---------+---------------+---------------------+----------------------+----------------------+--------------------+

| SPECIFIC_NAME | ROUTINE_CATALOG | ROUTINE_SCHEMA | ROUTINE_NAME | ROUTINE_TYPE | DATA_TYPE | CHARACTER_MAXIMUM_LENGTH | CHARACTER_OCTET_LENGTH | NUMERIC_PRECISION | NUMERIC_SCALE | DATETIME_PRECISION | CHARACTER_SET_NAME | COLLATION_NAME | DTD_IDENTIFIER | ROUTINE_BODY | ROUTINE_DEFINITION | EXTERNAL_NAME | EXTERNAL_LANGUAGE | PARAMETER_STYLE | IS_DETERMINISTIC | SQL_DATA_ACCESS | SQL_PATH | SECURITY_TYPE | CREATED | LAST_ALTERED | SQL_MODE| ROUTINE_COMMENT | DEFINER | CHARACTER_SET_CLIENT | COLLATION_CONNECTION | DATABASE_COLLATION |

+-------------------------------+-----------------+----------------+-------------------------------+--------------+-----------+--------------------------+------------------------+-------------------+---------------+--------------------+--------------------+--------------------+----------------+--------------+--------------------------------------------------------------------------------------------------------+---------------+-------------------+-----------------+------------------+-----------------+----------+---------------+---------------------+---------------------+-----------------------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------+---------------------+----------------------+----------------------+--------------------+

| extract_schema_from_file_name | def | sys | extract_schema_from_file_name | FUNCTION | varchar | 64 | 256 | NULL | NULL | NULL | utf8mb4 | utf8mb4_0900_ai_ci | varchar(64) | SQL | BEGIN RETURN LEFT(SUBSTRING_INDEX(SUBSTRING_INDEX(REPLACE(path, '\','/'),'/', -2),'/', 1), 64); END | NULL | SQL | SQL | YES | NO SQL | NULL | INVOKER | 2020-04-06 19:21:37 | 2020-04-06 19:21:37 | ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION |

Description

Takes a raw file path, and attempts to extract the schema namefromit.

Usefulforwhen interacting with Performance Schema data

concerning IO statistics,forexample.

Currently relies on the fact that a table data file will be within a

specified database directory (will not work with partitions or tables

that specify an individual DATA_DIRECTORY).

Parameters

path (VARCHAR(512)):

The full file path to a data file to extract the schema namefrom.

Returns

VARCHAR(64)

Example

mysql> SELECT sys.extract_schema_from_file_name('/var/lib/mysql/employees/employee.ibd');+----------------------------------------------------------------------------+

| sys.extract_schema_from_file_name('/var/lib/mysql/employees/employee.ibd') |

+----------------------------------------------------------------------------+

| employees |

+----------------------------------------------------------------------------+rowin set (0.00sec)| mysql.sys@localhost | utf8mb4 | utf8mb4_0900_ai_ci | utf8mb4_0900_ai_ci |

+-------------------------------+-----------------+----------------+-------------------------------+--------------+-----------+--------------------------+------------------------+-------------------+---------------+--------------------+--------------------+--------------------+----------------+--------------+--------------------------------------------------------------------------------------------------------+---------------+-------------------+-----------------+------------------+-----------------+----------+---------------+---------------------+---------------------+-------+---------------------+----------------------+----------------------+--------------------+rowin set (0.01sec)

mysql> select * from routines where routine_name='simpleproc';+---------------+-----------------+----------------+--------------+--------------+-----------+--------------------------+------------------------+-------------------+---------------+--------------------+--------------------+----------------+----------------+--------------+-----------------------------------------------------------------------+---------------+-------------------+-----------------+------------------+-----------------+----------+---------------+---------------------+---------------------+-----------------------------------------------------------------------------------------------------------------------+-----------------+----------------+----------------------+----------------------+--------------------+

| SPECIFIC_NAME | ROUTINE_CATALOG | ROUTINE_SCHEMA | ROUTINE_NAME | ROUTINE_TYPE | DATA_TYPE | CHARACTER_MAXIMUM_LENGTH | CHARACTER_OCTET_LENGTH | NUMERIC_PRECISION | NUMERIC_SCALE | DATETIME_PRECISION | CHARACTER_SET_NAME | COLLATION_NAME | DTD_IDENTIFIER | ROUTINE_BODY | ROUTINE_DEFINITION | EXTERNAL_NAME | EXTERNAL_LANGUAGE | PARAMETER_STYLE | IS_DETERMINISTIC | SQL_DATA_ACCESS | SQL_PATH | SECURITY_TYPE | CREATED | LAST_ALTERED | SQL_MODE | ROUTINE_COMMENT | DEFINER | CHARACTER_SET_CLIENT | COLLATION_CONNECTION | DATABASE_COLLATION |

+---------------+-----------------+----------------+--------------+--------------+-----------+--------------------------+------------------------+-------------------+---------------+--------------------+--------------------+----------------+----------------+--------------+-----------------------------------------------------------------------+---------------+-------------------+-----------------+------------------+-----------------+----------+---------------+---------------------+---------------------+-----------------------------------------------------------------------------------------------------------------------+-----------------+----------------+----------------------+----------------------+--------------------+

| simpleproc | def | course | simpleproc | PROCEDURE | | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | SQL |BEGINselect count(*) into param2 from students where sid>param1;

END| NULL | SQL | SQL | NO | CONTAINS SQL | NULL | DEFINER | 2020-04-19 17:17:12 | 2020-04-19 17:17:12 | ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION | | root@localhost | utf8mb4 | utf8mb4_0900_ai_ci | utf8mb4_0900_ai_ci |

+---------------+-----------------+----------------+--------------+--------------+-----------+--------------------------+------------------------+-------------------+---------------+--------------------+--------------------+----------------+----------------+--------------+-----------------------------------------------------------------------+---------------+-------------------+-----------------+------------------+-----------------+----------+---------------+---------------------+---------------------+-----------------------------------------------------------------------------------------------------------------------+-----------------+----------------+----------------------+----------------------+--------------------+rowin set (0.04sec)

mysql> select * from routines where routine_name='simpleproc' and routine_schema='course';+---------------+-----------------+----------------+--------------+--------------+-----------+--------------------------+------------------------+-------------------+---------------+--------------------+--------------------+----------------+----------------+--------------+-----------------------------------------------------------------------+---------------+-------------------+-----------------+------------------+-----------------+----------+---------------+---------------------+---------------------+-----------------------------------------------------------------------------------------------------------------------+-----------------+----------------+----------------------+----------------------+--------------------+

| SPECIFIC_NAME | ROUTINE_CATALOG | ROUTINE_SCHEMA | ROUTINE_NAME | ROUTINE_TYPE | DATA_TYPE | CHARACTER_MAXIMUM_LENGTH | CHARACTER_OCTET_LENGTH | NUMERIC_PRECISION | NUMERIC_SCALE | DATETIME_PRECISION | CHARACTER_SET_NAME | COLLATION_NAME | DTD_IDENTIFIER | ROUTINE_BODY | ROUTINE_DEFINITION | EXTERNAL_NAME | EXTERNAL_LANGUAGE | PARAMETER_STYLE | IS_DETERMINISTIC | SQL_DATA_ACCESS | SQL_PATH | SECURITY_TYPE | CREATED | LAST_ALTERED | SQL_MODE | ROUTINE_COMMENT | DEFINER | CHARACTER_SET_CLIENT | COLLATION_CONNECTION | DATABASE_COLLATION |

+---------------+-----------------+----------------+--------------+--------------+-----------+--------------------------+------------------------+-------------------+---------------+--------------------+--------------------+----------------+----------------+--------------+-----------------------------------------------------------------------+---------------+-------------------+-----------------+------------------+-----------------+----------+---------------+---------------------+---------------------+-----------------------------------------------------------------------------------------------------------------------+-----------------+----------------+----------------------+----------------------+--------------------+

| simpleproc | def | course | simpleproc | PROCEDURE | | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | SQL |BEGINselect count(*) into param2 from students where sid>param1;

END| NULL | SQL | SQL | NO | CONTAINS SQL | NULL | DEFINER | 2020-04-19 17:17:12 | 2020-04-19 17:17:12 | ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION | | root@localhost | utf8mb4 | utf8mb4_0900_ai_ci | utf8mb4_0900_ai_ci |

+---------------+-----------------+----------------+--------------+--------------+-----------+--------------------------+------------------------+-------------------+---------------+--------------------+--------------------+----------------+----------------+--------------+-----------------------------------------------------------------------+---------------+-------------------+-----------------+------------------+-----------------+----------+---------------+---------------------+---------------------+-----------------------------------------------------------------------------------------------------------------------+-----------------+----------------+----------------------+----------------------+--------------------+rowin set (0.00sec)

mysql> select * from routines where routine_schema='course';+---------------+-----------------+----------------+--------------+--------------+-----------+--------------------------+------------------------+-------------------+---------------+--------------------+--------------------+--------------------+----------------+--------------+-------------------------------------------------------------------------------------------------+---------------+-------------------+-----------------+------------------+-----------------+----------+---------------+---------------------+---------------------+-----------------------------------------------------------------------------------------------------------------------+-----------------+----------------+----------------------+----------------------+--------------------+

| SPECIFIC_NAME | ROUTINE_CATALOG | ROUTINE_SCHEMA | ROUTINE_NAME | ROUTINE_TYPE | DATA_TYPE | CHARACTER_MAXIMUM_LENGTH | CHARACTER_OCTET_LENGTH | NUMERIC_PRECISION | NUMERIC_SCALE | DATETIME_PRECISION | CHARACTER_SET_NAME | COLLATION_NAME | DTD_IDENTIFIER | ROUTINE_BODY | ROUTINE_DEFINITION | EXTERNAL_NAME | EXTERNAL_LANGUAGE | PARAMETER_STYLE | IS_DETERMINISTIC | SQL_DATA_ACCESS | SQL_PATH | SECURITY_TYPE | CREATED | LAST_ALTERED | SQL_MODE | ROUTINE_COMMENT | DEFINER | CHARACTER_SET_CLIENT | COLLATION_CONNECTION | DATABASE_COLLATION |

+---------------+-----------------+----------------+--------------+--------------+-----------+--------------------------+------------------------+-------------------+---------------+--------------------+--------------------+--------------------+----------------+--------------+-------------------------------------------------------------------------------------------------+---------------+-------------------+-----------------+------------------+-----------------+----------+---------------+---------------------+---------------------+-----------------------------------------------------------------------------------------------------------------------+-----------------+----------------+----------------------+----------------------+--------------------+

| hello | def | course | hello | FUNCTION | char | 50 | 200 | NULL | NULL | NULL | utf8mb4 | utf8mb4_0900_ai_ci | char(50) | SQL | return concat('Hello,',s,'!') | NULL | SQL | SQL | NO | CONTAINS SQL | NULL | DEFINER | 2020-04-19 17:42:21 | 2020-04-19 17:42:21 | ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION | | root@localhost | utf8mb4 | utf8mb4_0900_ai_ci | utf8mb4_0900_ai_ci |

| simpleproc | def | course | simpleproc | PROCEDURE | | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | SQL |BEGINselect count(*) into param2 from students where sid>param1;

END| NULL | SQL | SQL | NO | CONTAINS SQL | NULL | DEFINER | 2020-04-19 17:17:12 | 2020-04-19 17:17:12 | ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION | | root@localhost | utf8mb4 | utf8mb4_0900_ai_ci | utf8mb4_0900_ai_ci |

| simpleproc2 | def | course | simpleproc2 | PROCEDURE | | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | SQL |beginselect count(*) from students where sid>1;select count(*) from students where sid>2;

end| NULL | SQL | SQL | NO | CONTAINS SQL | NULL | DEFINER | 2020-04-19 17:56:18 | 2020-04-19 17:56:18 | ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION | | root@localhost | utf8mb4 | utf8mb4_0900_ai_ci | utf8mb4_0900_ai_ci |

+---------------+-----------------+----------------+--------------+--------------+-----------+--------------------------+------------------------+-------------------+---------------+--------------------+--------------------+--------------------+----------------+--------------+-------------------------------------------------------------------------------------------------+---------------+-------------------+-----------------+------------------+-----------------+----------+---------------+---------------------+---------------------+-----------------------------------------------------------------------------------------------------------------------+-----------------+----------------+----------------------+----------------------+--------------------+rowsin set (0.00sec)

mysql> select routine_name from routines where routine_schema='course';+--------------+

| ROUTINE_NAME |

+--------------+

| hello |

| simpleproc |

| simpleproc2 |

+--------------+rowsin set (0.00sec)

mysql> select routine_name,routine_type from routines where routine_schema='course';+--------------+--------------+

| ROUTINE_NAME | ROUTINE_TYPE |

+--------------+--------------+

| hello | FUNCTION |

| simpleproc | PROCEDURE |

| simpleproc2 | PROCEDURE |

+--------------+--------------+rowsin set (0.01sec)

mysql>use course;

Reading table informationforcompletion of table and column names

You can turn offthis feature to get a quicker startup with -A

Database changed

mysql> select routine_name,routine_type from information_schema.routines where routine_schema='course';+--------------+--------------+

| ROUTINE_NAME | ROUTINE_TYPE |

+--------------+--------------+

| hello | FUNCTION |

| simpleproc | PROCEDURE |

| simpleproc2 | PROCEDURE |

+--------------+--------------+rowsin set (0.01 sec)

weixin_39873325
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
MySQL删除存储过程（DROP PROCEDURE）
unber的博客
09-24 4017
当 MySQL 数据库中存在废弃的存储过程是，我们需要将它从数据库中删除。
MySQL删除存储过程（DROP PROCEDURE）和MySQL存储函数详解
最新发布
m0_37449634的博客
01-14 1419
存储过程被创建后，就会一直保存在数据库服务器上，直至被删除。当数据库中存在废弃的存储过程时，我们需要将它从数据库中删除。MySQL 中使用 DROP PROCEDURE 语句来删除数据库中已经存在的存储过程。注意：存储过程名称后面没有参数列表，也没有括号，在删除之前，必须确认该存储过程没有任何依赖关系，否则会导致其他与之关联的存储过程无法运行。
【MySQL】存储过程
Superman_H的博客
06-19 655
存储过程 一组预先编译好的 SQL 语句的集合，可以理解成批处理语句。作用： 提高代码的重用性 简化操作 减少编译次数、减少了和数据库服务器的连接次数，提高效率 创建 create procedure 存储过程名(参数列表) begin 存储过程体(一组合法的 SQL 语句) end 参数列表：参数模式 参数名 参数类型 参数模式： in：该参数需要输入（默认） out：该参数可以输出 inout ：既需要传入值，又可以输出 如果存储过程体中只有一条 SQL 语句，begin end
mysql 修改、删除存储过程
stone_tomcate的博客
12-27 575
demo 创建存储 过程函数 -- ---------------------------- -- Procedure structure for `getDeptChild` -- ---------------------------- DROP PROCEDURE IF EXISTS `getDeptChild`; DELIMITER ;; CREATE DEFINER=`sunxi...
mysql存储过程删除_MySQL存储过程的删除操作和使用参数的示例详解
weixin_36118049的博客
01-18 745
删除存储过程存储过程在创建之后，被保存在服务器上以供使用，直至被删除。删除命令(类似于第21章所介绍的语句)从服务器中删除存储过程。为删除刚创建的存储过程，可使用以下语句：输入：drop procedure productpricing;分析：这条语句删除刚创建的存储过程。请注意没有使用后面的 () ，只给出存储过程名。仅当存在时删除 如果指定的过程不存在，则 DROP PROCEDURE将产生一...
MySQL 5.0触发器参考教程第1/4页
01-19
在这里举个例子： mysql> DROP FUNCTION f; Query OK, 0 rows affected (0.00 sec) 如果实例比较大，则需要在某些行和段落间加注释，同时我会用将”<–“符号放在页面的右边以表示强调。例如： mysql> CREATE ...
mysql数据库的基本操作语法
12-05
Ø 常用查询 MySQL结束符是“；”结束。 1、 显示所有数据库 show databases; 2、 删除数据库 ...Ø select 查询、function 函数 select查询语句用得最广泛、功能也最丰富。可以完成单条记录、多条记录、单表...
MYSQL中文手册
03-11
言 1. 一般信息 1.1. 关于本手册 1.2. 本手册采用的惯例 1.3. MySQL AB概述 1.4. MySQL数据库管理系统概述 ...13.4. MySQL事务处理和锁定语句 13.4.1. START TRANSACTION, COMMIT和ROLLBACK语法...
MySQL 5.1官方简体中文参考手册
07-02
11.5. 列类型存储需求 11.6. 选择正确的列类型 11.7. 使用来自其他数据库引擎的列类型 12. 函数和操作符 12.1. 操作符 12.1.1. 操作符优先级 12.1.2. 圆括号 12.1.3. 比较函数和操作符 12.1.4. 逻辑操作符 12.2. ...
MySQL5.1参考手册官方简体中文版
05-10
MySQL 5.1参考手册 这是MySQL参考手册的翻译版本，关于MySQL参考手册，请访问dev.mysql.com。 原始参考手册为英文版，与英文版参考手册相比，本翻译版可能不是最新的。 This translation was done by MySQL ...
MySQL之存储过程
Jan's的博客
05-11 1万+
我的小站：我的博客 1.1 存储过程简介 存储过程是一组为了完成特定功能的SQL语句集合，经编译后存储在数据库中。用户通过指定存储过程的名字并给出参数的值 MySQL 5.0 版本开始支持存储过程。 存储过程（Stored Procedure）是一种在数据库中存储复杂程序，以便外部程序调用的一种数据库对象。 存储过程是为了完成特定功能的SQL语句集，经编译创建并保存在数据库中，用户可通过指定存储过程的名字并给定参数(需要时)来调用执行。 存储过程思想上很简单，就是数据库 SQL 语言层面的代码封
MySQL常用操作
小亮子的博客
04-23 282
MySQL常用操作 ​ 设置环境变量: ​ 语法：export [-fnp][变量名称]=[变量设置值] ​ export PATH=/usr/local/mysql/bin/mysql:$PATH ​ mysql -u root -p123456 // 登录mysql : ​ use test // 这是选中数据库的操作，确定当前数据库是test ​...
drop procedure mysql_mysql 存储过程 procedure
weixin_42398635的博客
02-01 620
我们大家都知道MySQL存储过程是从 MySQL 5.0 开始逐渐增加新的功能。存储过程在实际应用中也是优点大于缺点。不过最主要的还是执行效率和SQL 代码封装。特别是 SQL 代码封装功能，如果没有存储过程。在外部程序访问数据库时(例如 PHP)，要组织很多 SQL 语句。特别是业务逻辑复杂的时候，一大堆的 SQL 和条件夹杂在 PHP 代码中，让人不寒而栗。现在有了 MySQL 存储过程，业务...
mysql drop procedure_MySQL删除存储过程（DROP PROCEDURE）
weixin_39937312的博客
01-21 441
当 MySQL 数据库中存在废弃的存储过程是，我们需要将它从数据库中删除。基本语法存储过程被创建后，保存在数据库服务器上，直至被删除。可以使用 DROP PROCEDURE 语句删除数据库中已创建的存储过程。语法格式如下：DROP { PROCEDURE | FUNCTION } [ IF EXISTS ] 语法说明如下：1) 过程名指定要删除的存储过程的名称。2) IF EXISTS指定这个关键...
MySQL删除存储过程和函数
热门推荐
aihali的专栏
06-24 2万+
MySQL中使用DROP PROCEDURE语句来删除存储过程；使用DROP FUNCTION语句来删除存储函数。 基本的语法格式如下： DROP {PROCEDURE|FUNCTION} sp_name; 其中，sp_name参数表示存储过程或函数的名称。 1. 删除存储过程test。SQL代码如下： drop procedure if exists test;
MySQL删除存储过程
天高任鸟飞
07-28 2万+
当数据库存储废弃的存储过程时，需要删除 MySQL中，使用DROP语句删除存储过程语法格式 DROP {PROCEDURE | FUNCTION} [IF EXISTS] sp_name参数说明Sp_name，为删除的存储过程名称 IF EXISTS，表示如果程序不存在，可以避免发生错误，产生一个警告，该警告可以使用SHOW WARNINGS进行查询删除存储过程CountProc1
python 提取固定列名数据_python获取数据库列名
weixin_39806288的博客
12-01 6069
{"moduleinfo":{"card_count":[{"count_phone":1,"count":1}],"search_count":[{"count_phone":4,"count":4}]},"card":[{"des":"阿里云数据库专家保驾护航，为用户的数据库应用系统进行性能和风险评估，参与配合进行数据压测演练，提供数据库优化方面专业建议，在业务高峰期与用户共同保障数据库系统平...
MySQL -＞ 存储过程,创建(create procedure),调用(call),查询(select),删除(drop procedure),查看信息(show)
rod0320的博客
11-09 1955
创建存储过程: create procedure 存储名字(参数列表) begin 存储过程体; end 参数列表:in,out,inout in 字段名 字段类型 # in:输出的,需要外边传值,默认是in out 字段名 字段类型 # out:输出的,可以返回值 inout 字段名 字段类型 # inout:即可以输出又可以输入 delimiter 分隔符 # 存储过程结尾加delimiter重新设置 调用存储: call 存贮名字(实参列表); 例子:in 创建 # 设置分隔符 d
mysql DROP PROCEDURE IF EXISTS schema_change;$$ CREATE PROCEDURE schema_change() BEGIN 内容 END;$$ CALL schema_change();$$ DROP PROCEDURE IF EXISTS schema_change;$$修改成kingbase语句
06-09
在Kingbase中，存储过程的创建和调用方式与MySQL略有不同，以下是将MySQL中的存储过程转换为Kingbase的代码： ``` -- 创建存储过程 CREATE OR REPLACE FUNCTION schema_change() RETURNS VOID AS $$ BEGIN -- 内容...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值