存储过程HelloWorld_写个helloword的存储过程和函数-优快云博客

本文演示了如何创建数据库和表、插入数据、定义存储过程等基本SQL操作，并展示了如何在存储过程中使用SQL语言特性。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

create database db5;  

use db5;  

----------------------------------------------------

drop table if exists t;

create table t (s1 int);  
  
insert into t values (5);  

select * from t;

----------------------------------------------------

drop procedure if exists p1;

delimiter //
 
create procedure p1 () select * from t; //  

delimiter ;

call p1();

/*
+------+
| s1   |
+------+
|    5 |
+------+
*/

----------------------------------------------------
drop procedure if exists p2;

delimiter //

create procedure p2 ()  
language sql                                        
not deterministic  
sql security definer  
comment 'a procedure'  
select current_date, rand() from t //  

delimiter ;

call p2();

/*
+--------------+--------------------+
| current_date | rand()             |
+--------------+--------------------+
| 2012-08-20   | 0.6757132678066504 |
+--------------+--------------------+
*/


drop procedure if exists o;


delimiter //


create procedure o()
select'Hello,world!'//  


delimiter ;


call o();

/*

+--------------+
| Hello,world! |
+--------------+
| Hello,world! |
+--------------+

*/