Execute procedure
Posted by:
Vanessa Tan ()
Date: November 04, 2009 02:57AM
Hi, I am a student and was given a task to provide the lines of PHP code used to execute a procedure in a MySQL database.
I am very very weak in PHP, to be honest, I don't know what does the codes mean. Need help from anyone here, please!!
The codes given are as below:
DROP PROCEDURE IF EXISTS `a1`.`sp_archive`$$
CREATE PROCEDURE `a1`.`sp_archive` ()
BEGIN
DELETE FROM users WHERE last_login < DATE_ADD(sysdate(), INTERVAL -1 YEAR);
END$$
Thanks!!
Sorry, only registered users may post in this forum.
© 1995-2008 MySQL AB, 2008- Sun Microsystems, Inc.