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

Example of Execute Mysql Statement:

PREPARE stmt1 FROM 'SELECT SQRT(POW(?,2) + POW(?,2)) AS hypotenuse';
SET @a = 3;
SET @b = 4;
EXECUTE stmt1 USING @a, @b;

PREPARE stmt3 FROM @s;
EXECUTE stmt3;

Example of Mysql Execute


EXECUTE stmt_name
[USING @var_name [, @var_name] ...]