Prepared SQL Statement Syntax

Http://dev.mysql.com/doc/refman/5.7/en/sql-syntax-prepared-statements.html

1 CREATE TABLET1 (AINT  not NULL);2 INSERT  intoT1VALUES(4), (8), ( One), ( +), ( the);3 SET @table = 'T1';4 SET @s =CONCAT ('SELECT * from',@table);5 PREPAREStmt3 from @s;6 EXECUTESTMT3;

1 SET @s = 'SELECT SQRT (Pow (?, 2) + POW (?, 2)) as Hypotenuse';2 PREPAREStmt2 from @s;3 SET @a = 6;4 SET @b = 8;5 EXECUTEStmt2 USING@a,@b;

1 PREPAREStmt1 from 'SELECT SQRT (Pow (?, 2) + POW (?, 2)) as Hypotenuse';2 SET @a = 3;3 SET @b = 4;4 EXECUTESTMT1 USING@a,@b;5SHOW VARIABLES like '%a%';

Prepared SQL Statement Syntax