文章目录
1 概述2 语法1 概述
2 语法
prepare 预准备语句名 from '预准备语句';-- set @a=1, @n=2; 仅支持 set 变量赋值execute 预准备语句名 [using @a, @n];[deallocate | drop] prepare 预准备语句名;-- 常用预准备语句如下-- create table、create or replace view-- select、insert、update、delete-- where column = @n
示例代码1:
prepare prepare_sql from 'select ?+?';set @a=1, @b=2;execute prepare_sql using @a, @b;deallocate prepare prepare_sql;
示例代码2:
prepare prepare_sql from 'create table test_prepare(sno int, name varchar(100))';execute prepare_sql;deallocate prepare prepare_sql;
如果觉得《Mysql 预准备语句详解(prepare execute deallocate)》对你有帮助,请点赞、收藏,并留下你的观点哦!