方法一:
set @SQL ='select * from Test where id=?';
set @ID=1;
prepare stmt from @SQL;
execute stmt using @ID;方法二:
set @SQL ='select * from Test where id=@ID';
set @ID=1;
prepare stmt from @SQL;
execute stmt ;这两种写法执行起来有区别不?
set @SQL ='select * from Test where id=?';
set @ID=1;
prepare stmt from @SQL;
execute stmt using @ID;方法二:
set @SQL ='select * from Test where id=@ID';
set @ID=1;
prepare stmt from @SQL;
execute stmt ;这两种写法执行起来有区别不?
如果using后面跟的是局部变量的话,还可以理解.用全局变量的话,直接写在SQL里面不就结了.