At 19:18 -0700 5/25/05, Scott Klarenbach wrote:
Am I correct in assuming that MySQL requires string literals in stored
procedures for the following clauses:
LIMIT requires integer constants, not strings.
The filename for LOAD DATA INFILE should be a literal string, as you surmise.
Don't know about REGEXP.
REGEXP, LIMIT and LOAD DATA INFILE?
For example, I cannot seem to pass in the {pattern} as a parameter to
my SPROC, and then query for ...WHERE field REGEXP pattern
I'm having the same problem passing in the {count,offset} parameters
for LIMIT clauses, and the {filename} for LOAD DATA INFILE.
Thanks for any insights.
Scott Klarenbach
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
