Procedure - Error code Mysql : #1064

Question

CREATE DEFINER=`root`@`localhost`

PROCEDURE `teste`(IN `pId` VARCHAR(20))NO SQL

INSERT INTO gpetnaold.pessoal SELECT * FROM gpetna.pessoal WHERE gpetna.pessoal.id=pId;

INSERT INTO gpetnaold.contato SELECT * FROM gpetna.contato WHERE gpetna.contato.pessoal_id=pId;

Can someone help me with this mistake.

If you put any of the query alone, it works great. when I put the two returns the error;

1064 error 'INSERT INTO gpetnaold.contact SELECT * FROM gpetna.contact WHERE gpetna.contacto. ' at line 2'

Answer 1

I believe the structure of your trial is wrong, try it this way:

DELIMITER $$
CREATE PROCEDURE nome_da_proc (<seus parametros>)
BEGIN
    /* seu conteudo */
END $$
DELIMITER ;