drop database if exists crashtest;
create database crashtest;
use crashtest;

CREATE TABLE `personen` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `vorname` varchar(50) default NULL,
  `nachname` varchar(50) default NULL,
  `text` text,
  PRIMARY KEY  (`id`)
) ENGINE=INNODB DEFAULT CHARSET=latin1;

CREATE TABLE `personen2` (
  `id` int(11),
  `vorname` varchar(50) default NULL,
  `nachname` varchar(50) default NULL,
  `text` text
) ENGINE=INNODB DEFAULT CHARSET=latin1;


insert into personen (vorname, nachname, text) 
values ('Marcel', 'Noe', 'Test');

delimiter //

CREATE PROCEDURE auswahl (param1 VARCHAR(50))
BEGIN

DECLARE tid INT;
DECLARE tvorname  VARCHAR(50);
DECLARE tnachname VARCHAR(50);

DELETE FROM personen2;

SELECT vorname, nachname, id
INTO   tvorname, tnachname, tid
FROM   personen
WHERE  nachname = param1;

INSERT INTO personen2 (id, vorname, nachname) VALUES (tid, tvorname, tnachname);

SELECT vorname, nachname, id FROM personen WHERE nachname = param1;
END; //

delimiter ;

call auswahl('Noe');