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