如何在实际的《选举声明》中使用职能参数
CREATE FUNCTION GetDefaultLangText(tableName VARCHAR(50), fieldName VARCHAR(50))
RETURNS VARCHAR(200) DETERMINISTIC
BEGIN
Select fieldName from tableName
END
它告诉我,这确实没有工作。 姓名当然确实存在,但我真的想要的是,在变量表Name(和外地名称)中拿出实际价值。
如何在实际的《选举声明》中使用职能参数
CREATE FUNCTION GetDefaultLangText(tableName VARCHAR(50), fieldName VARCHAR(50))
RETURNS VARCHAR(200) DETERMINISTIC
BEGIN
Select fieldName from tableName
END
它告诉我,这确实没有工作。 姓名当然确实存在,但我真的想要的是,在变量表Name(和外地名称)中拿出实际价值。
在MySQL的变数必须用@
预先确定,否则它们就被视为原始外地/表名......
SELECT @fieldName FROM @tableName
然而,这 s是允许的。 不能通过变数将外地名称和表名插入查询:。 MySQL 存储程序动态变更表。 因此,改变你的询问,不会解决更大的问题。
Something similar has been posted awhile back: use a variable for table name in mysql sproc
你们可以像:
PREPARE stmt FROM @sqltext; EXECUTE stmt USING @temptable; DEALLOCATE PREPARE stmt;
qltext是一种可以包含质子的扼杀。
I noticed that there were some threads with similar questions, and I did look through them but did not really get a convincing answer. Here s my question: The subquery below returns a Table with 3 ...
<?php $con=mysql_connect("localhost","mts","mts"); if(!con) { die( unable to connect . mysql_error()); } mysql_select_db("mts",$con); /* date_default_timezone_set ("Asia/Calcutta"); $date = ...
我把我的用心从使用QQL转向MySQL。 它与凯科特合作,现在不工作,因为我已经改变,使用MySQL。 这里的错误信息是:
We have a restaurant table that has lat-long data for each row. We need to write a query that performs a search to find all restaurants within the provided radius e.g. 1 mile, 5 miles etc. We have ...
Is it possible in php to return a specific row of data from a mysql query? None of the fetch statements that I ve found return a 2 dimensional array to access specific rows. I want to be able to ...
Our website was developed with a meta tag set to... <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> This works fine for M-dashes and special quotes, etc. However, I ...
What are some of the strategies being used for pagination of data sets that involve complex queries? count(*) takes ~1.5 sec so we don t want to hit the DB for every page view. Currently there are ~...
My table looks like person_id | car_id | miles ------------------------------ 1 | 1 | 100 1 | 2 | 200 2 | 3 | 1000 2 | 4 | 500 I need to ...