1、数据库准备阶段
// 创建数据库
create database abc;
use abc;
// 创建表
drop table if exists user;
create table `user`(
`id` int auto_increment,
`username` varchar(50),
`sex` int,
primary key (`id`)
)engine=InnoDB default charset=utf8;
// 插入数据
insert into user(id,username,sex) values(1,'tom',1);
2、存储过程部分
// 创建存储过程
drop procedure if exists in_param;
delimiter $$
create procedure in_param(in p_in char(20))
begin
declare table_name varchar(20) default '';
set table_name = p_in;
set @statements = concat('select * from ',table_name);
prepare stmt from @statements;
execute stmt;
deallocate prepare stmt;
end$$
delimiter ;
// 调用存储过程
call in_param('user');
// 查看存储过程
show procedure status where db='abc';
// 删除存储过程
drop procedure in_param;
// 删除数据库
drop database abc;
