I have created a stored procedure which do some updates in database. Now when I am trying to add that stored procedure using magento install script from sql
folder, It is not being updated..
I cannot see stored procedure created in database.. I am using below syntax there
$write = Mage::getSingleton('core/resource')->getConnection('core_write');
$write->query(STORED_PROCEDURE_SYNTAX);