prepare SQL 格式

set @s = 'SELECT * FROM employees WHERE emp_no = ?'
set @a = 100000;
PREPARE stmt FROM @s;
EXECUTE stmt USING @a;
DEALLOCATE PREPARE stmt;

 

posted @ 2021-09-14 14:05  learnnote  阅读(68)  评论(0)    收藏  举报