我需要从动态查询中插入到表中。我尝试使用prepare和execute语句，但它不起作用。请帮帮我哪里做错了。

SET v_SQL = 'Select * from Patient';
DROP TEMPORARY TABLE IF EXISTS AlcoholTable;
CREATE TEMPORARY TABLE  AlcoholTable ( PatientId int ,MRNNo varchar(500),Gender varchar(500))        
Insert into  AlcoholTable
SET stmt_str = v_SQL;
PREPARE stmt FROM  stmt_str;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;