drop database if exists db1; create database db1; use db1; create table foo (a int, b text); insert into foo values(1,'sakura'); select * from foo; -- prepare ins_sql prepare ins_sql from 'insert into foo values(?,?)'; -- prepare upd_sql prepare upd_sql from 'update foo set b=? where a=?'; -- execute ins_sql set @a=2 ; set @b='ajisai'; execute ins_sql using @a, @b; select * from foo; -- execute upd_sql set @c='AJISAI'; set @d=2; execute upd_sql using @c, @d; select * from foo;