mysql prepare stmt 셈플
-- --------------------------------------------------------------------------------
-- Routine DDL
-- Note: comments before and after the routine body will not be stored by the server
-- --------------------------------------------------------------------------------
DELIMITER $$
CREATE PROCEDURE `getmemberid` (
p_member_no int
)
BEGIN
set @_p_member_no = p_member_no;
set @_sql = "select userid from memeber where memeberno = ?";
prepare stmt from @_sql;
execute stmt using
@_p_member_no;
deallocate prepare stmt;
END