1
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'
Thank you! Works beautifully...
– Helder Pereira
If my solution meets your need, please mark it as an acceptable solution (green check) it improves my reputation ;)
– Jardel Novaes