EXECUTE

语法

EXECUTE statement_name [ USING parameter1 [ , parameter2, ... ] ]

描述

执行预编译的SQL语句（prepared statement），并可以使用USING来指定输入参数。

示例

• 执行一个不带输入参数的预编译语句

  PREPARE my_select1 FROM SELECT name FROM fruit;
  EXECUTE my_select1;

• 执行一个带有两个输入参数的SQL语句

  PREPARE my_select2 FROM SELECT name FROM  fruit WHERE name= ? and price< ?;
  EXECUTE my_select2 USING  'peach',10;
  This is equivalent to:
  SELECT name FROM fruit WHERE name = 'peach' AND price<10;