Adminer stored procedure with IN paramters and internal vars

DECLARE @new_project_id int;
DECLARE @current_snapshot_id int;
DECLARE @new_snapshot_id int;

insert into project select * from project where project_id=@in_project_id
SET @new_project_id = last_insert_id()
for each row in (select * from snapshot where project_id=@in_project_id)
  insert into snapshot values(
       @new_project_id, 
       last_update	 
       snapshot_date 
       snapshot_title	 
       snapshot_note
)
 SET @new_snapshot_id = last_insert_id()
  insert into layer select new_snapshot_id, * from layer where snapshot_id =row.snapshot_id
loop

Select allOpen in new window