--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)
