mysql变量set_mysql变量-set@var

我正在尝试创建一个MySQL代码段,该代码段将分析表并删除重复条目(重复项基于两个字段,而不是整个记录)

我有以下代码,当我硬编码查询中的变量时可以使用,但是当我将它们取出并作为变量放入时,我会得到MySQL错误,下面是脚本:

SET @tblname = 'mytable';

SET @fieldname = 'myfield';

SET @concat1 = 'checkfield1';

SET @concat2 = 'checkfield2';

ALTER TABLE @tblname ADD `tmpcheck` VARCHAR( 255 ) NOT NULL;

UPDATE @tblname SET `tmpcheck` = CONCAT(@concat1,'-',@concat2);

CREATE TEMPORARY TABLE `tmp_table` (

`tmpfield` VARCHAR( 100 ) NOT NULL

) ENGINE = MYISAM ;

INSERT INTO `tmp_table` (`tmpfield`) SELECT @fieldname FROM @tblname GROUP BY `tmpcheck` HAVING ( COUNT(`tmpcheck`) > 1 );

DELETE FROM @tblname WHERE @fieldname IN (SELECT `tmpfield` FROM `tmp_table`);

ALTER TABLE @tblname DROP `tmpcheck`;

我收到以下错误:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '@tblname ADD `tmpcheck` VARCHAR( 255 ) NOT NULL' at line 1

这是因为我不能为表名使用变量吗?还有什么可能是错误的,或者我如何解决这个问题。