Hi ,

I want to execute shell script through stored procedure if condition matches

DELIMITER $$
CREATE PROCEDURE CheckStatus()
BEGIN
DECLARE state INT DEFAULT 0;
select count(*) into state from test_done where status=0 or status='';
IF state > 0
THEN

sh /usr/bin/testshell.sh

ELSE

exit from mysql prompt

END IF;
END $$
DELIMITER ;

Probably better to create a function in MySQL to just return the status. Then get the shell script to call the MySQL function before doing anything else. If the function returns false then quit the script else continue with whatever the script normally does. If you need to run this regularly then call the script from cron.

Mike