将参数传递给 MySQL 视图 [英] Passing parameter to MySQL View
问题描述
我正在尝试将参数传递给我创建的视图.这是我的代码.
I am trying to pass a parameter to a view that I have created. This is my code.
CREATE FUNCTION param1() RETURNS VARCHAR(50) DETERMINISTIC NO SQL RETURN @param1;
CREATE VIEW `view_stats` AS SELECT * FROM `history` WHERE fullname = param1() ;
这是我的查询
SELECT st.*, mtr.max_open_trades, mtr.max_draw_down FROM `view_stats` AS ST INNER JOIN `mtrecords` AS mtr ON st.login = mtr.login WHERE st.login=?
如何向此查询的 view_stats
传递参数?
How can I pass a parameter to the view_stats
on this query?
推荐答案
是的,您可以通过创建从会话变量中获取值的函数,以简单的方式将参数传递给视图.有关该技术,请参阅 https://www.stackoverflow.com/questions/14511760.这是我的 create 函数的副本,您可能希望效仿.分隔符//
Yes, you can pass parameters to your views in a simple manner by creating a Function to GET your values from Session Variables. See https://www.stackoverflow.com/questions/14511760 for the technique. This is a copy of my create function you may wish to pattern after. DELIMITER //
创建函数 fn_getcase_id()
退货中等(11)确定性无 SQL开始
CREATE FUNCTION fn_getcase_id()
RETURNS MEDIUMINT(11)
DETERMINISTIC NO SQL
BEGIN
RETURN @sv_case_id;
结束//
分隔符;您需要创建一个类似的 FN(每个变量一个).
DELIMITER ; You will need to create a similar FN (one for each variable).
这篇关于将参数传递给 MySQL 视图的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!