Mysql数据库学习

mysql prepare的用法：

PREPARE statement_name FROM sql_text /*定义*/
EXECUTE statement_name [USING variable [,variable...]] /*执行预处理语句*/
DEALLOCATE PREPARE statement_name /*删除定义*/

Demo:

PREPARE pre_stmt  FROM "insert into user values(?,?)" /*定义*/ 

set @user='huang'

set @passworld='123'
EXECUTE pre_stmt  USING @user ,@password/*执行预处理语句*/
DEALLOCATE PREPARE pre_stmt /*删除定义*/