problem with procedure
Posted: Sun Jan 20, 2008 8:30 am
Hello all
I have problem with a procedure. I want to use an if statement with stored procedure
Here is procedure:
Now what i want to do is, place an if statement which will check if the expiry date of product is greater then the current date.
if the date is greater then i will change the status of that product.
any help
thank you
I have problem with a procedure. I want to use an if statement with stored procedure
Here is procedure:
Code: Select all
CREATE DEFINER = 'root'@'localhost' PROCEDURE `mytmp`()
NOT DETERMINISTIC
CONTAINS SQL
SQL SECURITY DEFINER
COMMENT ''
BEGIN
select
*
from
product
where
product.product_status = 0;
END;
if the date is greater then i will change the status of that product.
any help
thank you