对mysql存储过程的简单实现

--id为自增主键
create table `ufo`(
	id int primary key auto_increment,
	code varchar(50) not null,
	name varchar(50) not null,
	spec_id varchar(50) not null,
	create_date datetime not null,
	version varchar(50) not null
);


insert into `ufo` (code,name,spec_id,create_date,version)
values('39','53区','2018001',now(),'1');


--创建存储过程

delimiter//
create procedure procedures(in sid int,in sname varchar(50),out scode varchar(50),out sspec_id varchar(50),out sversion varchar(50))
begin
	select code, spec_id, version
	into @scode,@sspec_id,@sversion
	from `ufo`
	where id = sid;
	
	insert into `ufo` (code,name,spec_id,create_date,version)
	values(@scode,sname,@sspec_id,now(),@sversion);
end
//

--调用存储过程，插入一条数据，使除了name为'13'区、自增id和创建时间以外，其他的字段值都与id为1的字段值相同
call procedures(1,'13区',@scode1,@sspec_id1,@sversion1)

call procedures(2,'53区',@scode2,@sspec_id2,@sversion2)