mysql 动态 SQL 语语

set @tbnm="user";

set @p1="nickname";

set @p2="asd";

set @frist_sql=concat("select ",@p1," from ",@tbnm," where nickname = '",@p2,"'");

prepare stmt from @frist_sql;

EXECUTE stmt;