Procedury v MYSQL

Zdravim vytvoril sem si proceduru

//PRO PMA + nastavit jiny oddelovac nez ;



CREATE PROCEDURE test()

BEGIN

SET @id=1;

SET @query = CONCAT('SELECT * FROM hraci WHERE id = ', @id);

INSERT INTO hraci SET jmeno = 'lojza';

PREPARE valec FROM @query;

EXECUTE valec;

DEALLOCATE PREPARE valec;

END 

Cvhili mi trvalo nez sem prisel na to jak ji v PhpMyAdmin (PMA) ulozit .
Nyni bych ji rad vyvolal

cili Call test();
ale PMA mi vyhazuje toto #1312 - PROCEDURE test.test can't return a result set in the given context

Pres cmd se nato dostanu , ale cmd je az na druhe koleji ..