用MySQL实现SQL Server的sp_executesql

　　mysql> EXECUTE stmt1 USING @a, @b;

　　+------------+

　　| hypotenuse |

　　+------------+

　　| 5 |

　　+------------+

　　mysql> DEALLOCATE PREPARE stmt1;

　　mysql> SET @s = 'SELECT SQRT(POW(?,2) + POW(?,2)) AS hypotenuse';

　　mysql> PREPARE stmt2 FROM @s;

　　mysql> SET @a = 6;

　　mysql> SET @b = 8;

　　mysql> EXECUTE stmt2 USING @a, @b;

文章来源于领测软件测试网 https://www.ltesting.net/