Examples for business, study, careers, love, and more...
Examples :: MYSQL Examples :: Example of Call Mysql Statement

Example of Call Mysql Statement:

SET @increment = 10;
CALL p(@version, @increment);
SELECT @version, @increment;

SET @increment = 10;
PREPARE s FROM 'CALL p(@version, @increment)';
EXECUTE s;
SELECT @version, @increment;

Example of Mysql Call


CALL sp_name([parameter[,...]])
CALL sp_name[()]