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;