我如何在MYSQL中使用Concat表名!! [英] How do I Concat table name in MYSQL !!
本文介绍了我如何在MYSQL中使用Concat表名!!的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
CREATE PROCEDURE` CalendarMessage_GetBydateUC`(
_date varchar(255),
_usercode varchar(255),
_title varchar(255)
)
BEGIN
从CONCAT(_usercode,_ Timeline)中选择*,其中dateCreated = _date和userTo = _usercode和operation = _title;
END;
CREATE PROCEDURE `CalendarMessage_GetBydateUC`(
_date varchar(255),
_usercode varchar(255),
_title varchar(255)
)
BEGIN
select * from CONCAT(_usercode, "_Timeline") where dateCreated=_date and userTo = _usercode and operation = _title;
END;
推荐答案
DECLARE query1 TEXT;
SET query1 = CONCAT('select * from ', _usercode, '_Timeline','where dateCreated=_date and userTo = _usercode and operation = _title;')
SET @Sql = query1;
PREPARE STMT FROM @Sql;
EXECUTE STMT;
DEALLOCATE PREPARE STMT;
这篇关于我如何在MYSQL中使用Concat表名!!的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文