drop database if exists temp;
create database temp;

use temp;

drop table if exists ttemp;
create table ttemp 
(
 id int not null auto_increment, 
 name varchar (40) not null default '',
 primary key (id)
);

drop procedure if exists tttemp;
delimiter //
create procedure tttemp (in sName varchar (40))
begin
 insert into ttemp (name) values (sName);
end ;
//

delimiter ;

call tttemp ('bds');

select * from ttemp;