您必须使用准备好的语句来执行此操作。就像是:
SET @s = CONCAt('select * from ', @Cat, ' where ID = ', @ID_1);PREPARE stmt1 FROM @s; EXECUTE stmt1; DEALLOCATE PREPARE stmt1;
您必须使用准备好的语句来执行此操作。就像是:
SET @s = CONCAt('select * from ', @Cat, ' where ID = ', @ID_1);PREPARE stmt1 FROM @s; EXECUTE stmt1; DEALLOCATE PREPARE stmt1;