mysql 中如何查询拼接表名

SET @pddl = concat('select * from user', @var)

PREPARE stmt FROM @pddl/*定义预处理语句*/

EXECUTE stmt/*执行预处理语句*/

DEALLOCATE PREPARE stmt/*释放预处理语句*/

SET

@pddl

=

concat('select

*

from

user',

@var)

PREPARE

stmt

FROM

@pddl/*定义预处理语句*/

EXECUTE

stmt/*执行预处理语句*/

DEALLOCATE

PREPARE

stmt/*释放预处理语句*/