Posts Tagged StoredProcedure

Deal with Stored Procedures using phpMyAdmin

March 2, 2012
Deal with Stored Procedures using phpMyAdmin

phpMyAdmin MySQL web interface doesn’t contain any editor to manipulate or create stored procedure like all other IDEs. But you can create/modify the Stored Procedure using the queries. Example query for creating Stored Procedure ‘SP_INS_MEMBER’ is: DELIMITER $$   DROP PROCEDURE IF EXISTS `DB_NAME`.`SP_INS_MEMBER`$$   CREATE DEFINER=`root`@`localhost` PROCEDURE `SP_INS_MEMBER`(IN subProcessId VARCHAR(100), IN storeId VARCHAR(100), IN [...]

 

If you have a Tip, Comment, Article or anything you want to share, please send it to: i@poisure.com