Mês: maio 2014

Not Found

Apologies, but no results were found for the requested archive. Perhaps searching will help find a related post.

Criando e chamando procedure MySQL

Posted on 26 de maio de 2014 by Everton Gonçalves

Sintaxe da criação de uma procedure no MySQL DELIMITER $$ DROP PROCEDURE IF EXISTS `total_alunos` $$ CREATE PROCEDURE `total_alunos` () BEGIN SELECT COUNT(*) FROM alunos; END $$ DELIMITER ; Para chamar através do PHP ou Query basta executar o call total_alunos() Simples e prático 🙂

<span class="entry-utility-prep entry-utility-prep-cat-links">Posted in</span> MySQL | <span class="entry-utility-prep entry-utility-prep-tag-links">Tagged</span> , | Leave a comment