上一篇文章的存储过程没有对SQL语句进行一个封装
本文在存储过程中操作其他表
目标:掌握存储过程的应用
测试数据及需求描述
drop table if exists user_info;
drop table if exists email_info;
create table user_info(
id int not null auto_increment primary key,
name varchar(30),
email varchar(50)
);
insert into user_info(id,name,email) values(1,'张三','zhangsan@qq.com');
insert into user_info(id,name,email) values(2,'墨菲','mofei@qq.com');
create table email_info(
id int not null auto_increment primary key,
email varchar(50),
content text,
send_time datetime
);
mysql> select * from user_info;
+----+------+-----------------+
| id | name | email |
+----+------+-----------------+
| 1 | 张三 | zhangsan@qq.com |
| 2 | 墨菲 | mofei@qq.com |
+