MySQL 動態 SQL 範例

SET @tab = 'a';
SET @s = CONCAT('select * from ', @tab, ' where ID = 1');

PREPARE stmt1 FROM @s;
EXECUTE stmt1;
DEALLOCATE PREPARE stmt1;