title: MySQL error in a procedure #1351 - View's SELECT contains a variable or parameter
body: <p>PhpMyAdmin doesn't accept the parameters "id_jugador_IN" inside the procedure. </p>
  
  <p>This is the procedure we're executing:</p>
  
  <pre><code>SET GLOBAL event_scheduler = 1;
  
  use traviandatabase;
  
  DELIMITER $$
  
  DROP PROCEDURE IF EXISTS sp_monitoritzacio_jugador $$
  
  CREATE PROCEDURE sp_monitoritzacio_jugador(IN id_jugador_IN INT(10))
  
  BEGIN
  
      CREATE OR REPLACE 
      VIEW dades_ususari AS 
      SELECT j.nom AS jugador, j.sexe AS sexe, j.edat AS edat, j.correu AS correu, a.nom AS alianca, p.nom AS pais, c.nom_ciutat AS ciutat
      FROM jugador AS j
      JOIN alianca AS a
      JOIN pais AS p
      JOIN ciutat AS c
      ON j.id_jugador = id_jugador_IN
      GROUP BY id_jugador_IN;
  
  END $$
  
  DELIMITER ;
  
  CALL sp_monitoritzacio_jugador(1);
  </code></pre>
  
  <p>And this is the table "jugador":</p>
  
  <pre><code>DROP TABLE IF EXISTS `jugador`;
  CREATE TABLE `jugador` (
    `id_jugador` int(10) NOT NULL AUTO_INCREMENT,
    `id_raca` int(10) NOT NULL,
    `id_pais` int(10) NOT NULL,
    `id_alianca` int(10) DEFAULT '0',
    `nom` varchar(20) NOT NULL,
    `sexe` enum('Home','Dona') NOT NULL,
    `edat` int(10) NOT NULL,
    `correu` varchar(20) NOT NULL,
    PRIMARY KEY (`id_jugador`),
    KEY `jugador-alianca` (`id_alianca`),
    KEY `id_pais` (`id_pais`),
    KEY `id_raca` (`id_raca`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  </code></pre>
  
  <p>So it doesn't stop displaying the same error:</p>
  
  <p>MySQL said: 1351 - View's SELECT contains a variable or parameter </p>